[Home] [Help]
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
Name |
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 |
TEMPLATE_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |