View: OKL_IA_EXTRACT_HDR_V

Product:	OKL - Leasing and Finance Management
Description:	Header extract object for Investor Agreement event class.
Implementation/DBA Data:	APPS.OKL_IA_EXTRACT_HDR_V

View Text

SELECT XE.EVENT_ID EVENT_ID
, TCN.ID TCN_ID
, TEH.INV_AGRMNT_NUMBER TEH_INV_AGRMNT_NUMBER
, TEH.INV_AGRMNT_EFFECTIVE_FROM TEH_INV_AGRMNT_EFFECTIVE_FROM
, TCN.PRODUCT_NAME TCN_INV_AGRMNT_PRODUCT_NAME
, TEH.INV_AGRMNT_CURRENCY_CODE TEH_INV_AGRMNT_CURRENCY_CODE
, TCN.AMOUNT TCN_IA_AMOUNT
, TCN.CURRENCY_CODE TCN_CURRENCY_CODE
, TCN.CURRENCY_CONVERSION_DATE TCN_CURR_CONVERSION_DATE
, TCN.CURRENCY_CONVERSION_RATE TCN_CURR_CONVERSION_RATE
, TCN.CURRENCY_CONVERSION_TYPE TCN_CURR_CONVERSION_TYPE
, TCN.DATE_TRANSACTION_OCCURRED TCN_DATE_TRANSACTION_OCCURRED
, TCN.TRX_NUMBER TCN_TRX_NUMBER
, TCN.TSU_CODE TCN_STATUS_CODE
, TEH.INV_AGRMNT_SYND_CODE TEH_INV_AGRMNT_SYND_CODE
, TCN.TCN_TYPE TCN_TYPE
, TEH.INV_AGRMNT_POOL_NUMBER TEH_INV_AGRMNT_POOL_NUMBER
, TCN.ACCOUNTING_REVERSAL_YN TCN_ACCOUNTING_REVERSAL_FLAG
, TCN.REPRESENTATION_CODE TCN_REPRESENTATION_CODE
, TCN.REPRESENTATION_NAME TCN_REPRESENTATION_NAME
, XE.EVENT_DATE GL_DATE
, TCN.ORG_ID TCN_ORG_ID
, TEH.INV_AGRMNT_STATUS_CODE TEH_INV_AGRMNT_STATUS_CODE
FROM OKL_TRX_EXTENSION_B TEH
, OKL_TRX_CONTRACTS_ALL TCN
, XLA_EVENTS_GT XE
WHERE TCN.ID = TEH.SOURCE_ID(+)
AND TEH.SOURCE_TABLE(+) = 'OKL_TRX_CONTRACTS'
AND XE.APPLICATION_ID = 540
AND XE.SOURCE_ID_INT_1 = TCN.ID

Columns