View: OKL_SHR_EXTRACT_HDR_V

Product:	OKL - Lease and Finance Management
Description:	Header extract object with sources that are not commonly shared across.
Implementation/DBA Data:	APPS.OKL_SHR_EXTRACT_HDR_V

View Text

SELECT TCN.ID TCN_ID
, TEH.TERM_QUOTE_ACCEPT_DATE TEH_TERM_QUOTE_ACCEPT_DATE
, TEH.TERM_QUOTE_NUM TEH_TERM_QUOTE_NUM
, TEH.TERM_QUOTE_TYPE_CODE TEH_TERM_QUOTE_TYPE_CODE
, TCN.ACCRUAL_REVERSAL_DATE TCN_ACCRUAL_REVERSAL_DATE
, TCN.DATE_ACCRUAL TCN_ACCRUAL_DATE
, TCN.ACCRUAL_STATUS_YN TCN_ACCRUAL_STATUS_FLAG
, TCN.UPDATE_STATUS_YN TCN_OVERRIDE_STATUS_FLAG
, TCN.TAX_DEDUCTIBLE_LOCAL TCN_TAX_DEDUCTIBLE_LOCAL_FLAG
, TCN.TAX_DEDUCTIBLE_CORPORATE TCN_TAX_DEDUCTIBLE_CORP_FLAG
, TCN.RBR_CODE TCN_REBOOK_REASON_CODE
, TCN.ACCRUAL_ACTIVITY TCN_ACCRUAL_ACTIVITY_CODE
FROM OKL_TRX_EXTENSION_B TEH
, OKL_TRX_CONTRACTS_ALL TCN
WHERE TCN.ID = TEH.SOURCE_ID(+)
AND TEH.SOURCE_TABLE(+) = 'OKL_TRX_CONTRACTS'

Columns