[Home] [Help]
VIEW: APPS.MTH_ITEM_COST_MV#
Source
View Text - Preformatted
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
View Text - HTML Formatted
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