View: OKL_CMN_EXTRACT_HDR_V

Product:	OKL - Lease and Finance Management
Description:	Header extract object with commonly used sources across event classes.
Implementation/DBA Data:	APPS.OKL_CMN_EXTRACT_HDR_V

View Text

SELECT XE.EVENT_ID EVENT_ID
, TEH.CONTRACT_NUMBER TEH_CONTRACT_NUMBER
, TCN.REPRESENTATION_CODE TCN_REPRESENTATION_CODE
, TCN.REPRESENTATION_NAME TCN_REPRESENTATION_NAME
, TEH.RENT_IA_CONTRACT_NUMBER TEH_RENT_IA_CONTRACT_NUMBER
, TEH.RES_IA_CONTRACT_NUMBER TEH_RES_IA_CONTRACT_NUMBER
, TEH.CONVERTED_NUMBER TEH_CONVERTED_NUMBER
, TEH.CONTRACT_EFFECTIVE_FROM TEH_CONTRACT_EFFECTIVE_FROM
, TCN.BOOK_CLASSIFICATION_CODE TCN_BOOK_CLASSIFICATION_CODE
, TCN.PRODUCT_NAME TCN_CONTRACT_PRODUCT_NAME
, TEH.RENT_IA_PRODUCT_NAME TEH_RENT_IA_PRODUCT_NAME
, TEH.RES_IA_PRODUCT_NAME TEH_RES_IA_PRODUCT_NAME
, TEH.REV_REC_METHOD_CODE TEH_REV_REC_METHOD_CODE
, TEH.INT_CALC_METHOD_CODE TEH_INT_CALC_METHOD_CODE
, TCN.TAX_OWNER_CODE TCN_TAX_OWNER_CODE
, TEH.CONTRACT_CURRENCY_CODE TEH_CONTRACT_CURRENCY_CODE
, TEH.SALES_REP_NAME TEH_SALES_REP_NAME
, TCN.AMOUNT TCN_AMOUNT
, TCN.CURRENCY_CONVERSION_DATE TCN_CURR_CONVERSION_DATE
, TCN.CURRENCY_CONVERSION_RATE TCN_CURR_CONVERSION_RATE
, TCN.CURRENCY_CONVERSION_TYPE TCN_CURR_CONVERSION_TYPE
, TEH.CUSTOMER_NAME TEH_CUSTOMER_NAME
, TEH.CUSTOMER_ACCOUNT_NUMBER TEH_CUSTOMER_ACCOUNT_NUMBER
, TEH.BILL_TO_ADDRESS_NUM TEH_BILL_TO_ADDRESS_NUM
, TEH.PO_ORDER_NUMBER TEH_PO_ORDER_NUMBER
, TEH.VENDOR_PROGRAM_NUMBER TEH_VENDOR_PROGRAM_NUMBER
, TCN.DATE_TRANSACTION_OCCURRED TCN_DATE_TRANSACTION_OCCURRED
, TCN.TRX_NUMBER TCN_TRX_NUMBER
, TEH.RENT_IA_ACCOUNTING_CODE TEH_RENT_IA_ACCOUNTING_CODE
, TEH.RES_IA_ACCOUNTING_CODE TEH_RES_IA_ACCOUNTING_CODE
, TEH.ASSIGNABLE_FLAG TEH_ASSIGNABLE_FLAG
, TEH.CONVERTED_ACCOUNT_FLAG TEH_CONVERTED_ACCOUNT_FLAG
, TEH.ACCRUAL_OVERRIDE_FLAG TEH_ACCRUAL_OVERRIDE_FLAG
, TCN.CURRENCY_CODE TCN_CURRENCY_CODE
, TCN.ID TCN_ID
, DECODE(SIGN(INSTR(XE.EVENT_TYPE_CODE
, 'CREATE'))
, 1
, 'PROCESSED'
, TCN.TSU_CODE) TCN_STATUS_CODE
, TCN.TCN_TYPE TCN_TYPE
, DECODE(SIGN(INSTR(XE.EVENT_TYPE_CODE
, 'CREATE'))
, 1
, NULL
, TCN.ACCOUNTING_REVERSAL_YN) TCN_ACCOUNTING_REVERSAL_FLAG
, XE.EVENT_DATE GL_DATE
, TCN.ORG_ID TCN_ORG_ID
, TEH.CONTRACT_STATUS_CODE TEH_CONTRACT_STATUS_CODE
, TEH.TRX_TYPE_CLASS_CODE TEH_TRX_TYPE_CLASS_CODE
, TEH.CHR_OPERATING_UNIT_CODE TEH_CHR_OPERATING_UNIT_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