Product: | IGI - Public Sector Financials International |
---|---|
Description: | Based on GL_CODE_COMBINATIONS |
Implementation/DBA Data: | APPS.IGI_BUD_CODE_COMBINATIONS_V |
SELECT CC.ROWID ROW_ID
, CC.CODE_COMBINATION_ID
, CC.CHART_OF_ACCOUNTS_ID
, CC.DETAIL_POSTING_ALLOWED_FLAG
, CC.DETAIL_BUDGETING_ALLOWED_FLAG
, CC.ACCOUNT_TYPE
, LK.DESCRIPTION SHOW_ACCOUNT_TYPE
, CC.ENABLED_FLAG
, CC.SUMMARY_FLAG
, CC.SEGMENT1
, CC.SEGMENT2
, CC.SEGMENT3
, CC.SEGMENT4
, CC.SEGMENT5
, CC.SEGMENT6
, CC.SEGMENT7
, CC.SEGMENT8
, CC.SEGMENT9
, CC.SEGMENT10
, CC.SEGMENT11
, CC.SEGMENT12
, CC.SEGMENT13
, CC.SEGMENT14
, CC.SEGMENT15
, CC.SEGMENT16
, CC.SEGMENT17
, CC.SEGMENT18
, CC.SEGMENT19
, CC.SEGMENT20
, CC.SEGMENT21
, CC.SEGMENT22
, CC.SEGMENT23
, CC.SEGMENT24
, CC.SEGMENT25
, CC.SEGMENT26
, CC.SEGMENT27
, CC.SEGMENT28
, CC.SEGMENT29
, CC.SEGMENT30
, CC.DESCRIPTION
, CC.TEMPLATE_ID
, CC.START_DATE_ACTIVE
, CC.END_DATE_ACTIVE
, CC.ATTRIBUTE1
, CC.ATTRIBUTE2
, CC.ATTRIBUTE3
, CC.ATTRIBUTE4
, CC.ATTRIBUTE5
, CC.ATTRIBUTE6
, CC.ATTRIBUTE7
, CC.ATTRIBUTE8
, CC.ATTRIBUTE9
, CC.ATTRIBUTE10
, CC.CONTEXT
, CC.SEGMENT_ATTRIBUTE1
, CC.SEGMENT_ATTRIBUTE2
, CC.SEGMENT_ATTRIBUTE3
, CC.SEGMENT_ATTRIBUTE4
, CC.SEGMENT_ATTRIBUTE5
, CC.SEGMENT_ATTRIBUTE6
, CC.SEGMENT_ATTRIBUTE7
, CC.SEGMENT_ATTRIBUTE8
, CC.SEGMENT_ATTRIBUTE9
, CC.SEGMENT_ATTRIBUTE10
, CC.SEGMENT_ATTRIBUTE11
, CC.SEGMENT_ATTRIBUTE12
, CC.SEGMENT_ATTRIBUTE13
, CC.SEGMENT_ATTRIBUTE14
, CC.SEGMENT_ATTRIBUTE15
, CC.SEGMENT_ATTRIBUTE16
, CC.SEGMENT_ATTRIBUTE17
, CC.SEGMENT_ATTRIBUTE18
, CC.SEGMENT_ATTRIBUTE19
, CC.SEGMENT_ATTRIBUTE20
, CC.SEGMENT_ATTRIBUTE21
, CC.SEGMENT_ATTRIBUTE22
, CC.SEGMENT_ATTRIBUTE23
, CC.SEGMENT_ATTRIBUTE24
, CC.SEGMENT_ATTRIBUTE25
, CC.SEGMENT_ATTRIBUTE26
, CC.SEGMENT_ATTRIBUTE27
, CC.SEGMENT_ATTRIBUTE28
, CC.SEGMENT_ATTRIBUTE29
, CC.SEGMENT_ATTRIBUTE30
, CC.SEGMENT_ATTRIBUTE31
, CC.SEGMENT_ATTRIBUTE32
, CC.SEGMENT_ATTRIBUTE33
, CC.SEGMENT_ATTRIBUTE34
, CC.SEGMENT_ATTRIBUTE35
, CC.SEGMENT_ATTRIBUTE36
, CC.SEGMENT_ATTRIBUTE37
, CC.SEGMENT_ATTRIBUTE38
, CC.SEGMENT_ATTRIBUTE39
, CC.SEGMENT_ATTRIBUTE40
, CC.SEGMENT_ATTRIBUTE41
, CC.SEGMENT_ATTRIBUTE42
, CC.JGZZ_RECON_CONTEXT
, CC.JGZZ_RECON_FLAG
, CC.REFERENCE1
, CC.REFERENCE2
, CC.REFERENCE3
, CC.REFERENCE4
, CC.REFERENCE5
, CC.IGI_BALANCED_BUDGET_FLAG
, CC.LAST_UPDATE_DATE
, CC.LAST_UPDATED_BY
FROM GL_CODE_COMBINATIONS CC
, GL_LOOKUPS LK
WHERE LK.LOOKUP_TYPE(+) = 'ACCOUNT TYPE' AND LK.LOOKUP_CODE(+) = CC.ACCOUNT_TYPE