View: ITG_POJ_HEADERS_V

View Text

SELECT H.JE_HEADER_ID
, H.RUNNING_TOTAL_DR AMOUNT_DOCUMENT_AMOUNT
, H.CURRENCY_CODE AMOUNT_DOCUMENT_CURRENCY
, CUR.PRECISION AMOUNT_DOCUMENT_PRECISION
, DECODE ( SIGN(RUNNING_TOTAL_CR)
, -1
, '-'
, '+') AMOUNT_DOCUMENT_SIGN
, 'D' AMOUNT_DOCUMENT_DRCR
, H.DEFAULT_EFFECTIVE_DATE DATETIME_DOCUMENT_T
, DECODE(ITG_X_UTILS.GETFLEXQUALIFIERSEGMENT( CC.CHART_OF_ACCOUNTS_ID
, 'GL_BALANCING')
, 'SEGMENT1'
, CC.SEGMENT1
, 'SEGMENT2'
, CC.SEGMENT2
, 'SEGMENT3'
, CC.SEGMENT3
, 'SEGMENT4'
, CC.SEGMENT4
, 'SEGMENT5'
, CC.SEGMENT5
, 'SEGMENT6'
, CC.SEGMENT6
, 'SEGMENT7'
, CC.SEGMENT7
, 'SEGMENT8'
, CC.SEGMENT8
, 'SEGMENT9'
, CC.SEGMENT9
, 'SEGMENT10'
, CC.SEGMENT10
, 'SEGMENT11'
, CC.SEGMENT11
, 'SEGMENT12'
, CC.SEGMENT12
, 'SEGMENT13'
, CC.SEGMENT13
, 'SEGMENT14'
, CC.SEGMENT14
, 'SEGMENT15'
, CC.SEGMENT15
, 'SEGMENT16'
, CC.SEGMENT16
, 'SEGMENT17'
, CC.SEGMENT17
, 'SEGMENT18'
, CC.SEGMENT18
, 'SEGMENT19'
, CC.SEGMENT19
, 'SEGMENT20'
, CC.SEGMENT20
, 'SEGMENT21'
, CC.SEGMENT21
, 'SEGMENT22'
, CC.SEGMENT22
, 'SEGMENT23'
, CC.SEGMENT23
, 'SEGMENT24'
, CC.SEGMENT24
, 'SEGMENT25'
, CC.SEGMENT25
, 'SEGMENT26'
, CC.SEGMENT26
, 'SEGMENT27'
, CC.SEGMENT27
, 'SEGMENT28'
, CC.SEGMENT28
, 'SEGMENT29'
, CC.SEGMENT29
, 'SEGMENT30'
, CC.SEGMENT30 ) GLENTITYS
, H.JE_HEADER_ID ORIGREF
, H.DESCRIPTION DESCRIPTN
, CAT.USER_JE_CATEGORY_NAME DOCTYPE
, H.NAME JEID
, SOB.NAME LEDGER
, U.USER_NAME USERID
FROM FND_USER U
, GL_JE_CATEGORIES CAT
, GL_CODE_COMBINATIONS CC
, FND_CURRENCIES CUR
, GL_SETS_OF_BOOKS SOB
, GL_JE_HEADERS H
WHERE U.USER_ID = NVL(H.CREATED_BY
, 0)
AND CAT.JE_CATEGORY_NAME = H.JE_CATEGORY
AND CC.CODE_COMBINATION_ID = SOB.RET_EARN_CODE_COMBINATION_ID
AND SOB.SET_OF_BOOKS_ID = H.SET_OF_BOOKS_ID
AND CUR.CURRENCY_CODE = H.CURRENCY_CODE
AND H.RUNNING_TOTAL_DR = H.RUNNING_TOTAL_CR

Columns