AR Receipt Query - ORACLE EBS PL/SQL

Home » Ar_cash_receipts_all Query » AR Receipt Query - ORACLE EBS PL/SQL

Maybe your like

Monday, 1 June 2015

AR Receipt Query

select --cr.RECEIPT_NUMBER, cr.RECEIPT_DATE R_DATE, cr.AMOUNT R_AMOUNT, cr.CUSTOMER_RECEIPT_REFERENCE R_Check_No, ct.BILL_TO_CUSTOMER_ID R_CUSTOMER, CR.ORG_ID, ct.TRX_NUMBER from AR_CASH_RECEIPTS_ALL cr, ra_customer_trx_all ct, ar_receivable_applications_all app, ra_terms rt where /*cr.CUSTOMER_RECEIPT_REFERENCE is not null and */cr.STATUS = 'APP' and app.APPLIED_CUSTOMER_TRX_ID = ct.CUSTOMER_TRX_ID and app.CASH_RECEIPT_ID = cr.CASH_RECEIPT_ID and rt.term_id = ct.TERM_ID-- and (upper(rt.name) = upper('CASH') OR (upper(rt.name) like 'PDC%')) and cr.ORG_ID = ct.ORG_ID--and cr.ORG_ID = 221; By - June 01, 2015 Labels: AR, query, Receipt

No comments:

Post a Comment

Newer Post Older Post Home Subscribe to: Post Comments (Atom)

Query to Find Receipt Class and its GL Combinition Query

SELECT ARC.NAME ReceiptClass,        ARC.CREATION_METHOD_CODE Creation_Mehthod,        DECODE (ARC.REMIT_METHOD_CODE,             ...

  • Account Recievables Module (AR) Explanation (Recievables Useful Information) Accounts Receivables useful information ACCOUNTS RECEIVABLES: ==================== ACCOUNTING METHOD , ACCRUAL OR CASH :     So do you...
  • Query to find Active Customer in Oracle Apps SELECT hou.name Organization_name,        ----------------------        --Customer Information        ----------------------    ...
  • Important Join conditions between Oracle apps modules GL AND AP GL_CODE_COMBINATIONS          AP_INVOICES_ALL               code_combination_id        =        acct_pay_code_combination_id G...

Search This Blog

Total Pageviews

Pages

  • Home
  • AR
  • AP
  • GL
  • OM
  • Inventory
  • Oracle Apps Tables
  • Others
  • Interface

Blog Archive

  • ▼  2015 (77)
    • ▼  June (1)
      • AR Receipt Query

About Me

Unknown View my complete profile

Report Abuse

  • Usefull Links

Tag » Ar_cash_receipts_all Query