APPS.MSD_SCE_PUBLISH_FORECAST_PKG dependencies on MSC_PLANNING_ORGS

Line 201: INSERT INTO MSC_PLANNING_ORGS(

197: where organization_code = p_org_code and
198: partner_type = 3 and
199: company_id is null;
200:
201: INSERT INTO MSC_PLANNING_ORGS(
202: SR_INSTANCE_ID,
203: ORGANIZATION_ID,
204: SOURCE_LOCATIONS)
205: VALUES (p_sr_instance_id,

Line 215: INSERT INTO MSC_PLANNING_ORGS(

211: else
212: p_org_id := null;
213: p_sr_instance_id := null;
214:
215: INSERT INTO MSC_PLANNING_ORGS(
216: SR_INSTANCE_ID,
217: ORGANIZATION_ID,
218: SOURCE_LOCATIONS)
219: SELECT SR_INSTANCE_ID,

Line 227: insert into msc_planning_orgs (

223: WHERE PARTNER_TYPE = 3;
224:
225: end if;
226:
227: insert into msc_planning_orgs (
228: ship_to_site_id,
229: source_locations)
230: select distinct site.tp_site_id,
231: 2