VIEW: APPS.IGC_CBC_JE_LINES_BAL_PTD_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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