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:

Line 222: FROM MSC_TRADING_PARTNERS

218: SOURCE_LOCATIONS)
219: SELECT SR_INSTANCE_ID,
220: SR_TP_ID,
221: 1
222: FROM MSC_TRADING_PARTNERS
223: WHERE PARTNER_TYPE = 3;
224:
225: end if;
226:

Line 1112: msc_trading_partners t

1108: select distinct cs.company_site_id
1109: into l_supplier_site_id
1110: from msc_company_sites cs,
1111: msc_trading_partner_maps m,
1112: msc_trading_partners t
1113: where t.sr_tp_id = p_org_id and
1114: t.sr_instance_id = p_sr_instance_id and
1115: t.partner_type = 3 and
1116: m.tp_key = t.partner_id and