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.GLFV_GL_ACCOUNTS_DESCR

Source

View Text - Preformatted


SELECT gla.CODE_COMBINATION_ID, '_KF:SQLGL:GL#:GLA', gla.CHART_OF_ACCOUNTS_ID, CHART_OF_ACCOUNTS_TL.ID_FLEX_STRUCTURE_NAME, '_LA:gla.ACCOUNT_TYPE:GL_LOOKUPS:ACCOUNT TYPE:DESCRIPTION', gla.DESCRIPTION, gla.START_DATE_ACTIVE, gla.END_DATE_ACTIVE, '_LA:gla.ENABLED_FLAG:GL_LOOKUPS:YES/NO:MEANING', '_LA:gla.DETAIL_POSTING_ALLOWED_FLAG:GL_LOOKUPS:YES/NO:MEANING', '_LA:gla.DETAIL_BUDGETING_ALLOWED_FLAG:GL_LOOKUPS:YES/NO:MEANING', '_LA:DECODE(gla.SUMMARY_FLAG,''N'',''DTL'',''SUM''):GL_LOOKUPS:SUMMARY_FLAG:MEANING', '_LA:gla.PRESERVE_FLAG:GL_LOOKUPS:YES/NO:MEANING', '_DF:SQLGL:GL_CODE_COMBINATIONS:GLA' FROM (SELECT ROWID ,CODE_COMBINATION_ID ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,CHART_OF_ACCOUNTS_ID ,DETAIL_POSTING_ALLOWED_FLAG ,DETAIL_BUDGETING_ALLOWED_FLAG ,ACCOUNT_TYPE ,ENABLED_FLAG ,SUMMARY_FLAG ,SUBSTRB(DECODE( SEGMENT1, NULL, NULL, SEGMENT1||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT1', SEGMENT1 )),1,240) SEGMENT1 ,SUBSTRB(DECODE( SEGMENT2, NULL, NULL, SEGMENT2||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT2', SEGMENT2 )),1,240) SEGMENT2 ,SUBSTRB(DECODE( SEGMENT3, NULL, NULL, SEGMENT3||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT3', SEGMENT3 )),1,240) SEGMENT3 ,SUBSTRB(DECODE( SEGMENT4, NULL, NULL, SEGMENT4||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT4', SEGMENT4 )),1,240) SEGMENT4 ,SUBSTRB(DECODE( SEGMENT5, NULL, NULL, SEGMENT5||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT5', SEGMENT5 )),1,240) SEGMENT5 ,SUBSTRB(DECODE( SEGMENT6, NULL, NULL, SEGMENT6||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT6', SEGMENT6 )),1,240) SEGMENT6 ,SUBSTRB(DECODE( SEGMENT7, NULL, NULL, SEGMENT7||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT7', SEGMENT7 )),1,240) SEGMENT7 ,SUBSTRB(DECODE( SEGMENT8, NULL, NULL, SEGMENT8||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT8', SEGMENT8 )),1,240) SEGMENT8 ,SUBSTRB(DECODE( SEGMENT9, NULL, NULL, SEGMENT9||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT9', SEGMENT9 )),1,240) SEGMENT9 ,SUBSTRB(DECODE(SEGMENT10, NULL, NULL, SEGMENT10||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT10', SEGMENT10 )),1,240) SEGMENT10 ,SUBSTRB(DECODE(SEGMENT11, NULL, NULL, SEGMENT11||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT11', SEGMENT11 )),1,240) SEGMENT11 ,SUBSTRB(DECODE(SEGMENT12, NULL, NULL, SEGMENT12||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT12', SEGMENT12 )),1,240) SEGMENT12 ,SUBSTRB(DECODE(SEGMENT13, NULL, NULL, SEGMENT13||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT13', SEGMENT13 )),1,240) SEGMENT13 ,SUBSTRB(DECODE(SEGMENT14, NULL, NULL, SEGMENT14||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT14', SEGMENT14 )),1,240) SEGMENT14 ,SUBSTRB(DECODE(SEGMENT15, NULL, NULL, SEGMENT15||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT15', SEGMENT15 )),1,240) SEGMENT15 ,SUBSTRB(DECODE(SEGMENT16, NULL, NULL, SEGMENT16||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT16', SEGMENT16 )),1,240) SEGMENT16 ,SUBSTRB(DECODE(SEGMENT17, NULL, NULL, SEGMENT17||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT17', SEGMENT17 )),1,240) SEGMENT17 ,SUBSTRB(DECODE(SEGMENT18, NULL, NULL, SEGMENT18||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT18', SEGMENT18 )),1,240) SEGMENT18 ,SUBSTRB(DECODE(SEGMENT19, NULL, NULL, SEGMENT19||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT19', SEGMENT19 )),1,240) SEGMENT19 ,SUBSTRB(DECODE(SEGMENT20, NULL, NULL, SEGMENT20||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT20', SEGMENT20 )),1,240) SEGMENT20 ,SUBSTRB(DECODE(SEGMENT21, NULL, NULL, SEGMENT21||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT21', SEGMENT21 )),1,240) SEGMENT21 ,SUBSTRB(DECODE(SEGMENT22, NULL, NULL, SEGMENT22||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT22', SEGMENT22 )),1,240) SEGMENT22 ,SUBSTRB(DECODE(SEGMENT23, NULL, NULL, SEGMENT23||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT23', SEGMENT23 )),1,240) SEGMENT23 ,SUBSTRB(DECODE(SEGMENT24, NULL, NULL, SEGMENT24||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT24', SEGMENT24 )),1,240) SEGMENT24 ,SUBSTRB(DECODE(SEGMENT25, NULL, NULL, SEGMENT25||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT25', SEGMENT25 )),1,240) SEGMENT25 ,SUBSTRB(DECODE(SEGMENT26, NULL, NULL, SEGMENT26||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT26', SEGMENT26 )),1,240) SEGMENT26 ,SUBSTRB(DECODE(SEGMENT27, NULL, NULL, SEGMENT27||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT27', SEGMENT27 )),1,240) SEGMENT27 ,SUBSTRB(DECODE(SEGMENT28, NULL, NULL, SEGMENT28||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT28', SEGMENT28 )),1,240) SEGMENT28 ,SUBSTRB(DECODE(SEGMENT29, NULL, NULL, SEGMENT29||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT29', SEGMENT29 )),1,240) SEGMENT29 ,SUBSTRB(DECODE(SEGMENT30, NULL, NULL, SEGMENT30||' - '||FII_GL_BIS_MSC_PKG.get_description_sql(CHART_OF_ACCOUNTS_ID, 'SEGMENT30', SEGMENT30 )),1,240) SEGMENT30 ,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 ,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 ,JGZZ_RECON_CONTEXT ,REFERENCE1 ,REFERENCE2 ,REFERENCE3 ,REFERENCE4 ,REFERENCE5 ,PRESERVE_FLAG ,REFRESH_FLAG FROM GL_CODE_COMBINATIONS WHERE '_SEC:GL:NULL,CODE_COMBINATION_ID' IS NOT NULL) gla, FND_ID_FLEX_STRUCTURES_TL CHART_OF_ACCOUNTS_TL WHERE (gla.CHART_OF_ACCOUNTS_ID = CHART_OF_ACCOUNTS_TL.ID_FLEX_NUM) AND (CHART_OF_ACCOUNTS_TL.LANGUAGE = USERENV('LANG') AND CHART_OF_ACCOUNTS_TL.APPLICATION_ID = 101 AND CHART_OF_ACCOUNTS_TL.ID_FLEX_CODE = 'GL#') WITH READ ONLY

View Text - HTML Formatted

SELECT GLA.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GLA'
, GLA.CHART_OF_ACCOUNTS_ID
, CHART_OF_ACCOUNTS_TL.ID_FLEX_STRUCTURE_NAME
, '_LA:GLA.ACCOUNT_TYPE:GL_LOOKUPS:ACCOUNT TYPE:DESCRIPTION'
, GLA.DESCRIPTION
, GLA.START_DATE_ACTIVE
, GLA.END_DATE_ACTIVE
, '_LA:GLA.ENABLED_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GLA.DETAIL_POSTING_ALLOWED_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GLA.DETAIL_BUDGETING_ALLOWED_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:DECODE(GLA.SUMMARY_FLAG
, ''N''
, ''DTL''
, ''SUM''):GL_LOOKUPS:SUMMARY_FLAG:MEANING'
, '_LA:GLA.PRESERVE_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_DF:SQLGL:GL_CODE_COMBINATIONS:GLA'
FROM (SELECT ROWID
, CODE_COMBINATION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CHART_OF_ACCOUNTS_ID
, DETAIL_POSTING_ALLOWED_FLAG
, DETAIL_BUDGETING_ALLOWED_FLAG
, ACCOUNT_TYPE
, ENABLED_FLAG
, SUMMARY_FLAG
, SUBSTRB(DECODE( SEGMENT1
, NULL
, NULL
, SEGMENT1||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT1'
, SEGMENT1 ))
, 1
, 240) SEGMENT1
, SUBSTRB(DECODE( SEGMENT2
, NULL
, NULL
, SEGMENT2||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT2'
, SEGMENT2 ))
, 1
, 240) SEGMENT2
, SUBSTRB(DECODE( SEGMENT3
, NULL
, NULL
, SEGMENT3||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT3'
, SEGMENT3 ))
, 1
, 240) SEGMENT3
, SUBSTRB(DECODE( SEGMENT4
, NULL
, NULL
, SEGMENT4||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT4'
, SEGMENT4 ))
, 1
, 240) SEGMENT4
, SUBSTRB(DECODE( SEGMENT5
, NULL
, NULL
, SEGMENT5||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT5'
, SEGMENT5 ))
, 1
, 240) SEGMENT5
, SUBSTRB(DECODE( SEGMENT6
, NULL
, NULL
, SEGMENT6||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT6'
, SEGMENT6 ))
, 1
, 240) SEGMENT6
, SUBSTRB(DECODE( SEGMENT7
, NULL
, NULL
, SEGMENT7||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT7'
, SEGMENT7 ))
, 1
, 240) SEGMENT7
, SUBSTRB(DECODE( SEGMENT8
, NULL
, NULL
, SEGMENT8||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT8'
, SEGMENT8 ))
, 1
, 240) SEGMENT8
, SUBSTRB(DECODE( SEGMENT9
, NULL
, NULL
, SEGMENT9||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT9'
, SEGMENT9 ))
, 1
, 240) SEGMENT9
, SUBSTRB(DECODE(SEGMENT10
, NULL
, NULL
, SEGMENT10||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT10'
, SEGMENT10 ))
, 1
, 240) SEGMENT10
, SUBSTRB(DECODE(SEGMENT11
, NULL
, NULL
, SEGMENT11||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT11'
, SEGMENT11 ))
, 1
, 240) SEGMENT11
, SUBSTRB(DECODE(SEGMENT12
, NULL
, NULL
, SEGMENT12||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT12'
, SEGMENT12 ))
, 1
, 240) SEGMENT12
, SUBSTRB(DECODE(SEGMENT13
, NULL
, NULL
, SEGMENT13||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT13'
, SEGMENT13 ))
, 1
, 240) SEGMENT13
, SUBSTRB(DECODE(SEGMENT14
, NULL
, NULL
, SEGMENT14||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT14'
, SEGMENT14 ))
, 1
, 240) SEGMENT14
, SUBSTRB(DECODE(SEGMENT15
, NULL
, NULL
, SEGMENT15||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT15'
, SEGMENT15 ))
, 1
, 240) SEGMENT15
, SUBSTRB(DECODE(SEGMENT16
, NULL
, NULL
, SEGMENT16||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT16'
, SEGMENT16 ))
, 1
, 240) SEGMENT16
, SUBSTRB(DECODE(SEGMENT17
, NULL
, NULL
, SEGMENT17||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT17'
, SEGMENT17 ))
, 1
, 240) SEGMENT17
, SUBSTRB(DECODE(SEGMENT18
, NULL
, NULL
, SEGMENT18||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT18'
, SEGMENT18 ))
, 1
, 240) SEGMENT18
, SUBSTRB(DECODE(SEGMENT19
, NULL
, NULL
, SEGMENT19||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT19'
, SEGMENT19 ))
, 1
, 240) SEGMENT19
, SUBSTRB(DECODE(SEGMENT20
, NULL
, NULL
, SEGMENT20||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT20'
, SEGMENT20 ))
, 1
, 240) SEGMENT20
, SUBSTRB(DECODE(SEGMENT21
, NULL
, NULL
, SEGMENT21||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT21'
, SEGMENT21 ))
, 1
, 240) SEGMENT21
, SUBSTRB(DECODE(SEGMENT22
, NULL
, NULL
, SEGMENT22||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT22'
, SEGMENT22 ))
, 1
, 240) SEGMENT22
, SUBSTRB(DECODE(SEGMENT23
, NULL
, NULL
, SEGMENT23||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT23'
, SEGMENT23 ))
, 1
, 240) SEGMENT23
, SUBSTRB(DECODE(SEGMENT24
, NULL
, NULL
, SEGMENT24||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT24'
, SEGMENT24 ))
, 1
, 240) SEGMENT24
, SUBSTRB(DECODE(SEGMENT25
, NULL
, NULL
, SEGMENT25||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT25'
, SEGMENT25 ))
, 1
, 240) SEGMENT25
, SUBSTRB(DECODE(SEGMENT26
, NULL
, NULL
, SEGMENT26||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT26'
, SEGMENT26 ))
, 1
, 240) SEGMENT26
, SUBSTRB(DECODE(SEGMENT27
, NULL
, NULL
, SEGMENT27||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT27'
, SEGMENT27 ))
, 1
, 240) SEGMENT27
, SUBSTRB(DECODE(SEGMENT28
, NULL
, NULL
, SEGMENT28||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT28'
, SEGMENT28 ))
, 1
, 240) SEGMENT28
, SUBSTRB(DECODE(SEGMENT29
, NULL
, NULL
, SEGMENT29||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT29'
, SEGMENT29 ))
, 1
, 240) SEGMENT29
, SUBSTRB(DECODE(SEGMENT30
, NULL
, NULL
, SEGMENT30||' - '||FII_GL_BIS_MSC_PKG.GET_DESCRIPTION_SQL(CHART_OF_ACCOUNTS_ID
, 'SEGMENT30'
, SEGMENT30 ))
, 1
, 240) SEGMENT30
, 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
, 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
, JGZZ_RECON_CONTEXT
, REFERENCE1
, REFERENCE2
, REFERENCE3
, REFERENCE4
, REFERENCE5
, PRESERVE_FLAG
, REFRESH_FLAG
FROM GL_CODE_COMBINATIONS
WHERE '_SEC:GL:NULL
, CODE_COMBINATION_ID' IS NOT NULL) GLA
, FND_ID_FLEX_STRUCTURES_TL CHART_OF_ACCOUNTS_TL
WHERE (GLA.CHART_OF_ACCOUNTS_ID = CHART_OF_ACCOUNTS_TL.ID_FLEX_NUM)
AND (CHART_OF_ACCOUNTS_TL.LANGUAGE = USERENV('LANG')
AND CHART_OF_ACCOUNTS_TL.APPLICATION_ID = 101
AND CHART_OF_ACCOUNTS_TL.ID_FLEX_CODE = 'GL#') WITH READ ONLY