APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_SYSTEM_ITEMS

Line 173: msc_system_items item,

169: dem.organization_id, --Partner Org Id
170: dem.sr_instance_id --Partner Instance Id
171: from
172: msc_demands dem,
173: msc_system_items item,
174: msc_company_sites cs,
175: msc_company_sites cs1,
176: msc_companies c,
177: msc_companies c1,

Line 190: /* msc_system_items msi pk:

186: msc_full_pegging mfp,
187: msc_supplies sup,
188: fnd_lookup_values flv
189: where
190: /* msc_system_items msi pk:
191: SR_INSTANCE_ID
192: PLAN_ID
193: ORGANIZATION_ID
194: INVENTORY_ITEM_ID

Line 275: from msc_system_items i1

271: dem.inventory_item_id = dem.using_assembly_item_id and
272: dem.origination_type in(6,7,8,9,11,29,30,42) and
273: NVL(item.base_item_id, item.inventory_item_id)
274: IN (select nvl(i1.base_item_id,i1.inventory_item_id)
275: from msc_system_items i1
276: where i1.inventory_item_id = nvl(p_item_id, i1.inventory_item_id )
277: and i1.organization_id = item.organization_id
278: and i1.plan_id = item.plan_id
279: and i1.sr_instance_id = item.sr_instance_id) and

Line 410: msc_system_items item,

406: fcst.organization_id, --Partner Org Id
407: fcst.sr_instance_id --Partner Instance Id
408: from
409: msc_constrained_forecast_v fcst,
410: msc_system_items item,
411: msc_company_sites cs,
412: msc_company_sites cs1,
413: msc_companies c,
414: msc_companies c1,

Line 425: /* msc_system_items msi pk:

421: msc_company_relationships r,
422: msc_plan_buckets mpb,
423: fnd_lookup_values flv
424: where
425: /* msc_system_items msi pk:
426: SR_INSTANCE_ID
427: PLAN_ID
428: ORGANIZATION_ID
429: INVENTORY_ITEM_ID

Line 508: from msc_system_items i1

504: fcst.customer_id = NVL(p_source_customer_id, fcst.customer_id) and
505: fcst.customer_site_id = NVL(p_source_customer_site_id, fcst.customer_site_id) and
506: NVL(item.base_item_id, item.inventory_item_id)
507: IN (select nvl(i1.base_item_id,i1.inventory_item_id)
508: from msc_system_items i1
509: where i1.inventory_item_id = nvl(p_item_id, i1.inventory_item_id )
510: and i1.organization_id = item.organization_id
511: and i1.plan_id = item.plan_id
512: and i1.sr_instance_id = item.sr_instance_id) and

Line 1144: from msc_system_items

1140: ---------------------------------------------------------------------------------*/
1141: begin
1142: select item_name, description
1143: into t_item_name(j), t_item_desc(j)
1144: from msc_system_items
1145: where sr_instance_id = t_src_instance_id(j)
1146: and organization_id = t_src_org_id(j)
1147: and plan_id = -1
1148: and inventory_item_id = t_item_id(j);

Line 1514: from msc_system_items i,

1510: cs.company_id = 1) and
1511: sd.customer_id = nvl(l_customer_id, sd.customer_id) and
1512: sd.customer_site_id = nvl(l_customer_site_id, sd.customer_site_id) and
1513: NVL(sd.base_item_id, sd.inventory_item_id) IN (select nvl(i.base_item_id,i.inventory_item_id)
1514: from msc_system_items i,
1515: msc_plan_organizations o
1516: where o.plan_id = p_plan_id and
1517: i.plan_id = o.plan_id and
1518: i.organization_id = nvl(p_org_id,

Line 1557: from msc_system_items i,

1553: cs.company_id = 1) and
1554: sd.customer_id = nvl(l_customer_id, sd.customer_id) and
1555: sd.customer_site_id = nvl(l_customer_site_id, sd.customer_site_id) and
1556: NVL(sd.base_item_id, sd.inventory_item_id) IN (select nvl(i.base_item_id,i.inventory_item_id)
1557: from msc_system_items i,
1558: msc_plan_organizations o
1559: where o.plan_id = p_plan_id and
1560: i.plan_id = o.plan_id and
1561: i.organization_id = nvl(p_org_id,