[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: |
APPS.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 |