DBA Data[Home] [Help]

APPS.MSC_SUPPLY_PKG dependencies on MSC_PHUB_SUPPLIERS_MV

Line 570: msc_phub_suppliers_mv mps

566: ms2.order_type,
567: msi2.vmi_flag
568: order by 1,2,3,4,5,6,7,8,9,10) supply_tbl,
569: msc_plans mp,
570: msc_phub_suppliers_mv mps
571: where mp.plan_id=p_plan_id --- we need this to separate io measure from other measures
572: and mps.supplier_id = nvl(supply_tbl.supplier_id, -23453)
573: and mps.supplier_site_id = nvl(supply_tbl.supplier_site_id, -23453)
574: and mps.region_id = decode(nvl(supply_tbl.supplier_id, -23453),