VIEW: APPS.IGC_CBC_BAL_V

Source

View Text - Preformatted

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.LEDGER_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

View Text - HTML Formatted

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.LEDGER_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