MATERIALIZED VIEW: APPS.POA_PQC_BS_J_MV

Source

select /* 12.0: bug#4526784 */
f.rowid frid,
cal.rowid crid,
com.rowid comrid,
map.rowid mrid,
f.creation_operating_unit_id org_id,
f.ship_to_org_id,
nvl(com.commodity_id, -1) commodity_id,
f.base_uom base_uom,
f.supplier_id,
f.supplier_site_id,
f.category_id,
f.po_item_id,
f.buyer_id,
map.parent_company_dim_id company_id,
map.parent_cost_center_dim_id cost_center_id,
cal.ent_qtr_id,
cal.ent_period_id,
cal.week_id,
cal.report_date_julian day_id,
f.purchase_amount_b * f.func_cur_conv_rate purchase_amt_b,
decode(
  f.global_cur_conv_rate,0,
  f.purchase_amount_b,
  f.purchase_amount_b * f.func_cur_conv_rate * f.global_cur_conv_rate
) purchase_amt_g,
decode(
  f.sglobal_cur_conv_rate,0,
  f.purchase_amount_b,
  f.purchase_amount_b * f.func_cur_conv_rate * f.sglobal_cur_conv_rate
) purchase_amt_sg,
decode(f.quantity, 0, To_number(null), f.quantity) quantity,
cal.ent_year_id -1 p_ent_year_id,
cal.ent_year_id,
f.global_cur_conv_rate,
f.po_header_id,
f.po_line_id,
f.po_release_id,
f.approved_date,
f.consigned_code,
f.order_type,
f.complex_work_flag,
f.line_location_id,
f.po_distribution_id
from
POA.POA_DBI_POD_F f,
FII.FII_TIME_DAY cal,
PO.PO_COMMODITY_CATEGORIES com,
FII.FII_COM_CC_DIM_MAPS map
where f.approved_date = cal.report_date
and   f.category_id = com.category_id(+)
and   f.company_id = map.child_company_id(+)
and   f.cost_center_id = map.child_cost_center_id(+)