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:

Line 102: FROM MSC_TRADING_PARTNERS

98: SOURCE_LOCATIONS)
99: SELECT SR_INSTANCE_ID,
100: SR_TP_ID,
101: 1
102: FROM MSC_TRADING_PARTNERS
103: WHERE PARTNER_TYPE = 3;
104:
105: end if;
106:

Line 223: msc_trading_partners t1,

219: msd_level_values lv3,
220: msd_level_values lv4,
221: msd_level_values lv5, -- Bug 4710963
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

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;