VIEW: APPS.IGC_CBC_BALANCES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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