MATERIALIZED VIEW: APPS.FEM_BAL_NAEXPR_ATTR_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.PRODUCT_ID,
FEM_BAL_BASE_SUMMARY_MV.PRODUCT_VS_ID,
FEM_BAL_BASE_SUMMARY_MV.NATURAL_ACCOUNT_ID,
FEM_BAL_BASE_SUMMARY_MV.NATURAL_ACCOUNT_VS_ID,
FEM_NAT_ACCTS_ATTRD_MV.EXTENDED_ACCOUNT_TYPE,
FEM_NAT_ACCTS_ATTRD_MV.BASIC_ACCOUNT_TYPE,
FEM_NAT_ACCTS_ATTRD_MV.EXTENDED_ACCOUNT_SIGN,
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_NAT_ACCTS_ATTRD_MV,
FEM_BAL_BASE_SUMMARY_MV
where
FEM_NAT_ACCTS_ATTRD_MV.VALUE_SET_ID = FEM_BAL_BASE_SUMMARY_MV.NATURAL_ACCOUNT_VS_ID
AND FEM_NAT_ACCTS_ATTRD_MV.NATURAL_ACCOUNT_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.PRODUCT_ID,
FEM_BAL_BASE_SUMMARY_MV.PRODUCT_VS_ID,
FEM_BAL_BASE_SUMMARY_MV.NATURAL_ACCOUNT_ID,
FEM_BAL_BASE_SUMMARY_MV.NATURAL_ACCOUNT_VS_ID,
FEM_NAT_ACCTS_ATTRD_MV.EXTENDED_ACCOUNT_TYPE,
FEM_NAT_ACCTS_ATTRD_MV.BASIC_ACCOUNT_TYPE,
FEM_NAT_ACCTS_ATTRD_MV.EXTENDED_ACCOUNT_SIGN