MATERIALIZED VIEW: APPS.FEM_BAL_LIEXCC_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.COMPANY_COST_CENTER_ORG_ID,
FEM_BAL_BASE_SUMMARY_MV.COMPANY_COST_CENTER_ORG_VS_ID,
FEM_BAL_BASE_SUMMARY_MV.LINE_ITEM_ID,
FEM_BAL_BASE_SUMMARY_MV.LINE_ITEM_VS_ID,
FEM_LN_ITEMS_ATTRD_MV.EXTENDED_ACCOUNT_TYPE,
FEM_LN_ITEMS_ATTRD_MV.BASIC_ACCOUNT_TYPE,
FEM_LN_ITEMS_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_LN_ITEMS_ATTRD_MV,
FEM_BAL_BASE_SUMMARY_MV
where
FEM_LN_ITEMS_ATTRD_MV.VALUE_SET_ID = FEM_BAL_BASE_SUMMARY_MV.LINE_ITEM_VS_ID
AND FEM_LN_ITEMS_ATTRD_MV.LINE_ITEM_ID = FEM_BAL_BASE_SUMMARY_MV.LINE_ITEM_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_BAL_BASE_SUMMARY_MV.LINE_ITEM_ID,
FEM_BAL_BASE_SUMMARY_MV.LINE_ITEM_VS_ID,
FEM_LN_ITEMS_ATTRD_MV.EXTENDED_ACCOUNT_TYPE,
FEM_LN_ITEMS_ATTRD_MV.BASIC_ACCOUNT_TYPE,
FEM_LN_ITEMS_ATTRD_MV.EXTENDED_ACCOUNT_SIGN