VIEW: APPS.IEX_LEASING_INVOICE_LINES_V

Source

View Text - Preformatted

SELECT HD.ID CONSOLIDATED_INVOICE_ID , CN.CONTRACT_NUMBER CONTRACT_NUMBER , LN.SEQUENCE_NUMBER CONSOLIDATED_LINE_NUMBER , PS.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING , PS.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL , NULL, NULL, NULL, NULL, HD.CURRENCY_CODE, HD.DATE_CONSOLIDATED, CN.START_DATE , HD.CONSOLIDATED_INVOICE_NUMBER , ST.RECEIVABLES_INVOICE_ID , PS.TRX_NUMBER , ST.KHR_ID , ST.KLE_ID , ST.ID , SM.ID , SM.NAME , PS.PAYMENT_SCHEDULE_ID , ST.TAX_AMOUNT FROM OKL_INVC_LINE_TYPES_V ILT, AR_PAYMENT_SCHEDULES_ALL PS, OKL_CNSLD_AR_STRMS_B ST, OKL_CNSLD_AR_LINES_B LN, OKL_CNSLD_AR_HDRS_B HD, HZ_CUST_ACCOUNTS CA, HZ_PARTIES PY, OKL_STRM_TYPE_TL SM, OKC_K_HEADERS_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 CA.CUST_ACCOUNT_ID = HD.IXX_ID AND PY.PARTY_ID = CA.PARTY_ID AND SM.ID = ST.STY_ID AND SM.LANGUAGE = USERENV ('LANG') AND CN.ID (+) = ST.KHR_ID AND ILT.ID (+) = LN.ILT_ID

View Text - HTML Formatted

SELECT HD.ID CONSOLIDATED_INVOICE_ID
, CN.CONTRACT_NUMBER CONTRACT_NUMBER
, LN.SEQUENCE_NUMBER CONSOLIDATED_LINE_NUMBER
, PS.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, PS.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, NULL
, NULL
, NULL
, NULL
, HD.CURRENCY_CODE
, HD.DATE_CONSOLIDATED
, CN.START_DATE
, HD.CONSOLIDATED_INVOICE_NUMBER
, ST.RECEIVABLES_INVOICE_ID
, PS.TRX_NUMBER
, ST.KHR_ID
, ST.KLE_ID
, ST.ID
, SM.ID
, SM.NAME
, PS.PAYMENT_SCHEDULE_ID
, ST.TAX_AMOUNT
FROM OKL_INVC_LINE_TYPES_V ILT
, AR_PAYMENT_SCHEDULES_ALL PS
, OKL_CNSLD_AR_STRMS_B ST
, OKL_CNSLD_AR_LINES_B LN
, OKL_CNSLD_AR_HDRS_B HD
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES PY
, OKL_STRM_TYPE_TL SM
, OKC_K_HEADERS_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 CA.CUST_ACCOUNT_ID = HD.IXX_ID
AND PY.PARTY_ID = CA.PARTY_ID
AND SM.ID = ST.STY_ID
AND SM.LANGUAGE = USERENV ('LANG')
AND CN.ID (+) = ST.KHR_ID
AND ILT.ID (+) = LN.ILT_ID