DBA Data[Home] [Help]

MATERIALIZED VIEW: APPS.MTH_ITEM_COST_MV

Source


Select   item_fk_key, sum(cost) cost, count(*) total_entries, Count(cost) num_entries
from     mth_item_cost
where    iscurrent=1
group by item_fk_key