APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MSC_ITEM_SUPPLIERS

Line 1714: msc_item_suppliers mis

1710: t_supp(j)
1711: from msc_companies c,
1712: msc_trading_partner_maps m,
1713: msc_company_relationships r,
1714: msc_item_suppliers mis
1715: where m.tp_key = mis.supplier_id and
1716: m.map_type = 1 and
1717: r.relationship_id = m.company_key and
1718: r.subject_id = t_pub_id(j) and

Line 1752: msc_item_suppliers mis

1748: into t_supp_site_id(j),
1749: t_supp_site(j)
1750: from msc_company_sites s,
1751: msc_trading_partner_maps m,
1752: msc_item_suppliers mis
1753: where m.tp_key = mis.supplier_site_id and
1754: m.map_type = 3 and
1755: s.company_site_id = m.company_key and
1756: s.company_id = t_supp_id(j) and

Line 1798: msc_item_suppliers mis

1794: into t_supp_site_id(j),
1795: t_supp_site(j)
1796: from msc_company_sites s,
1797: msc_trading_partner_maps m,
1798: msc_item_suppliers mis
1799: where m.map_type = 3 and
1800: s.company_site_id = m.company_key and
1801: s.company_id = t_supp_id(j) and
1802: m.tp_key = mis.supplier_site_id and