[Home] [Help]
View: 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
Name |
ID |
AE_LINE_TYPE |
CODE_COMBINATION_ID |
CONCATE_SEGMENTS |
CONCATE_SEGMENTS_DESC |
AE_LINE_TYPE_MEANING |
CR_DR_FLAG |
DR_CR_FLAG_MEANING |
AMOUNT |
ACCOUNTING_DATE |
TEMPLATE_NAME |
POSTED |
SOURCE_ID |
SOURCE_TABLE |