VIEW: APPS.OKL_RECEIPT_SUMMARY_UV

Source

View Text - Preformatted

SELECT arcash.cash_receipt_id, arcash.receipt_number, arcash.receipt_date, arcash.currency_code, arcash.org_id, hr.NAME, arcash.legal_entity_id, arcash.amount, crh.Status, arcash.pay_from_customer, hca.account_number, hzp.party_number, hzp.party_name, rm.NAME, rm.receipt_method_id, crh.gl_date, decode(oklrcpt.receipt_type,'ADV',oklrcpt.receipt_type,'REG') receipt_type FROM ar_Cash_receipts_All arcash, hz_cust_accounts_all hca, hz_parties hzp, ar_receipt_methods rm, hr_operating_units hr, ar_Cash_receipt_history_all crh, okl_trx_csh_rcpt_all_b oklrcpt WHERE arcash.pay_from_customer = hca.cust_account_id(+) AND hca.party_id = hzp.party_id(+) AND arcash.receipt_method_id = rm.receipt_method_id AND arcash.org_id = hr.organization_id AND arcash.cash_receipt_id = crh.cash_receipt_id AND crh.current_record_flag = 'Y' AND arcash.cash_receipt_id = oklrcpt.cash_receipt_id(+) AND oklrcpt.receipt_type(+) = 'ADV'

View Text - HTML Formatted

SELECT ARCASH.CASH_RECEIPT_ID
, ARCASH.RECEIPT_NUMBER
, ARCASH.RECEIPT_DATE
, ARCASH.CURRENCY_CODE
, ARCASH.ORG_ID
, HR.NAME
, ARCASH.LEGAL_ENTITY_ID
, ARCASH.AMOUNT
, CRH.STATUS
, ARCASH.PAY_FROM_CUSTOMER
, HCA.ACCOUNT_NUMBER
, HZP.PARTY_NUMBER
, HZP.PARTY_NAME
, RM.NAME
, RM.RECEIPT_METHOD_ID
, CRH.GL_DATE
, DECODE(OKLRCPT.RECEIPT_TYPE
, 'ADV'
, OKLRCPT.RECEIPT_TYPE
, 'REG') RECEIPT_TYPE
FROM AR_CASH_RECEIPTS_ALL ARCASH
, HZ_CUST_ACCOUNTS_ALL HCA
, HZ_PARTIES HZP
, AR_RECEIPT_METHODS RM
, HR_OPERATING_UNITS HR
, AR_CASH_RECEIPT_HISTORY_ALL CRH
, OKL_TRX_CSH_RCPT_ALL_B OKLRCPT
WHERE ARCASH.PAY_FROM_CUSTOMER = HCA.CUST_ACCOUNT_ID(+)
AND HCA.PARTY_ID = HZP.PARTY_ID(+)
AND ARCASH.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID
AND ARCASH.ORG_ID = HR.ORGANIZATION_ID
AND ARCASH.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
AND CRH.CURRENT_RECORD_FLAG = 'Y'
AND ARCASH.CASH_RECEIPT_ID = OKLRCPT.CASH_RECEIPT_ID(+)
AND OKLRCPT.RECEIPT_TYPE(+) = 'ADV'