eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGC_CBC_BALANCES_V

Product:	IGC - Contract Commitment
Description:
Implementation/DBA Data:	APPS.IGC_CBC_BALANCES_V

View Text

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

Columns

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