eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GL_CODE_COMBINATIONS_KFV

Source

View Text - Preformatted


SELECT ROWID , CODE_COMBINATION_ID , CHART_OF_ACCOUNTS_ID , (DECODE(CHART_OF_ACCOUNTS_ID, 50132, SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3, 50133, SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3 || '.' || SEGMENT4 || '.' || SEGMENT5 || '.' || SEGMENT6, 50134, SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3 || '.' || SEGMENT4 || '.' || SEGMENT5, NULL)) , (DECODE(CHART_OF_ACCOUNTS_ID, 50132, RPAD(NVL(SEGMENT1, ' '), 3) || '.' || RPAD(NVL(SEGMENT2, ' '), 4) || '.' || RPAD(NVL(SEGMENT3, ' '), 4), 50133, RPAD(NVL(SEGMENT1, ' '), 2) || '.' || RPAD(NVL(SEGMENT2, ' '), 3) || '.' || RPAD(NVL(SEGMENT3, ' '), 4) || '.' || RPAD(NVL(SEGMENT4, ' '), 3) || '.' || RPAD(NVL(SEGMENT5, ' '), 3) || '.' || RPAD(NVL(SEGMENT6, ' '), 3), 50134, RPAD(NVL(SEGMENT1, ' '), 2) || '.' || RPAD(NVL(SEGMENT2, ' '), 3) || '.' || RPAD(NVL(SEGMENT3, ' '), 5) || '.' || RPAD(NVL(SEGMENT4, ' '), 4) || '.' || RPAD(NVL(SEGMENT5, ' '), 3), NULL)) , ACCOUNT_TYPE , DETAIL_BUDGETING_ALLOWED_FLAG , DETAIL_POSTING_ALLOWED_FLAG , SEGMENT_ATTRIBUTE17 , SEGMENT_ATTRIBUTE18 , SEGMENT_ATTRIBUTE19 , SEGMENT_ATTRIBUTE20 , SEGMENT_ATTRIBUTE21 , SEGMENT_ATTRIBUTE22 , SEGMENT_ATTRIBUTE23 , SEGMENT_ATTRIBUTE24 , SEGMENT_ATTRIBUTE25 , SEGMENT_ATTRIBUTE26 , SEGMENT_ATTRIBUTE27 , SEGMENT_ATTRIBUTE28 , SEGMENT_ATTRIBUTE29 , SEGMENT_ATTRIBUTE30 , SEGMENT_ATTRIBUTE31 , SEGMENT_ATTRIBUTE32 , SEGMENT_ATTRIBUTE33 , SEGMENT_ATTRIBUTE34 , SEGMENT_ATTRIBUTE35 , SEGMENT_ATTRIBUTE36 , SEGMENT_ATTRIBUTE37 , SEGMENT_ATTRIBUTE38 , SEGMENT_ATTRIBUTE39 , SEGMENT_ATTRIBUTE40 , SEGMENT_ATTRIBUTE41 , SEGMENT_ATTRIBUTE42 , JGZZ_RECON_FLAG , DESCRIPTION , TEMPLATE_ID , ALLOCATION_CREATE_FLAG , START_DATE_ACTIVE , END_DATE_ACTIVE , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , CONTEXT , SEGMENT_ATTRIBUTE1 , SEGMENT_ATTRIBUTE2 , SEGMENT_ATTRIBUTE3 , SEGMENT_ATTRIBUTE4 , SEGMENT_ATTRIBUTE5 , SEGMENT_ATTRIBUTE6 , SEGMENT_ATTRIBUTE7 , SEGMENT_ATTRIBUTE8 , SEGMENT_ATTRIBUTE9 , SEGMENT_ATTRIBUTE10 , SEGMENT_ATTRIBUTE11 , SEGMENT_ATTRIBUTE12 , SEGMENT_ATTRIBUTE13 , SEGMENT_ATTRIBUTE14 , SEGMENT_ATTRIBUTE15 , SEGMENT_ATTRIBUTE16 , LAST_UPDATE_DATE , LAST_UPDATED_BY , ENABLED_FLAG , SUMMARY_FLAG ,REFERENCE1 ,REFERENCE2 ,REFERENCE3 ,REFERENCE4 ,REFERENCE5 ,SEGMENT1 ,SEGMENT2 ,SEGMENT3 ,SEGMENT4 ,SEGMENT5 ,SEGMENT6 ,SEGMENT7 ,SEGMENT8 ,SEGMENT9 ,SEGMENT10 ,SEGMENT11 ,SEGMENT12 ,SEGMENT13 ,SEGMENT14 ,SEGMENT15 ,SEGMENT16 ,SEGMENT17 ,SEGMENT18 ,SEGMENT19 ,SEGMENT20 ,SEGMENT21 ,SEGMENT22 ,SEGMENT23 ,SEGMENT24 ,SEGMENT25 ,SEGMENT26 ,SEGMENT27 ,SEGMENT28 ,SEGMENT29 ,SEGMENT30 FROM GL_CODE_COMBINATIONS

