Product: | IGC - Contract Commitment |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGC_CBC_BALANCES_V |
SELECT BAL.CODE_COMBINATION_ID
, BAL.BUDGET_VERSION_ID
, BAL.BUDGET_AMOUNT
, BAL.COMM_AMOUNT
, BAL.ACT_AMOUNT
, BAL.OTH_AMOUNT
, BAL.TOT_AMOUNT
, BAL.FA_AMOUNT
, BAL.AMOUNT_TYPE
, BAL.PERIOD_NAME
, BAL.TEMPLATE_ID
, COD.CHART_OF_ACCOUNTS_ID
, COD.ACCOUNT_TYPE
, COD.SEGMENT1
, COD.SEGMENT2
, COD.SEGMENT3
, COD.SEGMENT4
, COD.SEGMENT5
, COD.SEGMENT6
, COD.SEGMENT7
, COD.SEGMENT8
, COD.SEGMENT9
, COD.SEGMENT10
, COD.SEGMENT11
, COD.SEGMENT12
, COD.SEGMENT13
, COD.SEGMENT14
, COD.SEGMENT15
, COD.SEGMENT16
, COD.SEGMENT17
, COD.SEGMENT18
, COD.SEGMENT19
, COD.SEGMENT20
, COD.SEGMENT21
, COD.SEGMENT22
, COD.SEGMENT23
, COD.SEGMENT24
, COD.SEGMENT25
, COD.SEGMENT26
, COD.SEGMENT27
, COD.SEGMENT28
, COD.SEGMENT29
, COD.SEGMENT30
, COD.DESCRIPTION
, COD.ATTRIBUTE1
, COD.ATTRIBUTE2
, COD.ATTRIBUTE3
, COD.ATTRIBUTE4
, COD.ATTRIBUTE5
, COD.ATTRIBUTE6
, COD.ATTRIBUTE7
, COD.ATTRIBUTE8
, COD.ATTRIBUTE9
, COD.ATTRIBUTE10
, COD.CONTEXT
, COD.SEGMENT_ATTRIBUTE1
, COD.SEGMENT_ATTRIBUTE2
, COD.SEGMENT_ATTRIBUTE3
, COD.SEGMENT_ATTRIBUTE4
, COD.SEGMENT_ATTRIBUTE5
, COD.SEGMENT_ATTRIBUTE6
, COD.SEGMENT_ATTRIBUTE7
, COD.SEGMENT_ATTRIBUTE8
, COD.SEGMENT_ATTRIBUTE9
, COD.SEGMENT_ATTRIBUTE10
, COD.SEGMENT_ATTRIBUTE11
, COD.SEGMENT_ATTRIBUTE12
, COD.SEGMENT_ATTRIBUTE13
, COD.SEGMENT_ATTRIBUTE14
, COD.SEGMENT_ATTRIBUTE15
, COD.SEGMENT_ATTRIBUTE16
, COD.SEGMENT_ATTRIBUTE17
, COD.SEGMENT_ATTRIBUTE18
, COD.SEGMENT_ATTRIBUTE19
, COD.SEGMENT_ATTRIBUTE20
, COD.SEGMENT_ATTRIBUTE21
, COD.SEGMENT_ATTRIBUTE22
, COD.SEGMENT_ATTRIBUTE23
, COD.SEGMENT_ATTRIBUTE24
, COD.SEGMENT_ATTRIBUTE25
, COD.SEGMENT_ATTRIBUTE26
, COD.SEGMENT_ATTRIBUTE27
, COD.SEGMENT_ATTRIBUTE28
, COD.SEGMENT_ATTRIBUTE29
, COD.SEGMENT_ATTRIBUTE30
, COD.SEGMENT_ATTRIBUTE31
, COD.SEGMENT_ATTRIBUTE32
, COD.SEGMENT_ATTRIBUTE33
, COD.SEGMENT_ATTRIBUTE34
, COD.SEGMENT_ATTRIBUTE35
, COD.SEGMENT_ATTRIBUTE36
, COD.SEGMENT_ATTRIBUTE37
, COD.SEGMENT_ATTRIBUTE38
, COD.SEGMENT_ATTRIBUTE39
, COD.SEGMENT_ATTRIBUTE40
, COD.SEGMENT_ATTRIBUTE41
, COD.SEGMENT_ATTRIBUTE42
, COD.REFERENCE1
, COD.REFERENCE2
, COD.REFERENCE3
, COD.REFERENCE4
, COD.REFERENCE5
, BAL.SET_OF_BOOKS_ID
, BAL.LAST_UPDATE_DATE
, BAL.LAST_UPDATED_BY
FROM IGC_CBC_BAL_V BAL
, GL_CODE_COMBINATIONS COD
WHERE BAL.CODE_COMBINATION_ID =COD.CODE_COMBINATION_ID