VIEW: APPS.IGC_CBC_JE_LINES_BAL_ALL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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