MATERIALIZED VIEW: APPS.FEM_BAL_BASE_SUMMARY_MV

Source

select
FEM_BALANCES_V.LEDGER_ID,
FEM_BALANCES_V.DATASET_CODE,
FEM_BALANCES_V.CAL_PERIOD_ID,
FEM_BALANCES_V.CURRENCY_CODE,
FEM_BALANCES_V.COMPANY_COST_CENTER_ORG_ID,
FEM_BALANCES_V.COMPANY_COST_CENTER_ORG_VS_ID,
FEM_BALANCES_V.NATURAL_ACCOUNT_ID,
FEM_BALANCES_V.NATURAL_ACCOUNT_VS_ID,
FEM_BALANCES_V.LINE_ITEM_ID,
FEM_BALANCES_V.LINE_ITEM_VS_ID,
FEM_BALANCES_V.PRODUCT_ID,
FEM_BALANCES_V.PRODUCT_VS_ID,
FEM_BALANCES_V.ENTITY_ID,
FEM_BALANCES_V.ENTITY_VS_ID,
SUM( FEM_BALANCES_V.XTD_BALANCE_E) XTD_BALANCE_E,
SUM( FEM_BALANCES_V.XTD_BALANCE_F) XTD_BALANCE_F,
SUM( FEM_BALANCES_V.QTD_BALANCE_E) QTD_BALANCE_E,
SUM( FEM_BALANCES_V.QTD_BALANCE_F) QTD_BALANCE_F,
SUM( FEM_BALANCES_V.YTD_BALANCE_E) YTD_BALANCE_E,
SUM( FEM_BALANCES_V.YTD_BALANCE_F) YTD_BALANCE_F,
SUM(PTD_CREDIT_BALANCE_E) PTD_CREDIT_BALANCE_E,
SUM(PTD_DEBIT_BALANCE_E) PTD_DEBIT_BALANCE_E,
SUM(YTD_CREDIT_BALANCE_E) YTD_CREDIT_BALANCE_E,
SUM(YTD_DEBIT_BALANCE_E) YTD_DEBIT_BALANCE_E
FROM fem_balances_v
group by FEM_BALANCES_V.LEDGER_ID,
FEM_BALANCES_V.DATASET_CODE,
FEM_BALANCES_V.CAL_PERIOD_ID,
FEM_BALANCES_V.CURRENCY_CODE,
FEM_BALANCES_V.COMPANY_COST_CENTER_ORG_ID,
FEM_BALANCES_V.COMPANY_COST_CENTER_ORG_VS_ID,
FEM_BALANCES_V.NATURAL_ACCOUNT_ID,
FEM_BALANCES_V.NATURAL_ACCOUNT_VS_ID,
FEM_BALANCES_V.LINE_ITEM_ID,
FEM_BALANCES_V.LINE_ITEM_VS_ID,
FEM_BALANCES_V.PRODUCT_ID,
FEM_BALANCES_V.PRODUCT_VS_ID,
FEM_BALANCES_V.ENTITY_ID,
FEM_BALANCES_V.ENTITY_VS_ID