APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_ITEM_SUPPLIERS

Line 1482: from msc_item_suppliers mis,

1478: p_supp_site_id in number
1479: ) IS
1480: select distinct mis.processing_lead_time,
1481: mis.using_organization_id
1482: from msc_item_suppliers mis,
1483: msc_trading_partner_maps m,
1484: msc_trading_partner_maps m2,
1485: msc_company_relationships r
1486: where mis.plan_id = -1 and

Line 1649: from msc_item_suppliers mis,

1645: mis.uom_code
1646: into t_supp_item_name(j),
1647: t_supp_item_desc(j),
1648: t_tp_uom(j)
1649: from msc_item_suppliers mis,
1650: msc_trading_partner_maps m,
1651: msc_trading_partner_maps m2,
1652: msc_company_relationships r
1653: where mis.plan_id = -1 and