APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MSC_ITEM_SUPPLIERS

Line 1698: msc_item_suppliers mis

1694: t_supp(j)
1695: from msc_companies c,
1696: msc_trading_partner_maps m,
1697: msc_company_relationships r,
1698: msc_item_suppliers mis
1699: where m.tp_key = mis.supplier_id and
1700: m.map_type = 1 and
1701: r.relationship_id = m.company_key and
1702: r.subject_id = t_pub_id(j) and

Line 1736: msc_item_suppliers mis

1732: into t_supp_site_id(j),
1733: t_supp_site(j)
1734: from msc_company_sites s,
1735: msc_trading_partner_maps m,
1736: msc_item_suppliers mis
1737: where m.tp_key = mis.supplier_site_id and
1738: m.map_type = 3 and
1739: s.company_site_id = m.company_key and
1740: s.company_id = t_supp_id(j) and

Line 1782: msc_item_suppliers mis

1778: into t_supp_site_id(j),
1779: t_supp_site(j)
1780: from msc_company_sites s,
1781: msc_trading_partner_maps m,
1782: msc_item_suppliers mis
1783: where m.map_type = 3 and
1784: s.company_site_id = m.company_key and
1785: s.company_id = t_supp_id(j) and
1786: m.tp_key = mis.supplier_site_id and