Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_AR_REC_APP_IA_REF_V |
SELECT ARAPP.RECEIVABLE_APPLICATION_ID OKL_REC_APP_ID
, RXL.SOURCE_ID OKL_TXD_ID
, RXH.KHR_ID OKL_KHR_ID
, RXL.KLE_ID OKL_KLE_ID
, RXH.TRY_ID OKL_TRY_ID
, RXL.STY_ID TCL_STY_ID
, RXH.INV_AGRMNT_NUMBER TEH_INV_AGRMNT_NUMBER
, RXH.INV_AGRMNT_EFFECTIVE_FROM TEH_INV_AGRMNT_EFFECTIVE_FROM
, RXH.INV_AGRMNT_PRODUCT_NAME TCN_INV_AGRMNT_PRODUCT_NAME
, RXH.INV_AGRMNT_CURRENCY_CODE TEH_INV_AGRMNT_CURRENCY_CODE
, RXH.INV_AGRMNT_SYND_CODE TEH_INV_AGRMNT_SYND_CODE
, RXH.INV_AGRMNT_POOL_NUMBER TEH_INV_AGRMNT_POOL_NUMBER
, RXH.INV_AGRMNT_STATUS_CODE TEH_INV_AGRMNT_STATUS_CODE
, RXH.TRX_TYPE_CLASS_CODE TEH_TRX_TYPE_CLASS_CODE
, RXL.ACCOUNTING_TEMPLATE_NAME DIST_ACCOUNTING_TEMPLATE_NAME
, RXL.CONTINGENCY_CODE OKL_CONTINGENCY_CODE
, RXL.MEMO_FLAG TEL_MEMO_FLAG
, RXL.STREAM_TYPE_CODE TCL_STREAM_TYPE_CODE
, RXL.STREAM_TYPE_PURPOSE_CODE TCL_STREAM_TYPE_PURPOSE
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
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 RXH.SCS_CODE = 'INVESTOR'
AND RXH.HEADER_EXTENSION_ID = RXL.HEADER_EXTENSION_ID