VIEW: APPS.GL_CODE_COMBINATIONS_V

Source

View Text - Preformatted

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