VIEW: APPS.IGI_BUD_CODE_COMBINATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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