View: OKL_TRX_DISTRIBUTION_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_TRX_DISTRIBUTION_UV

View Text

SELECT OTAD.ID ID
, OTAD.AE_LINE_TYPE AE_LINE_TYPE
, OTAD.CODE_COMBINATION_ID CODE_COMBINATION_ID
, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(OTAD.CODE_COMBINATION_ID) CONCATE_SEGMENTS
, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(OTAD.CODE_COMBINATION_ID) CONCATE_SEGMENTS_DESC
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_AE_LINE_TYPE'
, OTAD.AE_LINE_TYPE) AE_LINE_TYPE_MEANING
, OTAD.CR_DR_FLAG
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('DR_CR'
, OTAD.CR_DR_FLAG
, 101
, 101) DR_CR_FLAG_MEANING
, OTAD.AMOUNT AMOUNT
, GL_DATE ACCOUNTING_DATE
, INITCAP(OAT.NAME) TEMPLATE_NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, OTAD.POSTED_YN
, 0
, 0) POSTED
, OTAD.SOURCE_ID SOURCE_ID
, OTAD.SOURCE_TABLE SOURCE_TABLE
FROM OKL_TRNS_ACC_DSTRS OTAD
, OKL_AE_TEMPLATES_ALL OAT
WHERE OTAD.TEMPLATE_ID = OAT.ID(+)

Columns