[Home] [Help]
View: 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
Name |
CONSOLIDATED_INVOICE_ID |
CONSOLIDATED_INVOICE_NUMBER |
RECEIVABLES_INVOICE_ID |
CONTRACT_ID |
STREAM_TYPE_ID |
REVENUE_REC_BASIS |
DUE_DATE |
CURRENCY_CODE |
AMOUNT_DUE_ORIGINAL |
AMOUNT_DUE_REMAINING |
STATUS |