APPS.MSD_SCE_RECEIVE_FORECAST_PKG dependencies on MSC_TRADING_PARTNER_SITES

Line 190: msc_trading_partner_sites ps,

186: msc_trading_partner_maps m2,
187: msc_trading_partners t1,
188: msc_item_id_lid item,
189: msc_tp_site_id_lid s,
190: msc_trading_partner_sites ps,
191: msd_item_list_price ilp
192: WHERE ilp.sr_item_pk(+) = lv4.sr_level_pk and
193: ilp.instance(+) = lv4.instance and
194: sd.inventory_item_id = item.inventory_item_id and

Line 297: from msc_trading_partners tp, msc_trading_partner_sites tps

293:
294:
295: cursor c_sr_ship_to_loc_pk is
296: select sr_tp_site_id
297: from msc_trading_partners tp, msc_trading_partner_sites tps
298: where tp.partner_id = p_customer_id
299: and tps.partner_site_id = p_customer_site_id
300: and tps.partner_id = tp.partner_id
301: and tps.partner_type = 2;

Line 396: msc_trading_partner_sites site,

392: select slid.sr_tp_site_id
393: from
394: msc_tp_site_id_lid slid,
395: msc_trading_partner_maps map,
396: msc_trading_partner_sites site,
397: msd_level_values lvl
398: where
399: map.company_key = p_customer_site_id and
400: map.map_type = 3 and