View: OKL_BPD_PAYMENT_HISTORY_V

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_BPD_PAYMENT_HISTORY_V

View Text

SELECT PS.ROWID ROW_ID
, HD.IXX_ID CUSTOMER_ID
, SUBSTRB (PY.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, HD.CURRENCY_CODE
, LT.NAME
, CA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, HD.ID CONSOLIDATED_INVOICE_ID
, HD.CONSOLIDATED_INVOICE_NUMBER CONSOLIDATED_INVOICE_NUMBER
, LN.SEQUENCE_NUMBER CONSOLIDATED_LINE_NUMBER
, ST.RECEIVABLES_INVOICE_ID RECEIVABLES_INVOICE_ID
, PS.TRX_NUMBER RECEIVABLES_INVOICE_NUMBER
, XCR.CHECK_NUMBER REFERENCE_NUMBER
, PS.CASH_RECEIPT_ID CASH_RECEIPT_ID
, ST.KHR_ID CONTRACT_ID
, CN.CONTRACT_NUMBER CONTRACT_NUMBER
, ST.KLE_ID CONTRACT_LINE_ID
, ST.ID STREAM_ID
, SM.ID STREAM_TYPE_ID
, SM.NAME STREAM_NAME
, PS.DUE_DATE DUE_DATE
, RA.APPLY_DATE
, RA.AMOUNT_APPLIED
, PS.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, PS.CLASS CLASS
, PS.STATUS STATUS
, PS.CREATED_BY CREATED_BY
, PS.CREATION_DATE CREATION_DATE
, PS.LAST_UPDATED_BY LAST_UPDATED_BY
, PS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM AR_PAYMENT_SCHEDULES_ALL PS
, AR_RECEIVABLE_APPLICATIONS_ALL RA
, OKL_CNSLD_AR_STRMS_B ST
, OKL_CNSLD_AR_LINES_B LN
, OKL_CNSLD_AR_HDRS_B HD
, OKL_INVC_LINE_TYPES_V LT
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES PY
, OKL_STRM_TYPE_TL SM
, OKC_K_HEADERS_ALL_B CN
, OKL_XTL_CSH_APPS_ALL_B XCA
, OKL_EXT_CSH_RCPTS_ALL_B XCR
WHERE PS.CLASS IN ('INV'
, 'CM')
AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
AND ST.STY_ID = XCA.LSM_ID
AND XCA.XCR_ID_DETAILS = XCR.ID
AND PS.PAYMENT_SCHEDULE_ID = RA.APPLIED_PAYMENT_SCHEDULE_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 LN.ILT_ID = LT.ID
AND CN.ID (+) = ST.KHR_ID

Columns