MATERIALIZED VIEW: APPS.POA_DBI_PLL_MV

Source

SELECT /* 12.0: bug#4526784 */
 p.line_location_id,
 p.buyer_id,
 p.category_id,
 p.po_item_id,
 p.order_type,
 p.item_id,
 p.base_uom_conv_rate,
 p.expected_date,
 p.days_late_receipt_allowed,
 p.days_early_receipt_allowed,
 p.base_uom,
 p.price_override,
 p.matching_basis,
 p.receiving_routing_id,
 nvl(com.commodity_id,-1) commodity_id,
 p.payment_type,
 p.shipment_type,
 p.complex_work_flag,
 p.func_cur_code,
 count(*) cnt
 from
 POA.POA_DBI_POD_F p,
 PO.PO_COMMODITY_CATEGORIES com
 where
  p.category_id = com.category_id(+)
 group by
 p.buyer_id,
 p.category_id,
 p.po_item_id,
 p.order_type,
 p.item_id,
 p.base_uom_conv_rate,
 p.expected_date,
 p.days_late_receipt_allowed,
 p.days_early_receipt_allowed,
 p.base_uom,
 p.price_override,
 p.line_location_id,
 p.matching_basis,
 p.receiving_routing_id,
 nvl(com.commodity_id,-1),
 p.payment_type,
 p.shipment_type,
 p.complex_work_flag,
 p.func_cur_code