VIEW: APPS.OKL_CMN_EXTRACT_LINE_V

Source

View Text - Preformatted

SELECT DIST.ACCOUNTING_EVENT_ID EVENT_ID ,DIST.ID LINE_NUMBER ,DIST.ID DIST_ID ,DIST.ACCOUNTED_AMOUNT DIST_ACCOUNTED_AMOUNT ,DIST.AE_LINE_TYPE DIST_AE_LINE_TYPE_CODE ,DIST.CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID ,DIST.CR_DR_FLAG DIST_CR_DR_FLAG ,DIST.AMOUNT DIST_ENTERED_AMOUNT ,DIST.GL_DATE DIST_GL_DATE ,DIST.ORIGINAL_DIST_ID DIST_ORIGINAL_DISTRIBUTION_ID ,DIST.POST_TO_GL DIST_POST_TO_GL_FLAG ,'OKL_TRNS_ACC_DSTRS' DIST_TYPE ,TCL.ID TCL_ID ,TEL.LINE_EXTENSION_ID TEL_LINE_EXTENSION_ID ,TCL.STY_ID TCL_STY_ID ,TCL.TAX_LINE_ID TCL_TAX_LINE_ID ,DIST.ACCOUNTING_TEMPLATE_NAME DIST_ACCOUNTING_TEMPLATE_NAME ,TCL.AMOUNT TCL_AMOUNT ,TCL.CURRENCY_CODE TCL_CURRENCY_CODE ,TCL.DESCRIPTION TCL_DESCRIPTION ,TCL.TCN_ID TCL_TCN_ID ,TCL.TCL_TYPE TCL_TYPE ,TEL.MEMO_FLAG TEL_MEMO_FLAG ,DIST.SET_OF_BOOKS_ID LEDGER_ID ,TCL.STREAM_TYPE_CODE TCL_STREAM_TYPE_CODE ,TCL.STREAM_TYPE_PURPOSE TCL_STREAM_TYPE_PURPOSE , TEL.INVENTORY_ORG_CODE TEL_INVENTORY_ORG_CODE FROM OKL_TXL_CNTRCT_LNS_ALL TCL,OKL_TRNS_ACC_DSTRS_ALL DIST,OKL_TXL_EXTENSION_B TEL WHERE TCL.ID = DIST.SOURCE_ID AND DIST.SOURCE_TABLE = 'OKL_TXL_CNTRCT_LNS' AND TCL.ID = TEL.SOURCE_ID(+) AND TEL.SOURCE_TABLE(+) = 'OKL_TXL_CNTRCT_LNS'

View Text - HTML Formatted

SELECT DIST.ACCOUNTING_EVENT_ID EVENT_ID
, DIST.ID LINE_NUMBER
, DIST.ID DIST_ID
, DIST.ACCOUNTED_AMOUNT DIST_ACCOUNTED_AMOUNT
, DIST.AE_LINE_TYPE DIST_AE_LINE_TYPE_CODE
, DIST.CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID
, DIST.CR_DR_FLAG DIST_CR_DR_FLAG
, DIST.AMOUNT DIST_ENTERED_AMOUNT
, DIST.GL_DATE DIST_GL_DATE
, DIST.ORIGINAL_DIST_ID DIST_ORIGINAL_DISTRIBUTION_ID
, DIST.POST_TO_GL DIST_POST_TO_GL_FLAG
, 'OKL_TRNS_ACC_DSTRS' DIST_TYPE
, TCL.ID TCL_ID
, TEL.LINE_EXTENSION_ID TEL_LINE_EXTENSION_ID
, TCL.STY_ID TCL_STY_ID
, TCL.TAX_LINE_ID TCL_TAX_LINE_ID
, DIST.ACCOUNTING_TEMPLATE_NAME DIST_ACCOUNTING_TEMPLATE_NAME
, TCL.AMOUNT TCL_AMOUNT
, TCL.CURRENCY_CODE TCL_CURRENCY_CODE
, TCL.DESCRIPTION TCL_DESCRIPTION
, TCL.TCN_ID TCL_TCN_ID
, TCL.TCL_TYPE TCL_TYPE
, TEL.MEMO_FLAG TEL_MEMO_FLAG
, DIST.SET_OF_BOOKS_ID LEDGER_ID
, TCL.STREAM_TYPE_CODE TCL_STREAM_TYPE_CODE
, TCL.STREAM_TYPE_PURPOSE TCL_STREAM_TYPE_PURPOSE
, TEL.INVENTORY_ORG_CODE TEL_INVENTORY_ORG_CODE
FROM OKL_TXL_CNTRCT_LNS_ALL TCL
, OKL_TRNS_ACC_DSTRS_ALL DIST
, OKL_TXL_EXTENSION_B TEL
WHERE TCL.ID = DIST.SOURCE_ID
AND DIST.SOURCE_TABLE = 'OKL_TXL_CNTRCT_LNS'
AND TCL.ID = TEL.SOURCE_ID(+)
AND TEL.SOURCE_TABLE(+) = 'OKL_TXL_CNTRCT_LNS'