Query : To Query Receipt Accounting Entries -I - Apps Query

Home » Ar_cash_receipt_history_all Query » Query : To Query Receipt Accounting Entries -I - Apps Query

Maybe your like

Apps Query

Developers in 11i/R12 EBS are in a race with the Universe to create better idiot-proof programs, while the Universe is trying to create better idiots. So far the Universe is winning.

  • Home
  • Business
    • Internet
    • Market
    • Stock
  • Downloads
    • Dvd
    • Games
    • Software
      • Office
  • Parent Category
    • Child Category 1
      • Sub Child Category 1
      • Sub Child Category 2
      • Sub Child Category 3
    • Child Category 2
    • Child Category 3
    • Child Category 4
  • Featured
  • Health
    • Childcare
    • Doctors
  • Uncategorized

Recent Posts

Categories

AIM (3) AOL (23) AP (15) API (14) AR (19) CE (1) DFF (1) EAM (1) Enterprises Model (6) FA (18) GL (10) How (15) HRMS (19) IB (1) Info (11) INV (5) Issue (1) Locking (2) Misc (1) More4Apps (1) OE (2) OKC (2) OKE (1) OKS (4) OM (4) Oracle (3) Oracle Applications (10) Oracle Price Lists (1) Oracle Product (1) Payroll (2) PJM (1) PO (7) Project Accounting (2) Query (96) R12 (5) Reconcilation (2) Sample (1) WorkFlow (2) WSH (6)

Definition List

Query : To query Receipt Accounting entries -I

3:12 PM AR, Query 1 comment SELECT amount_dr, amount_cr, acctd_amount_dr, acctd_amount_cr, gcc.segment1 || '.' || gcc.segment2 || '.' || gcc.segment3 || '.' || gcc.segment4 || '.' || gcc.segment5 ACCOUNT FROM ar.ar_distributions_all ad, gl.gl_code_combinations gcc WHERE source_table = 'CRH' AND EXISTS ( SELECT 'T' FROM ar.ar_cash_receipt_history_all a, ar.ar_cash_receipts_all b WHERE a.cash_receipt_id = b.cash_receipt_id AND source_id = cash_receipt_history_id AND b.org_id = '&org_id' AND b.org_id = a.org_id AND b.receipt_number LIKE '%&receipt_number%') AND ad.code_combination_id = gcc.code_combination_id UNION ALL SELECT amount_dr, amount_cr, acctd_amount_dr, acctd_amount_cr, gcc.segment1 || '.' || gcc.segment2 || '.' || gcc.segment3 || '.' || gcc.segment4 || '.' || gcc.segment5 ACCOUNT FROM ar.ar_distributions_all ad, gl.gl_code_combinations gcc WHERE source_table = 'RA' AND EXISTS ( SELECT 'T' FROM ar.ar_receivable_applications_all a, ar.ar_cash_receipts_all b WHERE a.cash_receipt_id = b.cash_receipt_id AND a.receivable_application_id = source_id AND b.org_id = '&org_id' AND b.org_id = a.org_id AND b.receipt_number LIKE '%&receipt_number%') AND ad.code_combination_id = gcc.code_combination_id Newer Post Older Post Home

1 comments:

  1. MayurJanuary 5, 2020 at 9:43 PM

    This is not working for miscellaneous type

    ReplyDeleteReplies
      Reply
Add commentLoad more... Newer Post Older Post Home Subscribe to: Post Comments (Atom)

Social Profiles

