APPS.MSD_SCE_RECEIVE_FORECAST_PKG dependencies on MSC_TRADING_PARTNERS

Line 76: from msc_trading_partners

72: if p_org_code is not null then
73:
74: select sr_tp_id, sr_instance_id
75: into p_org_id, p_sr_instance_id
76: from msc_trading_partners
77: where organization_code = p_org_code and
78: partner_type = 3 and
79: company_id is null;
80: --dbms_output.put_line('p_org_id := ' || p_org_id);

Line 187: msc_trading_partners t1,

183: msd_level_values lv3,
184: msd_level_values lv4,
185: msd_level_values lv5, -- Bug 4710963
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

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;