View: IGC_CBC_BAL_V

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

View Text

SELECT DET.SET_OF_BOOKS_ID
, SU.SUMMARY_CODE_COMBINATION_ID CODE_COMBINATION_ID
, DET.BUDGET_VERSION_ID
, SUM(DET.BUDGET_AMOUNT)
, SUM(DET.COMM_AMOUNT)
, SUM(DET.ACT_AMOUNT)
, SUM(DET.OTH_AMOUNT)
, SUM(DET.TOT_AMOUNT)
, SUM(DET.FA_AMOUNT)
, MAX(DET.AMOUNT_TYPE) AMOUNT_TYPE
, MAX(DET.PERIOD_NAME) PERIOD_NAME
, SU.TEMPLATE_ID
, MAX(DET.LAST_UPDATE_DATE)
, MAX(DET.LAST_UPDATED_BY)
FROM IGC_CBC_DET_BALANCES_V DET
, GL_ACCOUNT_HIERARCHIES SU
WHERE SU.DETAIL_CODE_COMBINATION_ID=DET.CODE_COMBINATION_ID
AND SU.SET_OF_BOOKS_ID=DET.SET_OF_BOOKS_ID GROUP BY DET.SET_OF_BOOKS_ID
, SU.SUMMARY_CODE_COMBINATION_ID
, DET.BUDGET_VERSION_ID
, SU.TEMPLATE_ID UNION SELECT SET_OF_BOOKS_ID
, CODE_COMBINATION_ID
, BUDGET_VERSION_ID
, BUDGET_AMOUNT
, COMM_AMOUNT
, ACT_AMOUNT
, OTH_AMOUNT
, TOT_AMOUNT
, FA_AMOUNT
, AMOUNT_TYPE
, PERIOD_NAME
, TO_NUMBER('') TEMPLATE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM IGC_CBC_DET_BALANCES_V

Columns