View: GLFV_GL_ACCOUNTS_DESCR

Product:	GL - General Ledger
Description:	General Ledger accounts are account code combinations defined for a chart of accounts. Shows codes and descriptions.
Implementation/DBA Data:	APPS.GLFV_GL_ACCOUNTS_DESCR

View Text

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

Columns