View Text - HTML Formatted

SELECT ROWID
, CODE_COMBINATION_ID
, CHART_OF_ACCOUNTS_ID
, (DECODE(CHART_OF_ACCOUNTS_ID
, 50132
, SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3
, 50133
, SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3 || '.' || SEGMENT4 || '.' || SEGMENT5 || '.' || SEGMENT6
, 50134
, SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3 || '.' || SEGMENT4 || '.' || SEGMENT5
, NULL))
, (DECODE(CHART_OF_ACCOUNTS_ID
, 50132
, RPAD(NVL(SEGMENT1
, ' ')
, 3) || '.' || RPAD(NVL(SEGMENT2
, ' ')
, 4) || '.' || RPAD(NVL(SEGMENT3
, ' ')
, 4)
, 50133
, RPAD(NVL(SEGMENT1
, ' ')
, 2) || '.' || RPAD(NVL(SEGMENT2
, ' ')
, 3) || '.' || RPAD(NVL(SEGMENT3
, ' ')
, 4) || '.' || RPAD(NVL(SEGMENT4
, ' ')
, 3) || '.' || RPAD(NVL(SEGMENT5
, ' ')
, 3) || '.' || RPAD(NVL(SEGMENT6
, ' ')
, 3)
, 50134
, RPAD(NVL(SEGMENT1
, ' ')
, 2) || '.' || RPAD(NVL(SEGMENT2
, ' ')
, 3) || '.' || RPAD(NVL(SEGMENT3
, ' ')
, 5) || '.' || RPAD(NVL(SEGMENT4
, ' ')
, 4) || '.' || RPAD(NVL(SEGMENT5
, ' ')
, 3)
, NULL))
, ACCOUNT_TYPE
, DETAIL_BUDGETING_ALLOWED_FLAG
, DETAIL_POSTING_ALLOWED_FLAG
, SEGMENT_ATTRIBUTE17
, SEGMENT_ATTRIBUTE18
, SEGMENT_ATTRIBUTE19
, SEGMENT_ATTRIBUTE20
, SEGMENT_ATTRIBUTE21
, SEGMENT_ATTRIBUTE22
, SEGMENT_ATTRIBUTE23
, SEGMENT_ATTRIBUTE24
, SEGMENT_ATTRIBUTE25
, SEGMENT_ATTRIBUTE26
, SEGMENT_ATTRIBUTE27
, SEGMENT_ATTRIBUTE28
, SEGMENT_ATTRIBUTE29
, SEGMENT_ATTRIBUTE30
, SEGMENT_ATTRIBUTE31
, SEGMENT_ATTRIBUTE32
, SEGMENT_ATTRIBUTE33
, SEGMENT_ATTRIBUTE34
, SEGMENT_ATTRIBUTE35
, SEGMENT_ATTRIBUTE36
, SEGMENT_ATTRIBUTE37
, SEGMENT_ATTRIBUTE38
, SEGMENT_ATTRIBUTE39
, SEGMENT_ATTRIBUTE40
, SEGMENT_ATTRIBUTE41
, SEGMENT_ATTRIBUTE42
, JGZZ_RECON_FLAG
, DESCRIPTION
, TEMPLATE_ID
, ALLOCATION_CREATE_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, CONTEXT
, SEGMENT_ATTRIBUTE1
, SEGMENT_ATTRIBUTE2
, SEGMENT_ATTRIBUTE3
, SEGMENT_ATTRIBUTE4
, SEGMENT_ATTRIBUTE5
, SEGMENT_ATTRIBUTE6
, SEGMENT_ATTRIBUTE7
, SEGMENT_ATTRIBUTE8
, SEGMENT_ATTRIBUTE9
, SEGMENT_ATTRIBUTE10
, SEGMENT_ATTRIBUTE11
, SEGMENT_ATTRIBUTE12
, SEGMENT_ATTRIBUTE13
, SEGMENT_ATTRIBUTE14
, SEGMENT_ATTRIBUTE15
, SEGMENT_ATTRIBUTE16
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, ENABLED_FLAG
, SUMMARY_FLAG
, REFERENCE1
, REFERENCE2
, REFERENCE3
, REFERENCE4
, REFERENCE5
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
FROM GL_CODE_COMBINATIONS