VIEW: APPS.OKL_BPD_CONTRACT_INVOICES_V

Source

View Text - Preformatted

SELECT HD.ID CONSOLIDATED_INVOICE_ID , HD.CONSOLIDATED_INVOICE_NUMBER CONSOLIDATED_INVOICE_NUMBER , ST.RECEIVABLES_INVOICE_ID RECEIVABLES_INVOICE_ID , ST.KHR_ID CONTRACT_ID , SP.ID STREAM_TYPE_ID , SP.ACCRUAL_YN REVENUE_REC_BASIS, PS.DUE_DATE DUE_DATE , HD.CURRENCY_CODE CURRENCY_CODE , PS.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL , PS.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING , PS.STATUS STATUS FROM AR_PAYMENT_SCHEDULES_ALL PS,OKL_CNSLD_AR_STRMS_B ST,OKL_CNSLD_AR_LINES_B LN,OKL_CNSLD_AR_HDRS_B HD,OKL_STRM_TYPE_B SP,OKC_K_HEADERS_ALL_B CN WHERE PS.CLASS IN ('INV', 'CM') AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID AND LN.ID = ST.LLN_ID AND HD.ID = LN.CNR_ID AND SP.ID = ST.STY_ID AND CN.ID = ST.KHR_ID UNION SELECT ARL.TXD_ID CONSOLIDATED_INVOICE_ID , ARL.RECEIVABLES_INVOICE_NUMBER CONSOLIDATED_INVOICE_NUMBER , ARL.RECEIVABLES_INVOICE_ID RECEIVABLES_INVOICE_ID , ARL.CONTRACT_ID CONTRACT_ID , SP.ID STREAM_TYPE_ID , SP.ACCRUAL_YN REVENUE_REC_BASIS, PS.DUE_DATE DUE_DATE , ARL.CURRENCY_CODE CURRENCY_CODE , PS.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL , PS.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING , PS.STATUS STATUS FROM AR_PAYMENT_SCHEDULES_ALL PS, okl_bpd_ar_inv_lines_v ARL, OKL_STRM_TYPE_B SP, OKC_K_HEADERS_ALL_B CN WHERE PS.CLASS IN ('INV', 'CM') AND ARL.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID AND SP.ID = ARL.STY_ID AND CN.ID = ARL.CONTRACT_ID

View Text - HTML Formatted

SELECT HD.ID CONSOLIDATED_INVOICE_ID
, HD.CONSOLIDATED_INVOICE_NUMBER CONSOLIDATED_INVOICE_NUMBER
, ST.RECEIVABLES_INVOICE_ID RECEIVABLES_INVOICE_ID
, ST.KHR_ID CONTRACT_ID
, SP.ID STREAM_TYPE_ID
, SP.ACCRUAL_YN REVENUE_REC_BASIS
, PS.DUE_DATE DUE_DATE
, HD.CURRENCY_CODE CURRENCY_CODE
, PS.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, PS.STATUS STATUS
FROM AR_PAYMENT_SCHEDULES_ALL PS
, OKL_CNSLD_AR_STRMS_B ST
, OKL_CNSLD_AR_LINES_B LN
, OKL_CNSLD_AR_HDRS_B HD
, OKL_STRM_TYPE_B SP
, OKC_K_HEADERS_ALL_B CN
WHERE PS.CLASS IN ('INV'
, 'CM')
AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
AND LN.ID = ST.LLN_ID
AND HD.ID = LN.CNR_ID
AND SP.ID = ST.STY_ID
AND CN.ID = ST.KHR_ID UNION SELECT ARL.TXD_ID CONSOLIDATED_INVOICE_ID
, ARL.RECEIVABLES_INVOICE_NUMBER CONSOLIDATED_INVOICE_NUMBER
, ARL.RECEIVABLES_INVOICE_ID RECEIVABLES_INVOICE_ID
, ARL.CONTRACT_ID CONTRACT_ID
, SP.ID STREAM_TYPE_ID
, SP.ACCRUAL_YN REVENUE_REC_BASIS
, PS.DUE_DATE DUE_DATE
, ARL.CURRENCY_CODE CURRENCY_CODE
, PS.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, PS.STATUS STATUS
FROM AR_PAYMENT_SCHEDULES_ALL PS
, OKL_BPD_AR_INV_LINES_V ARL
, OKL_STRM_TYPE_B SP
, OKC_K_HEADERS_ALL_B CN
WHERE PS.CLASS IN ('INV'
, 'CM')
AND ARL.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
AND SP.ID = ARL.STY_ID
AND CN.ID = ARL.CONTRACT_ID