TwitterFacebookGoogle PlusLinkedInRSS FeedEmail
  • Popular Posts
  • Archives
  • Query : Query to get Person type for All Employees SELECT PAPF.PERSON_ID, PAPF.FIRST_NAME AS FIRST_NAME, PAPF.LAST_NAME AS LAST_NAME, PAPF.EMPLOYEE_NUMBER AS EMPLOYEE_NUMBER, TO_CHAR(PAPF...
  • How : How to enable the DFF for the Lookup? If you want to enable the DFF and enter some additional entries in Lookups you just need to follow the below steps STEPS FOR YOU: Creat...
  • Query : To Check whether Periods of AP/AR/GL/FA/PO is closed? SELECT (SELECT sob.NAME FROM gl.gl_sets_of_books sob WHERE sob.set_of_books_id = a.set_of_books_id) "SOB_Nam...
  • Query : Get the Inventory org Address select * from hr_locations_v hlv, hr_all_organization_units hou WHERE hlv.inventory_organization_id = hou.organization_id AND hlv.locatio...
  • Query : Get the Serial Number for an Order SELECT wl.meaning release_status , wdd.released_status , wdd.source_line_id , wdd.source_code , wser.fm_serial_numbe...
  • Query : Sales Order Hold & Release SELECT OHA.ORDER_NUMBER, HS.HOLD_ENTITY_CODE CREDIT_CHECK_CRITERIA_CODE, FLV.MEANING CREDIT_CHECK_CRITERIA, HD.NAME ...
  • INFO: EMPLOYEE_CATEGORY holds in the table *PER_ALL_ASSIGNMENTS_F Employee Category is a lookup. the value that is in per_all_assignments_f for employee_category is the lookup_code that is stored. FND_COMM...
  • Query : To get Active Employees and Terminated Employees SELECT PAAF.ASSIGNMENT_ID, PAPF.PERSON_ID AS PERSON_ID2, PAPF.FIRST_NAME AS FIRST_NAME, PAPF.LAST_NAME AS LAST_NAME, PAPF.EMAIL_ADDRESS...
  • Query : Relation between Order Number & Contract Number Relation between Order Number (From Order Management) and Contract Number (From Service Contracts module). The relationship is maintained ...
  • Query to find out Move order line details SELECT wnd.delivery_id, ...

Blog Archive

  • ▼  2010 (120)
    • ▼  August (109)
      • INFO: Oracle Workflow APIs
      • Query : To get the Statement of expenses incurred ...
      • Query : INTRANSIT REPORT
      • INFO: AIM Documents for Techies & Techno Functional
      • Query : Asset migration
      • Query :
      • Query : To get Prepayment Invoice Status
      • INFO: Accounting lines in FA via SLA
      • Query : To get YTD Depreciation
      • Query : Get the Inventory org Address
      • Query : To get the list of Custom Alerts
      • Query : Retrieve Incomplete Invoices before month end
      • Query : To retrieve transactions with a certain am...
      • Query : To validate whether a transaction's REC is...
      • How : Amortized and Expensed Adjustments
      • Query : To query Receipt Accounting entries -II
      • Query : To query Receipt Accounting entries -I
      • Query : To Check whether Periods of AP/AR/GL/FA/PO...
      • Query : Verify that Multi Org is Installed
      • Query : Sales Order Hold & Release
      • Query : Get the Account Description
      • Query : Get Inventory Accounting Entries linked to GL
      • How : General Ledger and Accounts Payabels connect...
      • Query : AP to GL data transfer
      • Query : Subledger Transfer to GL
      • How : What are the tables involved in the Transfer...
      • Query : Drilldown from GL to Receiving Transactions
      • Query : Lists all the organization units in the sy...
      • Query : To get the asset detail information
      • Query : Check responsibility assigned to a specifi...
      • Query : To get all request with application
      • Query : To get assigned responsibility to a user
      • Query : Get the Hierarchial Information
      • Query : INVENTORY & ORDER MANAGEMENT
      • Setting Organization Context in Oracle R12
      • Oracle Price Lists
      • EAM
      • How : Item Import
      • Query to find subinventories for an inv organization
      • Query to find organization parameters of an inv org
      • Query to find Supplier sites
      • Query to find supplier info
      • Shipping APIs
      • Query to find delivery leg and pick up stop info
      • Query to find Bill of Lading info of the Delivery
      • Query to find out Move order line details
      • Query : AR to GL data transfer
      • Query : to find out the shipper info :
      • Query : To find PO returns
      • API: ORACLE SERVICE CONTRACT API’S
      • API : User Creation
      • Query : Purchase Order and Requisition
      • Query : Customer Listing with Bill To and Ship To ...
      • Query : To find an PO details
      • HOW: Contract Line Created in OKS
      • Query : Retrieve ex employees for last 3 months
      • Query : Finding Subordinates and their subordinates
      • Query : Find employee count
      • Data Mapping from Payroll to General Ledger when i...
      • Sample Code: For warranty contract creation for In...
      • How : Payroll is moved to GL
      • Query : Relation between Order Number & Contract N...
      • API : Contracts Migration API
      • Service contracts API
      • Salary History Conversion
      • How to create a report for various payroll runs
      • Interface from OTL to 3rd party payroll provider
      • Query : To get Active Employees and Terminated Emp...
      • INFO: EMPLOYEE_CATEGORY holds in the table *PER_AL...
      • Query : Job Change Date
      • API to use to update employee additional attributes
      • How to Purge Employee Record
      • Query : Query to get Person type for All Employees
      • API for loading qualification subjects on R12.1
      • Where is documentation for EBS API's
      • Automatically populate a Descriptive FlexField wit...
      • How to :Oracle Apps Concurrent Program : Host: pro...
      • How to Know Concurrent Program finishes
      • FND_USER_PKG
      • Query : Get Bank Information from HZ Tables
      • Query : Get assets category list
      • GL Tables which stores parent and child segments i...
      • Query :Operating Unit name based on the Operating ...
      • Query : Flexfields avilable for your Oracle Applic...
      • Query: AR Query to get open invoices for single/Al...
      • Query: To find Oracle API's for any module
      • Query :Requisition Number from PO Number
      • Confusion World: Examples of the to_date function
      • Diff bet ad_bugs and ad_appiled_patches tables
      • Query : Find the responsibilty for which form was ...
      • VLOOKUP function in M.S. Excel with example
      • Query: To find Patch Level for a product searching...
      • Query:Responsibility assigned to a specific USER
      • Query :Responsibility and attached request groups
      • Query : Active Alert information
      • Query :Employee Contact Information
      • Query : Responsibility to a Set of Books in Oracle
      • QUERY: Which Oracle Apps Version i am using
      • Query to List all the responsibilities attached to...
      • ssss

Text Widget

Download

Developers in 11i/R12 EBS are in a race with the Universe to create better idiot-proof programs, while the Universe is trying to create better idiots. So far the Universe is winning..
 

  • Labels

    • AIM
    • AOL
    • AP
    • API
    • AR
    • CE
    • DFF
    • EAM
    • Enterprises Model
    • FA
    • GL
    • How
    • HRMS
    • IB
    • Info
    • INV
    • Issue
    • Locking
    • Misc
    • More4Apps
    • OE
    • OKC
    • OKE
    • OKS
    • OM
    • Oracle
    • Oracle Applications
    • Oracle Price Lists
    • Oracle Product
    • Payroll
    • PJM
    • PO
    • Project Accounting
    • Query
    • R12
    • Reconcilation
    • Sample
    • WorkFlow
    • WSH

  • Pages

    • Home
Copyright © 2013 Apps Query | Powered by Blogger Design by FThemes | Blogger Theme by Lasantha - Distributed by: free blogger templates teachersfree blogger templates xml download | cheap vpn for iran best vpn mac china

Tag » Ar_cash_receipt_history_all Query