VIEW: APPS.OKL_BPD_TRX_RCPT_HEADER_V

Source

View Text - Preformatted

SELECT ARAPP.AMOUNT_APPLIED, ARCASH.RECEIPT_NUMBER, ARRCPT.NAME, ARCASH.RECEIPT_DATE, CNSLD.ID, ARCASH.AMOUNT TOTAL_AMOUNT, ARCASH.currency_code, ARCASH.cash_receipt_id RECEIPT_ID, PMTSCH.trx_number RECEIVABLE_INVOICE_NUMBER, ARCASH.STATUS STATUS, NULL DESCRIPTION, CNSLD.KHR_ID CONTRACT_ID, CHR.CONTRACT_NUMBER CONTRACT_NUMBER, ARCASH.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ARCASH.ORG_ID ORG_ID, 'REC' SOURCE_CODE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_VIEW_ACC_SOURCES','REC') SOURCE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_VIEW_TRANSACTIONS', 'RECEIPT') TRANSACTION_TYPE, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('RECEIPT_CREATION_STATUS', ARCASH.STATUS) TRANSACTION_STATUS FROM OKL_CNSLD_AR_STRMS_B CNSLD,AR_PAYMENT_SCHEDULES_ALL PMTSCH,AR_RECEIVABLE_APPLICATIONS_ALL ARAPP,AR_CASH_RECEIPTS_ALL ARCASH,AR_RECEIPT_METHODS ARRCPT,OKL_CNSLD_AR_LINES_B LN,OKL_CNSLD_AR_HDRS_B HD,OKC_K_HEADERS_B CHR WHERE CNSLD.RECEIVABLES_INVOICE_ID = PMTSCH.CUSTOMER_TRX_ID AND ARRCPT.RECEIPT_METHOD_ID = ARCASH.RECEIPT_METHOD_ID and ARAPP.applied_payment_schedule_id = PMTSCH.payment_schedule_id and PMTSCH.class = 'INV' and ARAPP.cash_receipt_id = ARCASH.cash_receipt_id AND LN.ID = CNSLD.LLN_ID AND HD.ID = LN.CNR_ID AND CNSLD.KHR_ID = CHR.ID UNION SELECT ARAPP.AMOUNT_APPLIED, ARCASH.RECEIPT_NUMBER, ARRCPT.NAME, ARCASH.RECEIPT_DATE, ARL.TXD_ID, ARCASH.AMOUNT TOTAL_AMOUNT, ARCASH.currency_code, ARCASH.cash_receipt_id RECEIPT_ID, PMTSCH.trx_number RECEIVABLE_INVOICE_NUMBER, ARCASH.STATUS STATUS, NULL DESCRIPTION, ARL.CONTRACT_ID CONTRACT_ID, CHR.CONTRACT_NUMBER CONTRACT_NUMBER, ARCASH.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ARCASH.ORG_ID ORG_ID, 'REC' SOURCE_CODE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_VIEW_ACC_SOURCES','REC') SOURCE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_VIEW_TRANSACTIONS', 'RECEIPT') TRANSACTION_TYPE, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('RECEIPT_CREATION_STATUS', ARCASH.STATUS) TRANSACTION_STATUS FROM AR_PAYMENT_SCHEDULES_ALL PMTSCH, AR_RECEIVABLE_APPLICATIONS_ALL ARAPP, AR_CASH_RECEIPTS_ALL ARCASH, AR_RECEIPT_METHODS ARRCPT, okl_bpd_ar_inv_lines_v ARL, OKC_K_HEADERS_B CHR WHERE ARL.RECEIVABLES_INVOICE_ID = PMTSCH.CUSTOMER_TRX_ID AND ARRCPT.RECEIPT_METHOD_ID = ARCASH.RECEIPT_METHOD_ID and ARAPP.applied_payment_schedule_id = PMTSCH.payment_schedule_id and PMTSCH.class = 'INV' and ARAPP.cash_receipt_id = ARCASH.cash_receipt_id AND ARAPP.CUSTOMER_TRX_ID = ARL.RECEIVABLES_INVOICE_ID AND ARAPP.APPLIED_CUSTOMER_TRX_LINE_ID = ARL.RECEIVABLES_INVOICE_LINE_ID AND ARL.CONTRACT_ID = CHR.ID

View Text - HTML Formatted

