View: OKL_CMN_EXTRACT_LINE_V

Product:	OKL - Lease and Finance Management
Description:	Line extract object with commonly shared sources across event classes.
Implementation/DBA Data:	APPS.OKL_CMN_EXTRACT_LINE_V

View Text

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'

Columns