AR Cash Receipt Query - Oracle APPS Consultancy

Home » Ar_cash_receipts_all Status Meaning » AR Cash Receipt Query - Oracle APPS Consultancy

Maybe your like

Title

  • Home
  • APPS
  • PLSQL
  • PO
  • OM
  • Inventory
  • AR
  • GL
  • Form
  • Forms Personlization
  • Report

Tuesday, 30 April 2013

AR Cash Receipt Query

SELECT ACR.ATTRIBUTE1 CHECK_ID , ACR.ATTRIBUTE2 CHECK_NUMBER , ACR.ATTRIBUTE6 RECEIPT_DATE , RCT.TRX_NUMBER AR_INV_NUMBER , ARM.NAME PAYMENT_METHOD , TO_CHAR(ACR.REVERSAL_DATE,'DD-MON-YYYY') AR_RECEIPT_REVERSAL_DATE , AL.MEANING RECEIPT_STATUS , HOU.NAME OPERATING_UNIT_NAME , ACR.RECEIPT_NUMBER AR_RECEIPT_NUMBER , TO_CHAR(ACR.RECEIPT_DATE,'DD-MON-YYYY') AR_RECEIPT_DATE , ACR.CURRENCY_CODE ENTERED_CURRENCY_CODE , ACR.AMOUNT*SIGN(ARA.ACCTD_AMOUNT_APPLIED_FROM) ENTERED_AMOUNT , GSOB.CURRENCY_CODE ACCOUNTED_CURRENCY_CODE , ARA.ACCTD_AMOUNT_APPLIED_FROM ACCOUNTED_AMOUNT , GCCK.CONCATENATED_SEGMENTS CASH_GL_ACCOUNT , GCCK.SEGMENT1 RECEIPT_LE_ME , ABA.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUMBER , ABB.BANK_NAME BANK_NAME , ACR.ORG_ID , ACR.STATUS , ACR.CASH_RECEIPT_ID , ACR.REMITTANCE_BANK_ACCOUNT_ID -- ,ARA.APPLIED_CUSTOMER_TRX_ID -- ,ARA.CODE_COMBINATION_ID , ARM.RECEIPT_METHOD_ID , ABA.BANK_ACCOUNT_ID , ABB.BANK_BRANCH_ID FROM APPS.RA_CUSTOMER_TRX_ALL RCT , APPS.AR_RECEIPT_METHODS ARM , APPS.AR_CASH_RECEIPTS_ALL ACR , APPS.AR_RECEIVABLE_APPLICATIONS_ALL ARA, APPS.GL_SETS_OF_BOOKS GSOB , APPS.GL_CODE_COMBINATIONS_KFV GCCK , APPS.AP_BANK_ACCOUNTS_ALL ABA , APPS.AP_BANK_BRANCHES ABB , APPS.HR_OPERATING_UNITS HOU , APPS.AR_LOOKUPS AL , APPS.AR_RECEIPT_METHOD_ACCOUNTS_ALL ARMA WHERE acr.cash_receipt_id = ara.cash_receipt_id AND acr.receipt_method_id = arm.receipt_method_id AND ara.applied_customer_trx_id = rct.customer_trx_id(+) AND acr.set_of_books_id = gsob.set_of_books_id AND arma.cash_ccid = gcck.code_combination_id AND arm.receipt_method_id = arma.receipt_method_id AND aba.bank_account_id = arma.bank_account_id AND acr.remittance_bank_account_id = aba.bank_account_id AND aba.bank_branch_id = abb.bank_branch_id AND acr.org_id = hou.organization_id AND al.lookup_type = 'CHECK_STATUS' AND acr.status = al.lookup_code Posted by at 09:08 Labels: AR

No comments:

Post a Comment

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

Blog Archive

  • ▼  2013 (275)
    • ▼  April (32)
      • AR Cash Receipt Query
      • What is TCA (Trading Community Architecture)?
      • What is the difference between ORG_ID & ORGANIZATI...
      • GL_QUERY
      • What are Key and Descriptive Flexfield?
      • What is Flexfields?
      • What is Current record attribute property?
      • Which trigger related to mouse?
      • Difference between VAT and Property Class?
      • Can a Property class itself be based on a property...
      • What are property classes? Can property classes ha...
      • How do I recover the responsibilities in apps if i...
      • Responsibilities Table?
      • Can a responsibility be assigned to multiple users?
      • How many responsibilities can be defined for a Mod...
      • Can u change VAT at run time?
      • What is a Visual attributes (VAT)?
      • What is OLE Activation style property?
      • Can you have VBX and OCX controls in forms?
      • Can you change the mouse pointer?
      • Which trigger are created when master -detail rela...
      • Query to findout the Responsibilites name from Req...
      • Query to findout the Responsibilites name from CP
      • What are the types of layouts in reports?
      • Master-Detail Relation in Oracle Form
      • Match Approval Level
      • Types of Purchase Orders
      • Submitting Concurrent Program from Back-end
      • FND_REQUEST.SUBMIT_REQUEST:
      • How to attach concurrent program to request group ...
      • How to register concurrent program from back end i...
      • How to register concurrent executable from back en...

About Me

My photo Sandeep Sharma I have 9.5 year experience in Oracle Technologies PLSQL, FORM, REPORT and APPS. Mo:+91-9703879708 Mail Id: [email protected] View my complete profile

Tag » Ar_cash_receipts_all Status Meaning