View: OKL_BPD_CONTRACT_INVOICES_V

Product:	OKL - Lease and Finance Management
Description:	Consolidated Invoice for Contract
Implementation/DBA Data:	APPS.OKL_BPD_CONTRACT_INVOICES_V

View Text

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

Columns