VIEW: APPS.OKL_SHR_EXTRACT_HDR_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'