View: GL_SUMMARY_COMBINATIONS_V

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

View Text

SELECT /* $HEADER: GLGVWREG.LDT 120.29.12020000.1 2012/06/27 14:57:54 APPLDEV SHIP $ */ CC.ROWID ROW_ID
, T.LEDGER_ID LEDGER_ID
, CC.CODE_COMBINATION_ID 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.ACCOUNT_TYPE 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.ALLOCATION_CREATE_FLAG ALLOCATION_CREATE_FLAG
, 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 FROM GL_SUMMARY_TEMPLATES T
, GL_CODE_COMBINATIONS CC
WHERE T.TEMPLATE_ID(+) = CC.TEMPLATE_ID+0

Columns