View: OKL_AP_IA_REF_V

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

View Text

SELECT PXL.SOURCE_ID OKL_TPL_ID
, 'OKL_TXL_AP_INV_LNS_ALL_B' OKL_PRODUCT_TABLE
, PXH.KHR_ID OKL_KHR_ID
, PXL.KLE_ID OKL_KLE_ID
, PXH.TRY_ID OKL_TRY_ID
, PXL.STY_ID TCL_STY_ID /* INVESTOR AGREEMENT RELATED SOURCES */
, PXH.INV_AGRMNT_NUMBER TEH_INV_AGRMNT_NUMBER
, PXH.INV_AGRMNT_EFFECTIVE_FROM TEH_INV_AGRMNT_EFFECTIVE_FROM
, PXH.INV_AGRMNT_STATUS_CODE TEH_INV_AGRMNT_STATUS_CODE
, PXH.INV_AGRMNT_PRODUCT_NAME TCN_INV_AGRMNT_PRODUCT_NAME
, PXH.INV_AGRMNT_CURRENCY_CODE TEH_INV_AGRMNT_CURRENCY_CODE
, PXH.INV_AGRMNT_POOL_NUMBER TEH_INV_AGRMNT_POOL_NUMBER
, PXH.INV_AGRMNT_SYND_CODE TEH_INV_AGRMNT_SYND_CODE
, PXL.STREAM_TYPE_CODE TCL_STREAM_TYPE_CODE
, PXL.STREAM_TYPE_PURPOSE_CODE TCL_STREAM_TYPE_PURPOSE
, PXL.ACCOUNTING_TEMPLATE_NAME DIST_ACCOUNTING_TEMPLATE_NAME
, PXL.MEMO_FLAG TEL_MEMO_FLAG
, PXH.TRX_TYPE_CLASS_CODE TEH_TRX_TYPE_CLASS_CODE
FROM OKL_EXT_AP_HEADER_SOURCES_B PXH
, OKL_EXT_AP_LINE_SOURCES_B PXL
WHERE PXH.SCS_CODE = 'INVESTOR'
AND PXL.SOURCE_TABLE = 'OKL_TXL_AP_INV_LNS_B'
AND PXH.HEADER_EXTENSION_ID = PXL.HEADER_EXTENSION_ID

Columns