View: IGC_CBC_JE_LINES_BAL_ALL_V

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

View Text

SELECT ACTUAL_FLAG
, SET_OF_BOOKS_ID
, ENCUMBRANCE_TYPE_ID
, BUDGET_VERSION_ID
, CODE_COMBINATION_ID
, MIN(AMOUNT_TYPE)
, PERIOD_YEAR
, SUM(ENTERED_DR)
, SUM(ENTERED_CR)
, PERIOD_NAME
, QUARTER_NUM
, PERIOD_NUM
, MIN(STATUS)
, IGC_CBC_INQUIRY_PKG.GET_FC_BALANCES('PTD_BALANCE'
, CODE_COMBINATION_ID
, SET_OF_BOOKS_ID
, BUDGET_VERSION_ID
, PERIOD_YEAR
, PERIOD_NUM
, QUARTER_NUM
, NULL
, ACTUAL_FLAG
, ENCUMBRANCE_TYPE_ID
, NULL)
, IGC_CBC_INQUIRY_PKG.GET_FC_BALANCES('QTD_BALANCE'
, CODE_COMBINATION_ID
, SET_OF_BOOKS_ID
, BUDGET_VERSION_ID
, PERIOD_YEAR
, PERIOD_NUM
, QUARTER_NUM
, NULL
, ACTUAL_FLAG
, ENCUMBRANCE_TYPE_ID
, NULL)
, IGC_CBC_INQUIRY_PKG.GET_FC_BALANCES('YTD_BALANCE'
, CODE_COMBINATION_ID
, SET_OF_BOOKS_ID
, BUDGET_VERSION_ID
, PERIOD_YEAR
, PERIOD_NUM
, QUARTER_NUM
, NULL
, ACTUAL_FLAG
, ENCUMBRANCE_TYPE_ID
, NULL)
FROM IGC_CBC_JE_LINES GROUP BY PERIOD_NAME
, QUARTER_NUM
, PERIOD_NUM
, ACTUAL_FLAG
, SET_OF_BOOKS_ID
, ENCUMBRANCE_TYPE_ID
, BUDGET_VERSION_ID
, CODE_COMBINATION_ID
, PERIOD_YEAR

Columns