MATERIALIZED VIEW: APPS.POA_BM_ITEM_O_MV

Source

select /* 12.0: bug#4526784 */
 f.ent_year_id,
 f.org_id,
 f.po_item_id,
 f.base_uom,
 sum(purchase_amt_g) purchase_amt_g,
 count(purchase_amt_g) c_purchase_amt_g,
 sum(purchase_amt_sg) purchase_amt_sg,
 count(purchase_amt_sg) c_purchase_amt_sg,
 sum(purchase_amt_b) purchase_amt_b,
 count(purchase_amt_b) c_purchase_amt_b,
 sum(quantity) quantity,
 count(quantity) c_quantity,
 count(*) c_total
from poa_pqc_bs_j_mv f
where f.order_type = 'QUANTITY'
and f.consigned_code <> 1
and f.complex_work_flag = 'N'
group by ent_year_id,org_id,po_item_id,base_uom