[Home] [Help]
View: OKL_SHR_EXTRACT_LINE_V
| Product: | OKL - Leasing 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 |