APPS.MSD_SCE_PUBLISH_FORECAST_PKG dependencies on MSC_TRADING_PARTNERS

Line 138: msc_trading_partners t,

134: msc_companies c,
135: msc_companies c1,
136: msc_trading_partner_maps m,
137: msc_trading_partner_maps m2,
138: msc_trading_partners t,
139: msc_tp_site_id_lid tsi1,
140: msc_trading_partner_sites ts1
141: -- msc_tp_id_lid ti1
142: where fcst.sr_instance_id = item.sr_instance_id and

Line 196: from msc_trading_partners

192: if p_org_code is not null then
193:
194: select sr_tp_id, sr_instance_id
195: into p_org_id, p_sr_instance_id
196: from msc_trading_partners
197: where organization_code = p_org_code and
198: partner_type = 3 and
199: company_id is null;
200: -- dbms_output.put_line('p_org_id := ' || p_org_id);

Line 1078: msc_trading_partners t

1074: select distinct cs.company_site_id
1075: into l_supplier_site_id
1076: from msc_company_sites cs,
1077: msc_trading_partner_maps m,
1078: msc_trading_partners t
1079: where t.sr_tp_id = p_org_id and
1080: t.sr_instance_id = p_sr_instance_id and
1081: t.partner_type = 3 and
1082: m.tp_key = t.partner_id and