FND Design Data [Home] [Help]

View: OKL_SHR_EXTRACT_LINE_V

Product: OKL - Lease and Finance Management
Description: Line extract object with sources not shared across event classes.
Implementation/DBA Data: ViewAPPS.OKL_SHR_EXTRACT_LINE_V
View Text

SELECT TCL.ID TCL_ID
, TCL.ACCRUAL_RULE_YN TCL_APPLY_ACCRUAL_RULE_FLAG
, TEL.AGING_BUCKET_NAME TEL_AGING_BUCKET_NAME
, TEL.CONTRACT_LINE_NUMBER TEL_CONTRACT_LINE_NUMBER
, TEL.FEE_TYPE_CODE TEL_FEE_TYPE_CODE
, TEL.RECIEVABLES_TRX_TYPE_NAME TEL_RECEIVABLES_TRX_TYPE_NAME
FROM OKL_TXL_CNTRCT_LNS_ALL TCL
, OKL_TXL_EXTENSION_B TEL
WHERE TCL.ID = TEL.SOURCE_ID(+)
AND TEL.SOURCE_TABLE(+) = 'OKL_TXL_CNTRCT_LNS'

Columns

Name
TCL_ID
TCL_APPLY_ACCRUAL_RULE_FLAG
TEL_AGING_BUCKET_NAME
TEL_CONTRACT_LINE_NUMBER
TEL_FEE_TYPE_CODE
TEL_RECEIVABLES_TRX_TYPE_NAME