[Home] [Help]
160: dem.organization_id, --Partner Org Id
161: dem.sr_instance_id --Partner Instance Id
162: from
163: msc_demands dem,
164: msc_system_items item,
165: msc_company_sites cs,
166: msc_company_sites cs1,
167: msc_companies c,
168: msc_companies c1,
177: msc_full_pegging mfp,
178: msc_supplies sup,
179: fnd_lookup_values flv
180: where
181: /* msc_system_items msi pk:
182: SR_INSTANCE_ID
183: PLAN_ID
184: ORGANIZATION_ID
185: INVENTORY_ITEM_ID
262: dem.inventory_item_id = dem.using_assembly_item_id and
263: dem.origination_type in(6,7,8,9,11,29,30,42) and
264: NVL(item.base_item_id, item.inventory_item_id)
265: IN (select nvl(i1.base_item_id,i1.inventory_item_id)
266: from msc_system_items i1
267: where i1.inventory_item_id = nvl(p_item_id, i1.inventory_item_id )
268: and i1.organization_id = item.organization_id
269: and i1.plan_id = item.plan_id
270: and i1.sr_instance_id = item.sr_instance_id) and
397: fcst.organization_id, --Partner Org Id
398: fcst.sr_instance_id --Partner Instance Id
399: from
400: msc_constrained_forecast_v fcst,
401: msc_system_items item,
402: msc_company_sites cs,
403: msc_company_sites cs1,
404: msc_companies c,
405: msc_companies c1,
412: msc_company_relationships r,
413: msc_plan_buckets mpb,
414: fnd_lookup_values flv
415: where
416: /* msc_system_items msi pk:
417: SR_INSTANCE_ID
418: PLAN_ID
419: ORGANIZATION_ID
420: INVENTORY_ITEM_ID
495: fcst.customer_id = NVL(p_source_customer_id, fcst.customer_id) and
496: fcst.customer_site_id = NVL(p_source_customer_site_id, fcst.customer_site_id) and
497: NVL(item.base_item_id, item.inventory_item_id)
498: IN (select nvl(i1.base_item_id,i1.inventory_item_id)
499: from msc_system_items i1
500: where i1.inventory_item_id = nvl(p_item_id, i1.inventory_item_id )
501: and i1.organization_id = item.organization_id
502: and i1.plan_id = item.plan_id
503: and i1.sr_instance_id = item.sr_instance_id) and
1106: ---------------------------------------------------------------------------------*/
1107: begin
1108: select item_name, description
1109: into t_item_name(j), t_item_desc(j)
1110: from msc_system_items
1111: where sr_instance_id = t_src_instance_id(j)
1112: and organization_id = t_src_org_id(j)
1113: and plan_id = -1
1114: and inventory_item_id = t_item_id(j);
1474: cs.company_id = 1) and
1475: sd.customer_id = nvl(l_customer_id, sd.customer_id) and
1476: sd.customer_site_id = nvl(l_customer_site_id, sd.customer_site_id) and
1477: NVL(sd.base_item_id, sd.inventory_item_id) IN (select nvl(i.base_item_id,i.inventory_item_id)
1478: from msc_system_items i,
1479: msc_plan_organizations o
1480: where o.plan_id = p_plan_id and
1481: i.plan_id = o.plan_id and
1482: i.organization_id = nvl(p_org_id,
1517: cs.company_id = 1) and
1518: sd.customer_id = nvl(l_customer_id, sd.customer_id) and
1519: sd.customer_site_id = nvl(l_customer_site_id, sd.customer_site_id) and
1520: NVL(sd.base_item_id, sd.inventory_item_id) IN (select nvl(i.base_item_id,i.inventory_item_id)
1521: from msc_system_items i,
1522: msc_plan_organizations o
1523: where o.plan_id = p_plan_id and
1524: i.plan_id = o.plan_id and
1525: i.organization_id = nvl(p_org_id,