View: IGC_CBC_JE_LINES_BAL_PTD_V

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

View Text

SELECT MIN(ACTUAL_FLAG)
, MIN(SET_OF_BOOKS_ID)
, ENCUMBRANCE_TYPE_ID
, MIN(BUDGET_VERSION_ID)
, CODE_COMBINATION_ID
, MIN(AMOUNT_TYPE)
, MIN(PERIOD_YEAR)
, SUM(ENTERED_DR)
, SUM(ENTERED_CR)
, PERIOD_NAME
, MIN(QUARTER_NUM)
, MIN(PERIOD_NUM)
, MIN(STATUS)
, MIN(DETAIL_SUMMARY_CODE)
, MIN(CURRENCY_CODE)
, MIN( 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
, CBC_JE_BATCH_ID
, ACTUAL_FLAG
, ENCUMBRANCE_TYPE_ID
, CBC_JE_LINE_NUM))
, PERIOD_SET_NAME
FROM IGC_CBC_JE_LINES GROUP BY CODE_COMBINATION_ID
, PERIOD_NAME
, ENCUMBRANCE_TYPE_ID
, SET_OF_BOOKS_ID
, PERIOD_YEAR
, PERIOD_SET_NAME

Columns