View: GL_CODE_COMBINATIONS_KFV

Product:	GL - General Ledger
Description:	10SC ONLY
Implementation/DBA Data:	APPS.GL_CODE_COMBINATIONS_KFV

View Text

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

Columns