View: OKL_AR_INV_IA_REF_V

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

View Text

SELECT TXD.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 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_TXD_AR_LN_DTLS_B TXD
WHERE RXH.SCS_CODE = 'INVESTOR' /* AS THIS REF. VIEW IS ONLY FOR INVESTOR BILLING*/
AND RXL.SOURCE_TABLE = 'OKL_TXD_AR_LN_DTLS_B'
AND RXH.HEADER_EXTENSION_ID = RXL.HEADER_EXTENSION_ID
AND RXL.SOURCE_ID = TXD.ID

Columns