MATERIALIZED VIEW: APPS.FEM_BAL_NACC_HIER_L2_MV

Source

select
FEM_BAL_BASE_SUMMARY_MV.LEDGER_ID,
FEM_BAL_BASE_SUMMARY_MV.DATASET_CODE,
FEM_BAL_BASE_SUMMARY_MV.CAL_PERIOD_ID,
FEM_BAL_BASE_SUMMARY_MV.CURRENCY_CODE,
FEM_BAL_BASE_SUMMARY_MV.COMPANY_COST_CENTER_ORG_ID,
FEM_BAL_BASE_SUMMARY_MV.COMPANY_COST_CENTER_ORG_VS_ID,
FEM_DIS_NAT_ACCTS_HIER_B.VALUE_SET_ID,
FEM_DIS_NAT_ACCTS_HIER_B.OBJECT_ID,
FEM_DIS_NAT_ACCTS_HIER_B.OBJECT_DEFINITION_ID,
FEM_DIS_NAT_ACCTS_HIER_B.LEVEL1_ID,
FEM_DIS_NAT_ACCTS_HIER_B.LEVEL2_ID ,
FEM_DIS_NAT_ACCTS_HIER_B.VALUE_SET_ID NATURAL_ACCOUNT_VS_ID,
SUM( FEM_BAL_BASE_SUMMARY_MV.XTD_BALANCE_E) XTD_BALANCE_E,
SUM( FEM_BAL_BASE_SUMMARY_MV.XTD_BALANCE_F) XTD_BALANCE_F,
SUM( FEM_BAL_BASE_SUMMARY_MV.QTD_BALANCE_E) QTD_BALANCE_E,
SUM( FEM_BAL_BASE_SUMMARY_MV.QTD_BALANCE_F) QTD_BALANCE_F,
SUM( FEM_BAL_BASE_SUMMARY_MV.YTD_BALANCE_E) YTD_BALANCE_E,
SUM( FEM_BAL_BASE_SUMMARY_MV.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_DIS_NAT_ACCTS_HIER_B,
FEM_BAL_BASE_SUMMARY_MV
where
 FEM_DIS_NAT_ACCTS_HIER_B.VALUE_SET_ID = FEM_BAL_BASE_SUMMARY_MV.NATURAL_ACCOUNT_VS_ID
AND FEM_DIS_NAT_ACCTS_HIER_B.LEVEL20_ID = FEM_BAL_BASE_SUMMARY_MV.NATURAL_ACCOUNT_ID
GROUP BY
FEM_BAL_BASE_SUMMARY_MV.LEDGER_ID,
FEM_BAL_BASE_SUMMARY_MV.DATASET_CODE,
FEM_BAL_BASE_SUMMARY_MV.CAL_PERIOD_ID,
FEM_BAL_BASE_SUMMARY_MV.CURRENCY_CODE,
FEM_BAL_BASE_SUMMARY_MV.COMPANY_COST_CENTER_ORG_ID,
FEM_BAL_BASE_SUMMARY_MV.COMPANY_COST_CENTER_ORG_VS_ID,
FEM_DIS_NAT_ACCTS_HIER_B.VALUE_SET_ID,
FEM_DIS_NAT_ACCTS_HIER_B.OBJECT_ID,
FEM_DIS_NAT_ACCTS_HIER_B.OBJECT_DEFINITION_ID,
FEM_DIS_NAT_ACCTS_HIER_B.LEVEL1_ID,
FEM_DIS_NAT_ACCTS_HIER_B.LEVEL2_ID,
FEM_DIS_NAT_ACCTS_HIER_B.VALUE_SET_ID