MATERIALIZED VIEW: APPS.POA_PQC_BS_J2_MV

Source

select /* 12.0: bug#4526784 */
 f.rowid frid,
 pip.rowid prid,
 pisp.ROWID psrid,
 f.org_id,
 f.ship_to_org_id,
 f.supplier_id,
 f.supplier_site_id,
 f.commodity_id,
 f.category_id,
 f.po_item_id,
 f.base_uom,
 f.buyer_id,
 f.company_id,
 f.cost_center_id,
 f.ent_qtr_id,
 f.ent_period_id,
 f.week_id,
 f.day_id,
 f.ent_year_id,
 f.p_ent_year_id,
 f.purchase_amt_g,
 f.purchase_amt_sg,
 f.purchase_amt_b,
 f.quantity,
 f.global_cur_conv_rate,
 pip.purchase_amt_g pip_amt_g,
 pip.purchase_amt_sg pip_amt_sg,
 pip.purchase_amt_b pip_amt_b,
 pip.quantity pip_quantity,
 pisp.purchase_amt_g pisp_amt_g,
 pisp.purchase_amt_sg pisp_amt_sg,
 pisp.quantity pisp_quantity,
 f.po_header_id,
 f.po_line_id,
 f.po_release_id,
 f.approved_date,
 f.order_type,
 f.consigned_code,
 f.complex_work_flag
from
 poa_pqc_bs_j_mv f,
 poa_bm_item_o_mv pip,
 poa_bm_item_s_mv pisp
where f.p_ent_year_id = pip.ent_year_id(+)
and   f.org_id = pip.org_id(+)
and   f.po_item_id = pip.po_item_id(+)
and   f.base_uom = pip.base_uom(+)
and   f.p_ent_year_id = pisp.ent_year_id(+)
and   f.po_item_id = pisp.po_item_id(+)
and   f.base_uom = pisp.base_uom(+)
and   f.supplier_id = pisp.supplier_id(+)