VIEW: APPS.CE_REVERSAL_AR_TRX_V

Source

View Text - Preformatted

SELECT CRH.CASH_RECEIPT_HISTORY_ID , CR.RECEIPT_NUMBER , CR.CURRENCY_CODE , CRH.AMOUNT , CRH.TRX_DATE , RM.NAME , CR.RECEIPT_METHOD_ID , L1.MEANING , ABA.BANK_ACCOUNT_NAME , CR.REMITTANCE_BANK_ACCOUNT_ID , B.NAME , CRH.BATCH_ID , DECODE(ABA.CURRENCY_CODE,SOB.CURRENCY_CODE,CRH.ACCTD_AMOUNT, CRH.AMOUNT) , CR.PAY_FROM_CUSTOMER , HZ.PARTY_NAME , HZ.PARTY_NUMBER FROM GL_SETS_OF_BOOKS SOB, CE_SYSTEM_PARAMETERS SYS, CE_BANK_ACCOUNTS ABA, AR_LOOKUPS L1, hz_cust_accounts cu, hz_parties hz, AR_RECEIPT_METHODS RM, AR_BATCHES B, AR_CASH_RECEIPTS CR, AR_CASH_RECEIPT_HISTORY CRH WHERE SOB.SET_OF_BOOKS_ID (+) = SYS.SET_OF_BOOKS_ID AND ABA.ACCOUNT_OWNER_ORG_ID = SYS.LEGAL_ENTITY_ID (+) AND ABA.BANK_ACCOUNT_ID(+) = CR.REMITTANCE_BANK_ACCOUNT_ID AND L1.LOOKUP_TYPE = 'RECEIPT_CREATION_STATUS' AND L1.LOOKUP_CODE = CRH.STATUS AND cu.cust_account_id(+) = CR.PAY_FROM_CUSTOMER AND hz.party_id(+) = cu.party_id AND RM.RECEIPT_METHOD_ID = CR.RECEIPT_METHOD_ID AND B.BATCH_ID(+) = CRH.BATCH_ID AND CR.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID AND CRH.CURRENT_RECORD_FLAG = 'Y' AND CRH.STATUS IN ( 'REMITTED', 'CLEARED', 'REVERSED', 'RISK_ELIMINATED')

View Text - HTML Formatted

SELECT CRH.CASH_RECEIPT_HISTORY_ID
, CR.RECEIPT_NUMBER
, CR.CURRENCY_CODE
, CRH.AMOUNT
, CRH.TRX_DATE
, RM.NAME
, CR.RECEIPT_METHOD_ID
, L1.MEANING
, ABA.BANK_ACCOUNT_NAME
, CR.REMITTANCE_BANK_ACCOUNT_ID
, B.NAME
, CRH.BATCH_ID
, DECODE(ABA.CURRENCY_CODE
, SOB.CURRENCY_CODE
, CRH.ACCTD_AMOUNT
, CRH.AMOUNT)
, CR.PAY_FROM_CUSTOMER
, HZ.PARTY_NAME
, HZ.PARTY_NUMBER
FROM GL_SETS_OF_BOOKS SOB
, CE_SYSTEM_PARAMETERS SYS
, CE_BANK_ACCOUNTS ABA
, AR_LOOKUPS L1
, HZ_CUST_ACCOUNTS CU
, HZ_PARTIES HZ
, AR_RECEIPT_METHODS RM
, AR_BATCHES B
, AR_CASH_RECEIPTS CR
, AR_CASH_RECEIPT_HISTORY CRH
WHERE SOB.SET_OF_BOOKS_ID (+) = SYS.SET_OF_BOOKS_ID
AND ABA.ACCOUNT_OWNER_ORG_ID = SYS.LEGAL_ENTITY_ID (+)
AND ABA.BANK_ACCOUNT_ID(+) = CR.REMITTANCE_BANK_ACCOUNT_ID
AND L1.LOOKUP_TYPE = 'RECEIPT_CREATION_STATUS'
AND L1.LOOKUP_CODE = CRH.STATUS
AND CU.CUST_ACCOUNT_ID(+) = CR.PAY_FROM_CUSTOMER
AND HZ.PARTY_ID(+) = CU.PARTY_ID
AND RM.RECEIPT_METHOD_ID = CR.RECEIPT_METHOD_ID
AND B.BATCH_ID(+) = CRH.BATCH_ID
AND CR.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
AND CRH.CURRENT_RECORD_FLAG = 'Y'
AND CRH.STATUS IN ( 'REMITTED'
, 'CLEARED'
, 'REVERSED'
, 'RISK_ELIMINATED')