Product: | ITG - Internet Procurement Enterprise Connector |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT L.JE_HEADER_ID
, L.JE_LINE_NUM
, NVL(L.ENTERED_DR
, L.ENTERED_CR) AMOUNT_ACTUAL_T_AMOUNT
, H.CURRENCY_CODE AMOUNT_ACTUAL_T_CURRENCY
, CUR1.PRECISION AMOUNT_ACTUAL_T_PRECISION
, DECODE ( SIGN(NVL(ENTERED_CR
, ENTERED_DR))
, -1
, '-'
, '+') AMOUNT_ACTUAL_T_SIGN
, DECODE(NVL(TO_CHAR(ENTERED_CR)
, 'D')
, 'D'
, 'D'
, 'C') AMOUNT_ACTUAL_T_DRCR
, NVL(L.ACCOUNTED_DR
, L.ACCOUNTED_CR) AMOUNT_ACTUAL_F_AMOUNT
, SOB.CURRENCY_CODE AMOUNT_ACTUAL_F_CURRENCY
, CUR2.PRECISION AMOUNT_ACTUAL_F_PRECISION
, DECODE ( SIGN(NVL(ACCOUNTED_CR
, ACCOUNTED_DR))
, -1
, '-'
, '+') AMOUNT_ACTUAL_F_SIGN
, DECODE(NVL(TO_CHAR(ACCOUNTED_CR)
, 'D')
, 'D'
, 'D'
, 'C') AMOUNT_ACTUAL_F_DRCR
, DECODE(ITG_X_UTILS.GETFLEXQUALIFIERSEGMENT( CC.CHART_OF_ACCOUNTS_ID
, 'GL_ACCOUNT')
, '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 ) GLNOMACCT
, DECODE(ITG_X_UTILS.GETFLEXQUALIFIERSEGMENT( CC.CHART_OF_ACCOUNTS_ID
, 'FA_COST_CTR')
, NULL
, ''
, '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 ) COSTCENTER
, L.DESCRIPTION
, CC.SEGMENT1 ELEMENT1
, CC.SEGMENT2 ELEMENT2
, CC.SEGMENT3 ELEMENT3
, CC.SEGMENT4 ELEMENT4
, CC.SEGMENT5 ELEMENT5
, CC.SEGMENT6 ELEMENT6
, CC.SEGMENT7 ELEMENT7
, CC.SEGMENT8 ELEMENT8
, CC.SEGMENT9 ELEMENT9
, CC.SEGMENT10 ELEMENT10
, CC.SEGMENT11 ELEMENT11
, CC.SEGMENT12 ELEMENT12
, CC.SEGMENT13 ELEMENT13
, CC.SEGMENT14 ELEMENT14
, CC.SEGMENT15 ELEMENT15
, CC.SEGMENT16 ELEMENT16
, CC.SEGMENT17 ELEMENT17
, CC.SEGMENT18 ELEMENT18
, CC.SEGMENT19 ELEMENT19
, CC.SEGMENT20 ELEMENT20
, CC.SEGMENT21 ELEMENT21
, CC.SEGMENT22 ELEMENT22
, CC.SEGMENT23 ELEMENT23
, CC.SEGMENT24 ELEMENT24
, CC.SEGMENT25 ELEMENT25
, CC.SEGMENT26 ELEMENT26
, CC.SEGMENT27 ELEMENT27
, CC.SEGMENT28 ELEMENT28
, CC.SEGMENT29 ELEMENT29
, CC.SEGMENT30 ELEMENT30
, 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 ) GLENTITYD
, L.REFERENCE_1 REF_1
, L.REFERENCE_2 REF_2
, L.REFERENCE_3 REF_3
, L.REFERENCE_4 REF_4
, L.REFERENCE_5 REF_5
, L.REFERENCE_6 REF_6
, L.REFERENCE_7 REF_7
, L.REFERENCE_8 REF_8
, L.REFERENCE_9 REF_9
, L.REFERENCE_10 REF_10
, P.PERIOD_NUM ACCTPERIOD
, P.PERIOD_YEAR ACCTYEAR
FROM GL_CODE_COMBINATIONS CC
, FND_CURRENCIES CUR1
, FND_CURRENCIES CUR2
, GL_SETS_OF_BOOKS SOB
, GL_PERIODS P
, GL_JE_HEADERS H
, GL_JE_LINES L
WHERE CC.CODE_COMBINATION_ID = L.CODE_COMBINATION_ID
AND CUR1.CURRENCY_CODE = H.CURRENCY_CODE
AND CUR2.CURRENCY_CODE = SOB.CURRENCY_CODE
AND SOB.SET_OF_BOOKS_ID = H.SET_OF_BOOKS_ID
AND H.JE_HEADER_ID = L.JE_HEADER_ID
AND P.PERIOD_SET_NAME = SOB.PERIOD_SET_NAME
AND P.PERIOD_NAME = L.PERIOD_NAME