Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_AR_ADJ_IA_REF_V |
SELECT AJL.RECEIVABLES_ADJUSTMENT_ID RECEIVABLES_ADJUSTMENT_ID
, AJL.ID OKL_AJL_ID
, RXH.KHR_ID OKL_KHR_ID
, RXL.KLE_ID OKL_KLE_ID
, RXH.TRY_ID OKL_TRY_ID
, RXL.STY_ID OKL_STY_ID
, RXH.INV_AGRMNT_NUMBER OKL_INV_AGRMNT_NUMBER
, RXH.INV_AGRMNT_EFFECTIVE_FROM OKL_INV_AGRMNT_EFFECTIVE_FROM
, RXH.INV_AGRMNT_PRODUCT_NAME OKL_INV_AGRMNT_PRODUCT_NAME
, RXH.INV_AGRMNT_CURRENCY_CODE OKL_INV_AGRMNT_CURRENCY_CODE
, RXH.INV_AGRMNT_SYND_CODE OKL_INV_AGRMNT_SYND_CODE
, RXH.INV_AGRMNT_POOL_NUMBER OKL_INV_AGRMNT_POOL_NUMBER
, RXH.INV_AGRMNT_STATUS_CODE OKL_INV_AGRMNT_STATUS_CODE
, RXH.TRX_TYPE_CLASS_CODE OKL_TRX_TYPE_CLASS_CODE
, RXL.ACCOUNTING_TEMPLATE_NAME OKL_AE_TEMPLATE_NAME
, RXL.CONTINGENCY_CODE OKL_CONTINGENCY_CODE
, RXL.MEMO_FLAG OKL_MEMO_FLAG
, RXL.STREAM_TYPE_CODE OKL_STREAM_TYPE_CODE
, RXL.STREAM_TYPE_PURPOSE_CODE OKL_STREAM_TYPE_PURPOSE_CODE
FROM OKL_EXT_AR_HEADER_SOURCES_B RXH
, OKL_EXT_AR_LINE_SOURCES_B RXL
, OKL_TXL_ADJSTS_LNS_ALL_B AJL
WHERE RXL.SOURCE_TABLE = 'OKL_TXL_ADJSTS_LNS_B'
AND RXH.SCS_CODE = 'INVESTOR' /* AS THIS REF. VIEW IS ONLY FOR INVESTOR BILLING*/
AND RXH.HEADER_EXTENSION_ID = RXL.HEADER_EXTENSION_ID
AND RXL.SOURCE_ID = AJL.ID