eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_SHR_EXTRACT_LINE_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'