APPS.MSD_SCE_RECEIVE_FORECAST_PKG dependencies on MSC_TRADING_PARTNER_SITES

Line 114: msc_trading_partner_sites site,

110: select distinct map.tp_key,
111: 2
112: from
113: msc_trading_partner_maps map,
114: msc_trading_partner_sites site,
115: msc_sup_dem_entries sd
116: where
117: map.company_key = sd.customer_site_id and
118: map.map_type = 3 and

Line 226: msc_trading_partner_sites ps,

222: msc_trading_partner_maps m2,
223: msc_trading_partners t1,
224: msc_item_id_lid item,
225: msc_tp_site_id_lid s,
226: msc_trading_partner_sites ps,
227: msd_item_list_price ilp
228: WHERE ilp.sr_item_pk(+) = lv4.sr_level_pk and
229: ilp.instance(+) = lv4.instance and
230: sd.inventory_item_id = item.inventory_item_id and

Line 334: from msc_trading_partners tp, msc_trading_partner_sites tps

330:
331:
332: cursor c_sr_ship_to_loc_pk is
333: select sr_tp_site_id
334: from msc_trading_partners tp, msc_trading_partner_sites tps
335: where tp.partner_id = p_customer_id
336: and tps.partner_site_id = p_customer_site_id
337: and tps.partner_id = tp.partner_id
338: and tps.partner_type = 2;

Line 433: msc_trading_partner_sites site,

429: select slid.sr_tp_site_id
430: from
431: msc_tp_site_id_lid slid,
432: msc_trading_partner_maps map,
433: msc_trading_partner_sites site,
434: msd_level_values lvl
435: where
436: map.company_key = p_customer_site_id and
437: map.map_type = 3 and