View: OKL_AR_REC_APP_REF_VL

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

View Text

SELECT ARAPP.RECEIVABLE_APPLICATION_ID OKL_REC_APP_ID
, RXL.SOURCE_ID OKL_TXD_ID
, RXHL.LANGUAGE OKL_LANGUAGE
, RXHL.CONTRACT_STATUS OKL_CONTRACT_STATUS
, RXHL.INV_AGRMNT_STATUS OKL_INV_AGRMNT_STATUS
, RXLL.STREAM_TYPE_NAME OKL_STREAM_TYPE_NAME
, RXHL.TRANSACTION_TYPE_NAME OKL_TRANSACTION_TYPE_NAME
, RXLL.TRANS_LINE_DESCRIPTION OKL_TRANS_LINE_DESCRIPTION
, RXLL.INVENTORY_ORG_NAME OKL_INVENTORY_ORG_NAME
FROM AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
, AR_ACTIVITY_DETAILS ARL
, RA_CUSTOMER_TRX_LINES_ALL RACTRL
, OKL_EXT_AR_HEADER_SOURCES_B RXH
, OKL_EXT_AR_LINE_SOURCES_B RXL
, OKL_EXT_AR_HEADER_SOURCES_TL RXHL
, OKL_EXT_AR_LINE_SOURCES_TL RXLL
WHERE ARAPP.RECEIVABLE_APPLICATION_ID = ARL.SOURCE_ID
AND ARL.SOURCE_TABLE = 'RA'
AND ARL.CUSTOMER_TRX_LINE_ID = RACTRL.CUSTOMER_TRX_LINE_ID
AND RACTRL.LINE_TYPE = 'LINE'
AND RACTRL.INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS'
AND RACTRL.INTERFACE_LINE_ATTRIBUTE14 = RXL.SOURCE_ID
AND RXL.SOURCE_TABLE = 'OKL_TXD_AR_LN_DTLS_B'
AND RXL.HEADER_EXTENSION_ID = RXH.HEADER_EXTENSION_ID
AND RXH.HEADER_EXTENSION_ID = RXHL.HEADER_EXTENSION_ID
AND RXL.LINE_EXTENSION_ID = RXLL.LINE_EXTENSION_ID

Columns