VIEW: APPS.OKL_IA_EXTRACT_HDR_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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