SELECT ARAPP.AMOUNT_APPLIED
, ARCASH.RECEIPT_NUMBER
, ARRCPT.NAME
, ARCASH.RECEIPT_DATE
, CNSLD.ID
, ARCASH.AMOUNT TOTAL_AMOUNT
, ARCASH.CURRENCY_CODE
, ARCASH.CASH_RECEIPT_ID RECEIPT_ID
, PMTSCH.TRX_NUMBER RECEIVABLE_INVOICE_NUMBER
, ARCASH.STATUS STATUS
, NULL DESCRIPTION
, CNSLD.KHR_ID CONTRACT_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, ARCASH.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ARCASH.ORG_ID ORG_ID
, 'REC' SOURCE_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_VIEW_ACC_SOURCES'
, 'REC') SOURCE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_VIEW_TRANSACTIONS'
, 'RECEIPT') TRANSACTION_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('RECEIPT_CREATION_STATUS'
, ARCASH.STATUS) TRANSACTION_STATUS
FROM OKL_CNSLD_AR_STRMS_B CNSLD
, AR_PAYMENT_SCHEDULES_ALL PMTSCH
, AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
, AR_CASH_RECEIPTS_ALL ARCASH
, AR_RECEIPT_METHODS ARRCPT
, OKL_CNSLD_AR_LINES_B LN
, OKL_CNSLD_AR_HDRS_B HD
, OKC_K_HEADERS_B CHR
WHERE CNSLD.RECEIVABLES_INVOICE_ID = PMTSCH.CUSTOMER_TRX_ID
AND ARRCPT.RECEIPT_METHOD_ID = ARCASH.RECEIPT_METHOD_ID
AND ARAPP.APPLIED_PAYMENT_SCHEDULE_ID = PMTSCH.PAYMENT_SCHEDULE_ID
AND PMTSCH.CLASS = 'INV'
AND ARAPP.CASH_RECEIPT_ID = ARCASH.CASH_RECEIPT_ID
AND LN.ID = CNSLD.LLN_ID
AND HD.ID = LN.CNR_ID
AND CNSLD.KHR_ID = CHR.ID UNION SELECT ARAPP.AMOUNT_APPLIED
, ARCASH.RECEIPT_NUMBER
, ARRCPT.NAME
, ARCASH.RECEIPT_DATE
, ARL.TXD_ID
, ARCASH.AMOUNT TOTAL_AMOUNT
, ARCASH.CURRENCY_CODE
, ARCASH.CASH_RECEIPT_ID RECEIPT_ID
, PMTSCH.TRX_NUMBER RECEIVABLE_INVOICE_NUMBER
, ARCASH.STATUS STATUS
, NULL DESCRIPTION
, ARL.CONTRACT_ID CONTRACT_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, ARCASH.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ARCASH.ORG_ID ORG_ID
, 'REC' SOURCE_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_VIEW_ACC_SOURCES'
, 'REC') SOURCE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_VIEW_TRANSACTIONS'
, 'RECEIPT') TRANSACTION_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('RECEIPT_CREATION_STATUS'
, ARCASH.STATUS) TRANSACTION_STATUS
FROM AR_PAYMENT_SCHEDULES_ALL PMTSCH
, AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
, AR_CASH_RECEIPTS_ALL ARCASH
, AR_RECEIPT_METHODS ARRCPT
, OKL_BPD_AR_INV_LINES_V ARL
, OKC_K_HEADERS_B CHR
WHERE ARL.RECEIVABLES_INVOICE_ID = PMTSCH.CUSTOMER_TRX_ID
AND ARRCPT.RECEIPT_METHOD_ID = ARCASH.RECEIPT_METHOD_ID
AND ARAPP.APPLIED_PAYMENT_SCHEDULE_ID = PMTSCH.PAYMENT_SCHEDULE_ID
AND PMTSCH.CLASS = 'INV'
AND ARAPP.CASH_RECEIPT_ID = ARCASH.CASH_RECEIPT_ID
AND ARAPP.CUSTOMER_TRX_ID = ARL.RECEIVABLES_INVOICE_ID
AND ARAPP.APPLIED_CUSTOMER_TRX_LINE_ID = ARL.RECEIVABLES_INVOICE_LINE_ID
AND ARL.CONTRACT_ID = CHR.ID