DBA Data[Home] [Help]

APPS.MSD_SALES_OPERATION_PLAN dependencies on MSC_SYSTEM_ITEMS

Line 68: msc_system_items ass_msi,

64: INTO l_numerator
65: --,l_denominator
66: from
67: msc_plan_organizations ass_mpo,
68: msc_system_items ass_msi,
69: msc_demands md,
70: msc_supplies ass_ms,
71: msc_full_pegging ass_mfp,
72: msc_full_pegging cmp_mfp,

Line 74: msc_system_items cmp_msi,

70: msc_supplies ass_ms,
71: msc_full_pegging ass_mfp,
72: msc_full_pegging cmp_mfp,
73: msc_supplies cmp_ms,
74: msc_system_items cmp_msi,
75: msc_plan_organizations cmp_mpo
76: where cmp_mpo.plan_id = p_supply_plan_id
77: /* mpo_plan_organizations - assembly and msc_system_items - assembly */
78: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id

Line 77: /* mpo_plan_organizations - assembly and msc_system_items - assembly */

73: msc_supplies cmp_ms,
74: msc_system_items cmp_msi,
75: msc_plan_organizations cmp_mpo
76: where cmp_mpo.plan_id = p_supply_plan_id
77: /* mpo_plan_organizations - assembly and msc_system_items - assembly */
78: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
79: and ass_msi.plan_id = ass_mpo.plan_id
80: and ass_msi.organization_id = ass_mpo.organization_id
81: /* msc_system_items - assembly and msc_supplies - assembly */

Line 81: /* msc_system_items - assembly and msc_supplies - assembly */

77: /* mpo_plan_organizations - assembly and msc_system_items - assembly */
78: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
79: and ass_msi.plan_id = ass_mpo.plan_id
80: and ass_msi.organization_id = ass_mpo.organization_id
81: /* msc_system_items - assembly and msc_supplies - assembly */
82: and ass_ms.inventory_item_id = ass_msi.inventory_item_id
83: and ass_ms.plan_id = ass_msi.plan_id
84: and ass_ms.sr_instance_id = ass_msi.sr_instance_id
85: and ass_ms.organization_id = ass_msi.organization_id

Line 108: /* msc_supplies - components and msc_system_items - components */

104: and cmp_mfp.transaction_id = cmp_ms.transaction_id
105: and cmp_mfp.organization_id = cmp_ms.organization_id
106: and cmp_mfp.sr_instance_id = cmp_ms.sr_instance_id
107: and cmp_mfp.plan_id = cmp_ms.plan_id
108: /* msc_supplies - components and msc_system_items - components */
109: and cmp_ms.inventory_item_id = cmp_msi.inventory_item_id
110: and cmp_ms.plan_id = cmp_msi.plan_id
111: and cmp_ms.sr_instance_id = cmp_msi.sr_instance_id
112: and cmp_ms.organization_id = cmp_msi.organization_id

Line 113: /* msc_system_items - components and mpo_plan_organizations - components */

109: and cmp_ms.inventory_item_id = cmp_msi.inventory_item_id
110: and cmp_ms.plan_id = cmp_msi.plan_id
111: and cmp_ms.sr_instance_id = cmp_msi.sr_instance_id
112: and cmp_ms.organization_id = cmp_msi.organization_id
113: /* msc_system_items - components and mpo_plan_organizations - components */
114: and cmp_msi.organization_id = cmp_mpo.organization_id
115: and cmp_msi.sr_instance_id = cmp_mpo.sr_instance_id
116: and cmp_msi.plan_id = cmp_mpo.plan_id
117: /* For given PLAN,INSTANCE,ASSEMBLY,COMPONENT,EFF and DISABLE DATE */

Line 134: msc_system_items ass_msi,

130: select /*+ ORDERED */ sum(ass_mfp.allocated_quantity)
131: INTO l_denominator
132: from msc_plan_organizations mpo,
133: msc_demands ass_md,
134: msc_system_items ass_msi,
135: msc_full_pegging ass_mfp,
136: msc_supplies ass_ms
137: where ass_msi.plan_id = mpo.plan_id
138: and ass_msi.sr_instance_id = mpo.sr_instance_id

Line 140: /* msc_system_items - assembly and msd_demands - assembly */

136: msc_supplies ass_ms
137: where ass_msi.plan_id = mpo.plan_id
138: and ass_msi.sr_instance_id = mpo.sr_instance_id
139: and ass_msi.organization_id = mpo.organization_id
140: /* msc_system_items - assembly and msd_demands - assembly */
141: and ass_msi.plan_id = ass_md.plan_id
142: and ass_msi.sr_instance_id = ass_md.sr_instance_id
143: and ass_msi.organization_id = ass_md.organization_id
144: and ass_msi.inventory_item_id = ass_md.inventory_item_id

Line 194: msc_system_items ass_msi,

190: -- ,l_denominator
191:
192: from
193: msc_plan_organizations ass_mpo,
194: msc_system_items ass_msi,
195: msc_supplies ass_ms,
196: msc_full_pegging ass_mfp,
197: msc_full_pegging cmp_mfp,
198: msc_supplies cmp_ms,

Line 199: msc_system_items cmp_msi,

195: msc_supplies ass_ms,
196: msc_full_pegging ass_mfp,
197: msc_full_pegging cmp_mfp,
198: msc_supplies cmp_ms,
199: msc_system_items cmp_msi,
200: msc_plan_organizations cmp_mpo
201: where cmp_mpo.plan_id = p_supply_plan_id
202: /* mpo_plan_organizations - assembly and msc_system_items - assembly */
203: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id

Line 202: /* mpo_plan_organizations - assembly and msc_system_items - assembly */

198: msc_supplies cmp_ms,
199: msc_system_items cmp_msi,
200: msc_plan_organizations cmp_mpo
201: where cmp_mpo.plan_id = p_supply_plan_id
202: /* mpo_plan_organizations - assembly and msc_system_items - assembly */
203: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
204: and ass_msi.plan_id = ass_mpo.plan_id
205: and ass_msi.organization_id = ass_mpo.organization_id
206: /* msc_system_items - assembly and msc_supplies - assembly */

Line 206: /* msc_system_items - assembly and msc_supplies - assembly */

202: /* mpo_plan_organizations - assembly and msc_system_items - assembly */
203: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
204: and ass_msi.plan_id = ass_mpo.plan_id
205: and ass_msi.organization_id = ass_mpo.organization_id
206: /* msc_system_items - assembly and msc_supplies - assembly */
207: and ass_ms.inventory_item_id = ass_msi.inventory_item_id
208: and ass_ms.plan_id = ass_msi.plan_id
209: and ass_ms.sr_instance_id = ass_msi.sr_instance_id
210: and ass_ms.organization_id = ass_msi.organization_id

Line 228: /* msc_supplies - components and msc_system_items - components */

224: and cmp_mfp.transaction_id = cmp_ms.transaction_id
225: and cmp_mfp.organization_id = cmp_ms.organization_id
226: and cmp_mfp.sr_instance_id = cmp_ms.sr_instance_id
227: and cmp_mfp.plan_id = cmp_ms.plan_id
228: /* msc_supplies - components and msc_system_items - components */
229: and cmp_ms.inventory_item_id = cmp_msi.inventory_item_id
230: and cmp_ms.plan_id = cmp_msi.plan_id
231: and cmp_ms.sr_instance_id = cmp_msi.sr_instance_id
232: and cmp_ms.organization_id = cmp_msi.organization_id

Line 233: /* msc_system_items - components and mpo_plan_organizations - components */

229: and cmp_ms.inventory_item_id = cmp_msi.inventory_item_id
230: and cmp_ms.plan_id = cmp_msi.plan_id
231: and cmp_ms.sr_instance_id = cmp_msi.sr_instance_id
232: and cmp_ms.organization_id = cmp_msi.organization_id
233: /* msc_system_items - components and mpo_plan_organizations - components */
234: and cmp_msi.organization_id = cmp_mpo.organization_id
235: and cmp_msi.sr_instance_id = cmp_mpo.sr_instance_id
236: and cmp_msi.plan_id = cmp_mpo.plan_id
237: /* For given PLAN,INSTANCE,ASSEMBLY,COMPONENT,EFF and DISABLE DATE */

Line 254: msc_system_items ass_msi,

250: select /*+ ORDERED */ sum(cmp_mfp.allocated_quantity)
251: INTO l_denominator
252: from
253: msc_plan_organizations ass_mpo,
254: msc_system_items ass_msi,
255: msc_supplies ass_ms,
256: msc_full_pegging ass_mfp,
257: msc_full_pegging cmp_mfp,
258: msc_supplies cmp_ms,

Line 259: msc_system_items cmp_msi,

255: msc_supplies ass_ms,
256: msc_full_pegging ass_mfp,
257: msc_full_pegging cmp_mfp,
258: msc_supplies cmp_ms,
259: msc_system_items cmp_msi,
260: msc_plan_organizations cmp_mpo
261: where cmp_mpo.plan_id = p_supply_plan_id
262: /* mpo_plan_organizations - assembly and msc_system_items - assembly */
263: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id

Line 262: /* mpo_plan_organizations - assembly and msc_system_items - assembly */

258: msc_supplies cmp_ms,
259: msc_system_items cmp_msi,
260: msc_plan_organizations cmp_mpo
261: where cmp_mpo.plan_id = p_supply_plan_id
262: /* mpo_plan_organizations - assembly and msc_system_items - assembly */
263: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
264: and ass_msi.plan_id = ass_mpo.plan_id
265: and ass_msi.organization_id = ass_mpo.organization_id
266: /* msc_system_items - assembly and msc_supplies - assembly */

Line 266: /* msc_system_items - assembly and msc_supplies - assembly */

262: /* mpo_plan_organizations - assembly and msc_system_items - assembly */
263: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
264: and ass_msi.plan_id = ass_mpo.plan_id
265: and ass_msi.organization_id = ass_mpo.organization_id
266: /* msc_system_items - assembly and msc_supplies - assembly */
267: and ass_ms.inventory_item_id = ass_msi.inventory_item_id
268: and ass_ms.plan_id = ass_msi.plan_id
269: and ass_ms.sr_instance_id = ass_msi.sr_instance_id
270: and ass_ms.organization_id = ass_msi.organization_id

Line 287: /* msc_supplies - components and msc_system_items - components */

283: and cmp_mfp.transaction_id = cmp_ms.transaction_id
284: and cmp_mfp.organization_id = cmp_ms.organization_id
285: and cmp_mfp.sr_instance_id = cmp_ms.sr_instance_id
286: and cmp_mfp.plan_id = cmp_ms.plan_id
287: /* msc_supplies - components and msc_system_items - components */
288: and cmp_ms.inventory_item_id = cmp_msi.inventory_item_id
289: and cmp_ms.plan_id = cmp_msi.plan_id
290: and cmp_ms.sr_instance_id = cmp_msi.sr_instance_id
291: and cmp_ms.organization_id = cmp_msi.organization_id

Line 292: /* msc_system_items - components and mpo_plan_organizations - components */

288: and cmp_ms.inventory_item_id = cmp_msi.inventory_item_id
289: and cmp_ms.plan_id = cmp_msi.plan_id
290: and cmp_ms.sr_instance_id = cmp_msi.sr_instance_id
291: and cmp_ms.organization_id = cmp_msi.organization_id
292: /* msc_system_items - components and mpo_plan_organizations - components */
293: and cmp_msi.organization_id = cmp_mpo.organization_id
294: and cmp_msi.sr_instance_id = cmp_mpo.sr_instance_id
295: and cmp_msi.plan_id = cmp_mpo.plan_id
296: /* For given PLAN,INSTANCE,ASSEMBLY,COMPONENT,EFF and DISABLE DATE */

Line 344: msc_system_items msi,

340: INTO l_numerator
341: --,l_denominator
342: from
343: msc_plan_organizations mpo1,
344: msc_system_items msi,
345: msc_demands md,
346: msc_full_pegging mfp1,
347: msc_full_pegging mfp2,
348: msc_supplies ms2,

Line 358: /* msc_system_items and msc_demands */

354: and msi.sr_inventory_item_id = p_assembly_pk
355: and msi.plan_id = mpo1.plan_id
356: and msi.organization_id = mpo1.organization_id
357: and msi.sr_instance_id = mpo1.sr_instance_id
358: /* msc_system_items and msc_demands */
359: and msi.inventory_item_id = md.inventory_item_id
360: and msi.plan_id = md.plan_id
361: and msi.organization_id = md.organization_id
362: and msi.sr_instance_id = md.sr_instance_id

Line 405: msc_system_items ass_msi,

401: select /*+ ORDERED */ sum(ass_mfp.allocated_quantity)
402: INTO l_denominator
403: from msc_plan_organizations mpo,
404: msc_demands ass_md,
405: msc_system_items ass_msi,
406: msc_full_pegging ass_mfp,
407: msc_supplies ass_ms
408: where ass_msi.plan_id = mpo.plan_id
409: and ass_msi.sr_instance_id = mpo.sr_instance_id

Line 411: /* msc_system_items - assembly and msd_demands - assembly */

407: msc_supplies ass_ms
408: where ass_msi.plan_id = mpo.plan_id
409: and ass_msi.sr_instance_id = mpo.sr_instance_id
410: and ass_msi.organization_id = mpo.organization_id
411: /* msc_system_items - assembly and msd_demands - assembly */
412: and ass_msi.plan_id = ass_md.plan_id
413: and ass_msi.sr_instance_id = ass_md.sr_instance_id
414: and ass_msi.organization_id = ass_md.organization_id
415: and ass_msi.inventory_item_id = ass_md.inventory_item_id

Line 461: msc_system_items msi,

457: INTO l_numerator
458: --l_denominator,
459: from
460: msc_plan_organizations mpo1,
461: msc_system_items msi,
462: msc_supplies ms,
463: msc_full_pegging mfp1,
464: msc_full_pegging mfp2,
465: msc_resource_requirements mrr,

Line 474: /* msc_system_items - assembly and msc_supplies - assembly */

470: and msi.sr_inventory_item_id = p_assembly_pk
471: and msi.plan_id = mpo1.plan_id
472: and msi.organization_id = mpo1.organization_id
473: and msi.sr_instance_id = mpo1.sr_instance_id
474: /* msc_system_items - assembly and msc_supplies - assembly */
475: and msi.inventory_item_id = ms.inventory_item_id
476: and msi.plan_id = ms.plan_id
477: and msi.organization_id = ms.organization_id
478: and msi.sr_instance_id = ms.sr_instance_id

Line 515: msc_system_items ass_msi,

511: select /*+ ORDERED */ sum(ass_mfp.allocated_quantity)
512: INTO l_denominator
513: from msc_plan_organizations mpo,
514: msc_demands ass_md,
515: msc_system_items ass_msi,
516: msc_full_pegging ass_mfp,
517: msc_supplies ass_ms
518: where ass_msi.plan_id = mpo.plan_id
519: and ass_msi.sr_instance_id = mpo.sr_instance_id

Line 521: /* msc_system_items and msd_demands */

517: msc_supplies ass_ms
518: where ass_msi.plan_id = mpo.plan_id
519: and ass_msi.sr_instance_id = mpo.sr_instance_id
520: and ass_msi.organization_id = mpo.organization_id
521: /* msc_system_items and msd_demands */
522: and ass_msi.plan_id = ass_md.plan_id
523: and ass_msi.sr_instance_id = ass_md.sr_instance_id
524: and ass_msi.organization_id = ass_md.organization_id
525: and ass_msi.inventory_item_id = ass_md.inventory_item_id

Line 609: msc_system_items ass_msi,

605: select sum(cmp_mfp.allocated_quantity)
606: INTO l_numerator
607: from
608: msc_plan_organizations ass_mpo,
609: msc_system_items ass_msi,
610: msc_demands ass_md,
611: msc_full_pegging ass_mfp,
612: msc_full_pegging cmp_mfp,
613: msc_demands cmp_md,

Line 614: msc_system_items cmp_msi,

610: msc_demands ass_md,
611: msc_full_pegging ass_mfp,
612: msc_full_pegging cmp_mfp,
613: msc_demands cmp_md,
614: msc_system_items cmp_msi,
615: msc_plan_organizations cmp_mpo
616: where ass_mpo.plan_id = p_supply_plan_id
617: /* mpo_plan_organizations - components and msc_system_items - assembly */
618: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id

Line 617: /* mpo_plan_organizations - components and msc_system_items - assembly */

613: msc_demands cmp_md,
614: msc_system_items cmp_msi,
615: msc_plan_organizations cmp_mpo
616: where ass_mpo.plan_id = p_supply_plan_id
617: /* mpo_plan_organizations - components and msc_system_items - assembly */
618: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
619: and ass_msi.plan_id = ass_mpo.plan_id
620: and ass_msi.organization_id = ass_mpo.organization_id
621: /* msc_system_items - assembly and msc_demands - assembly */

Line 621: /* msc_system_items - assembly and msc_demands - assembly */

617: /* mpo_plan_organizations - components and msc_system_items - assembly */
618: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
619: and ass_msi.plan_id = ass_mpo.plan_id
620: and ass_msi.organization_id = ass_mpo.organization_id
621: /* msc_system_items - assembly and msc_demands - assembly */
622: and ass_md.inventory_item_id = ass_msi.inventory_item_id
623: and ass_md.plan_id = ass_msi.plan_id
624: and ass_md.sr_instance_id = ass_msi.sr_instance_id
625: and ass_md.organization_id = ass_msi.organization_id

Line 643: /* msc_demands - components and msc_system_items - components */

639: and cmp_mfp.demand_id = cmp_md.demand_id
640: and cmp_mfp.organization_id = cmp_md.organization_id
641: and cmp_mfp.sr_instance_id = cmp_md.sr_instance_id
642: and cmp_mfp.plan_id = cmp_md.plan_id
643: /* msc_demands - components and msc_system_items - components */
644: and cmp_md.inventory_item_id = cmp_msi.inventory_item_id
645: and cmp_md.plan_id = cmp_msi.plan_id
646: and cmp_md.sr_instance_id = cmp_msi.sr_instance_id
647: and cmp_md.organization_id = cmp_msi.organization_id

Line 648: /* msc_system_items - components and mpo_plan_organizations - components */

644: and cmp_md.inventory_item_id = cmp_msi.inventory_item_id
645: and cmp_md.plan_id = cmp_msi.plan_id
646: and cmp_md.sr_instance_id = cmp_msi.sr_instance_id
647: and cmp_md.organization_id = cmp_msi.organization_id
648: /* msc_system_items - components and mpo_plan_organizations - components */
649: and cmp_msi.organization_id = cmp_mpo.organization_id
650: and cmp_msi.sr_instance_id = cmp_mpo.sr_instance_id
651: and cmp_msi.plan_id = cmp_mpo.plan_id
652: /* For given PLAN,INSTANCE,ASSEMBLY and COMPONENT*/

Line 664: msc_system_items cmp_msi,

660: select sum(cmp_md.USING_REQUIREMENT_QUANTITY)
661: INTO l_denominator
662: from
663: msc_plan_organizations cmp_mpo,
664: msc_system_items cmp_msi,
665: msc_demands cmp_md
666: where cmp_mpo.plan_id = p_supply_plan_id
667: /* msc_system_items - comp and msc_plan_organizations - comp */
668: and cmp_msi.sr_instance_id = cmp_mpo.sr_instance_id

Line 667: /* msc_system_items - comp and msc_plan_organizations - comp */

663: msc_plan_organizations cmp_mpo,
664: msc_system_items cmp_msi,
665: msc_demands cmp_md
666: where cmp_mpo.plan_id = p_supply_plan_id
667: /* msc_system_items - comp and msc_plan_organizations - comp */
668: and cmp_msi.sr_instance_id = cmp_mpo.sr_instance_id
669: and cmp_msi.plan_id = cmp_mpo.plan_id
670: and cmp_msi.organization_id = cmp_mpo.organization_id
671: /* msc_demands - comp and msc_system_items - comp */

Line 671: /* msc_demands - comp and msc_system_items - comp */

667: /* msc_system_items - comp and msc_plan_organizations - comp */
668: and cmp_msi.sr_instance_id = cmp_mpo.sr_instance_id
669: and cmp_msi.plan_id = cmp_mpo.plan_id
670: and cmp_msi.organization_id = cmp_mpo.organization_id
671: /* msc_demands - comp and msc_system_items - comp */
672: and cmp_md.inventory_item_id = cmp_msi.inventory_item_id
673: and cmp_md.plan_id = cmp_msi.plan_id
674: and cmp_md.sr_instance_id = cmp_msi.sr_instance_id
675: and cmp_md.organization_id = cmp_msi.organization_id

Line 749: msc_system_items ass_msi,

745: select sum(cmp_mfp.allocated_quantity)
746: INTO l_numerator
747: from
748: msc_plan_organizations ass_mpo,
749: msc_system_items ass_msi,
750: msc_demands ass_md,
751: msc_full_pegging ass_mfp,
752: msc_full_pegging cmp_mfp,
753: msc_demands cmp_md,

Line 755: msc_system_items cmp_msi,

751: msc_full_pegging ass_mfp,
752: msc_full_pegging cmp_mfp,
753: msc_demands cmp_md,
754: --msc_supplies cmp_ms BUG 5210812,
755: msc_system_items cmp_msi,
756: msc_plan_organizations cmp_mpo
757: where ass_mpo.plan_id = p_supply_plan_id
758: /* mpo_plan_organizations - components and msc_system_items - assembly */
759: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id

Line 758: /* mpo_plan_organizations - components and msc_system_items - assembly */

754: --msc_supplies cmp_ms BUG 5210812,
755: msc_system_items cmp_msi,
756: msc_plan_organizations cmp_mpo
757: where ass_mpo.plan_id = p_supply_plan_id
758: /* mpo_plan_organizations - components and msc_system_items - assembly */
759: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
760: and ass_msi.plan_id = ass_mpo.plan_id
761: and ass_msi.organization_id = ass_mpo.organization_id
762: /* msc_system_items - assembly and msc_demands - assembly */

Line 762: /* msc_system_items - assembly and msc_demands - assembly */

758: /* mpo_plan_organizations - components and msc_system_items - assembly */
759: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
760: and ass_msi.plan_id = ass_mpo.plan_id
761: and ass_msi.organization_id = ass_mpo.organization_id
762: /* msc_system_items - assembly and msc_demands - assembly */
763: and ass_md.inventory_item_id = ass_msi.inventory_item_id
764: and ass_md.plan_id = ass_msi.plan_id
765: and ass_md.sr_instance_id = ass_msi.sr_instance_id
766: and ass_md.organization_id = ass_msi.organization_id

Line 792: /* msc_demands - components and msc_system_items - components */

788: and cmp_ms.sr_instance_id = cmp_mfp.sr_instance_id
789: and cmp_ms.organization_id = cmp_mfp.organization_id
790: and cmp_ms.order_type not in ( 18 ) -- Exclude On Hand Supplies
791: Commented above code for the BUG 5210812*/
792: /* msc_demands - components and msc_system_items - components */
793: and cmp_md.inventory_item_id = cmp_msi.inventory_item_id
794: and cmp_md.plan_id = cmp_msi.plan_id
795: and cmp_md.sr_instance_id = cmp_msi.sr_instance_id
796: and cmp_md.organization_id = cmp_msi.organization_id

Line 797: /* msc_system_items - components and mpo_plan_organizations - components */

793: and cmp_md.inventory_item_id = cmp_msi.inventory_item_id
794: and cmp_md.plan_id = cmp_msi.plan_id
795: and cmp_md.sr_instance_id = cmp_msi.sr_instance_id
796: and cmp_md.organization_id = cmp_msi.organization_id
797: /* msc_system_items - components and mpo_plan_organizations - components */
798: and cmp_msi.organization_id = cmp_mpo.organization_id
799: and cmp_msi.sr_instance_id = cmp_mpo.sr_instance_id
800: and cmp_msi.plan_id = cmp_mpo.plan_id
801: /* For given PLAN,INSTANCE,ASSEMBLY and COMPONENT*/

Line 814: msc_system_items ass_msi,

810: select sum(ass_md.USING_REQUIREMENT_QUANTITY)
811: INTO l_denominator
812: from
813: msc_plan_organizations ass_mpo,
814: msc_system_items ass_msi,
815: msc_demands ass_md
816: where ass_mpo.plan_id = p_supply_plan_id
817: /* msc_system_items - asmb and msc_plan_organizations - asmb */
818: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id

Line 817: /* msc_system_items - asmb and msc_plan_organizations - asmb */

813: msc_plan_organizations ass_mpo,
814: msc_system_items ass_msi,
815: msc_demands ass_md
816: where ass_mpo.plan_id = p_supply_plan_id
817: /* msc_system_items - asmb and msc_plan_organizations - asmb */
818: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
819: and ass_msi.plan_id = ass_mpo.plan_id
820: and ass_msi.organization_id = ass_mpo.organization_id
821: /* msc_demands - asmb and msc_system_items - asmb */

Line 821: /* msc_demands - asmb and msc_system_items - asmb */

817: /* msc_system_items - asmb and msc_plan_organizations - asmb */
818: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
819: and ass_msi.plan_id = ass_mpo.plan_id
820: and ass_msi.organization_id = ass_mpo.organization_id
821: /* msc_demands - asmb and msc_system_items - asmb */
822: and ass_md.inventory_item_id = ass_msi.inventory_item_id
823: and ass_md.plan_id = ass_msi.plan_id
824: and ass_md.sr_instance_id = ass_msi.sr_instance_id
825: and ass_md.organization_id = ass_msi.organization_id

Line 874: msc_system_items ass_msi,

870: select sum(cmp_mfp.allocated_quantity*(ass_md.USING_ASSEMBLY_DEMAND_DATE - cmp_md.USING_ASSEMBLY_DEMAND_DATE))
871: INTO l_denominator
872: from
873: msc_plan_organizations ass_mpo,
874: msc_system_items ass_msi,
875: msc_demands ass_md,
876: msc_full_pegging ass_mfp,
877: msc_full_pegging cmp_mfp,
878: msc_demands cmp_md,

Line 879: msc_system_items cmp_msi,

875: msc_demands ass_md,
876: msc_full_pegging ass_mfp,
877: msc_full_pegging cmp_mfp,
878: msc_demands cmp_md,
879: msc_system_items cmp_msi,
880: msc_plan_organizations cmp_mpo
881: where ass_mpo.plan_id = p_supply_plan_id
882: /* mpo_plan_organizations - components and msc_system_items - assembly */
883: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id

Line 882: /* mpo_plan_organizations - components and msc_system_items - assembly */

878: msc_demands cmp_md,
879: msc_system_items cmp_msi,
880: msc_plan_organizations cmp_mpo
881: where ass_mpo.plan_id = p_supply_plan_id
882: /* mpo_plan_organizations - components and msc_system_items - assembly */
883: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
884: and ass_msi.plan_id = ass_mpo.plan_id
885: and ass_msi.organization_id = ass_mpo.organization_id
886: /* msc_system_items - assembly and msc_demands - assembly */

Line 886: /* msc_system_items - assembly and msc_demands - assembly */

882: /* mpo_plan_organizations - components and msc_system_items - assembly */
883: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
884: and ass_msi.plan_id = ass_mpo.plan_id
885: and ass_msi.organization_id = ass_mpo.organization_id
886: /* msc_system_items - assembly and msc_demands - assembly */
887: and ass_md.inventory_item_id = ass_msi.inventory_item_id
888: and ass_md.plan_id = ass_msi.plan_id
889: and ass_md.sr_instance_id = ass_msi.sr_instance_id
890: and ass_md.organization_id = ass_msi.organization_id

Line 909: /* msc_demands - components and msc_system_items - components */

905: and cmp_mfp.organization_id = cmp_md.organization_id
906: and cmp_mfp.sr_instance_id = cmp_md.sr_instance_id
907: and cmp_mfp.plan_id = cmp_md.plan_id
908: and cmp_md.origination_type in (29,30,8,6,24,3,1,54) -- Gross Requirements of Components across All Organizations.
909: /* msc_demands - components and msc_system_items - components */
910: and cmp_md.inventory_item_id = cmp_msi.inventory_item_id
911: and cmp_md.plan_id = cmp_msi.plan_id
912: and cmp_md.sr_instance_id = cmp_msi.sr_instance_id
913: and cmp_md.organization_id = cmp_msi.organization_id

Line 914: /* msc_system_items - components and mpo_plan_organizations - components */

910: and cmp_md.inventory_item_id = cmp_msi.inventory_item_id
911: and cmp_md.plan_id = cmp_msi.plan_id
912: and cmp_md.sr_instance_id = cmp_msi.sr_instance_id
913: and cmp_md.organization_id = cmp_msi.organization_id
914: /* msc_system_items - components and mpo_plan_organizations - components */
915: and cmp_msi.organization_id = cmp_mpo.organization_id
916: and cmp_msi.sr_instance_id = cmp_mpo.sr_instance_id
917: and cmp_msi.plan_id = cmp_mpo.plan_id
918: /* For given PLAN,INSTANCE,ASSEMBLY and COMPONENT*/

Line 936: msc_system_items ass_msi,

932: select sum(cmp_mfp.allocated_quantity)
933: INTO l_denominator
934: from
935: msc_plan_organizations ass_mpo,
936: msc_system_items ass_msi,
937: msc_demands ass_md,
938: msc_full_pegging ass_mfp,
939: msc_full_pegging cmp_mfp,
940: msc_demands cmp_md,

Line 941: msc_system_items cmp_msi,

937: msc_demands ass_md,
938: msc_full_pegging ass_mfp,
939: msc_full_pegging cmp_mfp,
940: msc_demands cmp_md,
941: msc_system_items cmp_msi,
942: msc_plan_organizations cmp_mpo
943: where ass_mpo.plan_id = p_supply_plan_id
944: /* mpo_plan_organizations - components and msc_system_items - assembly */
945: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id

Line 944: /* mpo_plan_organizations - components and msc_system_items - assembly */

940: msc_demands cmp_md,
941: msc_system_items cmp_msi,
942: msc_plan_organizations cmp_mpo
943: where ass_mpo.plan_id = p_supply_plan_id
944: /* mpo_plan_organizations - components and msc_system_items - assembly */
945: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
946: and ass_msi.plan_id = ass_mpo.plan_id
947: and ass_msi.organization_id = ass_mpo.organization_id
948: /* msc_system_items - assembly and msc_demands - assembly */

Line 948: /* msc_system_items - assembly and msc_demands - assembly */

944: /* mpo_plan_organizations - components and msc_system_items - assembly */
945: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
946: and ass_msi.plan_id = ass_mpo.plan_id
947: and ass_msi.organization_id = ass_mpo.organization_id
948: /* msc_system_items - assembly and msc_demands - assembly */
949: and ass_md.inventory_item_id = ass_msi.inventory_item_id
950: and ass_md.plan_id = ass_msi.plan_id
951: and ass_md.sr_instance_id = ass_msi.sr_instance_id
952: and ass_md.organization_id = ass_msi.organization_id

Line 971: /* msc_demands - components and msc_system_items - components */

967: and cmp_mfp.organization_id = cmp_md.organization_id
968: and cmp_mfp.sr_instance_id = cmp_md.sr_instance_id
969: and cmp_mfp.plan_id = cmp_md.plan_id
970: and cmp_md.origination_type in (29,30,8,6,24,3,1,54) -- Gross Requirements of Components across All Organizations.
971: /* msc_demands - components and msc_system_items - components */
972: and cmp_md.inventory_item_id = cmp_msi.inventory_item_id
973: and cmp_md.plan_id = cmp_msi.plan_id
974: and cmp_md.sr_instance_id = cmp_msi.sr_instance_id
975: and cmp_md.organization_id = cmp_msi.organization_id

Line 976: /* msc_system_items - components and mpo_plan_organizations - components */

972: and cmp_md.inventory_item_id = cmp_msi.inventory_item_id
973: and cmp_md.plan_id = cmp_msi.plan_id
974: and cmp_md.sr_instance_id = cmp_msi.sr_instance_id
975: and cmp_md.organization_id = cmp_msi.organization_id
976: /* msc_system_items - components and mpo_plan_organizations - components */
977: and cmp_msi.organization_id = cmp_mpo.organization_id
978: and cmp_msi.sr_instance_id = cmp_mpo.sr_instance_id
979: and cmp_msi.plan_id = cmp_mpo.plan_id
980: /* For given PLAN,INSTANCE,ASSEMBLY and COMPONENT*/

Line 1041: msc_system_items ass_msi,

1037: trunc(ass_mfp.demand_date,'MM') EFFECTIVITY_DATE,
1038: last_day(ass_mfp.demand_date) DISABLE_DATE
1039: from
1040: msc_plan_organizations ass_mpo,
1041: msc_system_items ass_msi,
1042: msd_level_values ass_mlv,
1043: msc_demands ass_md,
1044: msc_full_pegging ass_mfp,
1045: msc_full_pegging cmp_mfp,

Line 1048: msc_system_items cmp_msi,

1044: msc_full_pegging ass_mfp,
1045: msc_full_pegging cmp_mfp,
1046: msc_demands cmp_md,
1047: msd_level_values cmp_mlv,
1048: msc_system_items cmp_msi,
1049: msc_plan_organizations cmp_mpo
1050: where ass_mpo.plan_id = p_supply_plan_id
1051: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
1052: and ass_msi.plan_id = ass_mpo.plan_id

Line 1054: /* msc_system_items - assembly and msd_leve_values - assembly */

1050: where ass_mpo.plan_id = p_supply_plan_id
1051: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
1052: and ass_msi.plan_id = ass_mpo.plan_id
1053: and ass_msi.organization_id = ass_mpo.organization_id
1054: /* msc_system_items - assembly and msd_leve_values - assembly */
1055: and ass_mlv.instance = ass_msi.sr_instance_id
1056: and ass_mlv.level_id = 1
1057: and ass_mlv.sr_level_pk = to_char(ass_msi.sr_inventory_item_id)
1058: /* msc_system_items - assembly and msc_demands - assembly */

Line 1058: /* msc_system_items - assembly and msc_demands - assembly */

1054: /* msc_system_items - assembly and msd_leve_values - assembly */
1055: and ass_mlv.instance = ass_msi.sr_instance_id
1056: and ass_mlv.level_id = 1
1057: and ass_mlv.sr_level_pk = to_char(ass_msi.sr_inventory_item_id)
1058: /* msc_system_items - assembly and msc_demands - assembly */
1059: and ass_md.inventory_item_id = ass_msi.inventory_item_id
1060: and ass_md.origination_type in (6,8,29,30) --Include all independent Demand Types
1061: and ass_md.plan_id = ass_msi.plan_id
1062: and ass_md.sr_instance_id = ass_msi.sr_instance_id

Line 1080: /* msc_system_items - assembly and msd_leve_values - assembly */

1076: and cmp_md.inventory_item_id = cmp_msi.inventory_item_id
1077: and cmp_md.plan_id = cmp_msi.plan_id
1078: and cmp_md.sr_instance_id = cmp_msi.sr_instance_id
1079: and cmp_md.organization_id = cmp_msi.organization_id
1080: /* msc_system_items - assembly and msd_leve_values - assembly */
1081: and cmp_mlv.instance = ass_msi.sr_instance_id
1082: and cmp_mlv.level_id = 1
1083: and cmp_mlv.sr_level_pk = to_char(ass_msi.sr_inventory_item_id)
1084: /* msc_system_items - components and msc_demands - components */

Line 1084: /* msc_system_items - components and msc_demands - components */

1080: /* msc_system_items - assembly and msd_leve_values - assembly */
1081: and cmp_mlv.instance = ass_msi.sr_instance_id
1082: and cmp_mlv.level_id = 1
1083: and cmp_mlv.sr_level_pk = to_char(ass_msi.sr_inventory_item_id)
1084: /* msc_system_items - components and msc_demands - components */
1085: and cmp_msi.sr_instance_id = cmp_mpo.sr_instance_id
1086: and cmp_msi.plan_id = cmp_mpo.plan_id
1087: and cmp_msi.organization_id = cmp_mpo.organization_id
1088: and cmp_msi.planning_make_buy_code = 2 -- Buy Items Only

Line 1104: msc_system_items msi,

1100: trunc(mfp1.demand_date,'MM') EFFECTIVITY_DATE,
1101: last_day(mfp1.demand_date) DISABLE_DATE
1102: from
1103: msc_plan_organizations mpo1,
1104: msc_system_items msi,
1105: msd_level_values mlv1,
1106: msc_demands md,
1107: msc_full_pegging mfp1,
1108: msc_full_pegging mfp2,

Line 1118: /*msc_system_items and msd_level_values */

1114: mpo1.plan_id = p_supply_plan_id
1115: and msi.plan_id = mpo1.plan_id
1116: and msi.organization_id = mpo1.organization_id
1117: and msi.sr_instance_id = mpo1.sr_instance_id
1118: /*msc_system_items and msd_level_values */
1119: and mlv1.instance = msi.sr_instance_id
1120: and mlv1.level_id = 1
1121: and mlv1.sr_level_pk = to_char(msi.sr_inventory_item_id)
1122: /* msc_system_items and msc_demands */

Line 1122: /* msc_system_items and msc_demands */

1118: /*msc_system_items and msd_level_values */
1119: and mlv1.instance = msi.sr_instance_id
1120: and mlv1.level_id = 1
1121: and mlv1.sr_level_pk = to_char(msi.sr_inventory_item_id)
1122: /* msc_system_items and msc_demands */
1123: and msi.inventory_item_id = md.inventory_item_id
1124: and msi.plan_id = md.plan_id
1125: and msi.organization_id = md.organization_id
1126: and msi.sr_instance_id = md.sr_instance_id

Line 1750: msc_system_items ass_msi,

1746: ass_msi.sr_inventory_item_id SR_ASSEMBLY_PK,
1747: cmp_msi.sr_inventory_item_id SR_COMPONENT_PK
1748: from
1749: msc_plan_organizations ass_mpo,
1750: msc_system_items ass_msi,
1751: msd_level_values ass_mlv,
1752: msc_demands ass_md,
1753: msc_full_pegging ass_mfp,
1754: msc_full_pegging cmp_mfp,

Line 1757: msc_system_items cmp_msi,

1753: msc_full_pegging ass_mfp,
1754: msc_full_pegging cmp_mfp,
1755: msc_demands cmp_md,
1756: msd_level_values cmp_mlv,
1757: msc_system_items cmp_msi,
1758: msc_plan_organizations cmp_mpo
1759: where
1760: /* msc_system_items - assembly and msc_plans - assembly */
1761: ass_mpo.plan_id = p_supply_plan_id

Line 1760: /* msc_system_items - assembly and msc_plans - assembly */

1756: msd_level_values cmp_mlv,
1757: msc_system_items cmp_msi,
1758: msc_plan_organizations cmp_mpo
1759: where
1760: /* msc_system_items - assembly and msc_plans - assembly */
1761: ass_mpo.plan_id = p_supply_plan_id
1762: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
1763: and ass_msi.plan_id = ass_mpo.plan_id
1764: and ass_msi.organization_id = ass_mpo.organization_id

Line 1765: /* msc_system_items - assembly and msd_level_values - assembly */

1761: ass_mpo.plan_id = p_supply_plan_id
1762: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
1763: and ass_msi.plan_id = ass_mpo.plan_id
1764: and ass_msi.organization_id = ass_mpo.organization_id
1765: /* msc_system_items - assembly and msd_level_values - assembly */
1766: and ass_mlv.instance = ass_msi.sr_instance_id
1767: and ass_mlv.level_id = 1
1768: and ass_mlv.sr_level_pk = to_char(ass_msi.sr_inventory_item_id)
1769: /* msc_system_items - assembly and msc_demands - assembly */

Line 1769: /* msc_system_items - assembly and msc_demands - assembly */

1765: /* msc_system_items - assembly and msd_level_values - assembly */
1766: and ass_mlv.instance = ass_msi.sr_instance_id
1767: and ass_mlv.level_id = 1
1768: and ass_mlv.sr_level_pk = to_char(ass_msi.sr_inventory_item_id)
1769: /* msc_system_items - assembly and msc_demands - assembly */
1770: and ass_md.inventory_item_id = ass_msi.inventory_item_id
1771: and ass_md.origination_type in (6,8,29,30) --Include all independent Demand Types
1772: and ass_md.plan_id = ass_msi.plan_id
1773: and ass_md.sr_instance_id = ass_msi.sr_instance_id

Line 1790: /* msc_system_items - assembly and msd_leve_values - assembly */

1786: and cmp_md.inventory_item_id = cmp_msi.inventory_item_id
1787: and cmp_md.plan_id = cmp_msi.plan_id
1788: and cmp_md.sr_instance_id = cmp_msi.sr_instance_id
1789: and cmp_md.organization_id = cmp_msi.organization_id
1790: /* msc_system_items - assembly and msd_leve_values - assembly */
1791: and cmp_mlv.instance = ass_msi.sr_instance_id
1792: and cmp_mlv.level_id = 1
1793: and cmp_mlv.sr_level_pk = to_char(ass_msi.sr_inventory_item_id)
1794: /* msc_system_items - components and msc_demands - components */

Line 1794: /* msc_system_items - components and msc_demands - components */

1790: /* msc_system_items - assembly and msd_leve_values - assembly */
1791: and cmp_mlv.instance = ass_msi.sr_instance_id
1792: and cmp_mlv.level_id = 1
1793: and cmp_mlv.sr_level_pk = to_char(ass_msi.sr_inventory_item_id)
1794: /* msc_system_items - components and msc_demands - components */
1795: and cmp_msi.sr_instance_id = cmp_mpo.sr_instance_id
1796: and cmp_msi.plan_id = cmp_mpo.plan_id
1797: and cmp_msi.organization_id = cmp_mpo.organization_id
1798: and cmp_mpo.plan_id = p_supply_plan_id; -- For a given ascp plan

Line 1808: msc_system_items ass_msi,

1804: ass_msi.sr_inventory_item_id SR_ASSEMBLY_PK,
1805: cmp_msi.sr_inventory_item_id SR_COMPONENT_PK
1806: from
1807: msc_plan_organizations ass_mpo,
1808: msc_system_items ass_msi,
1809: msd_level_values ass_mlv,
1810: msc_demands ass_md,
1811: msc_full_pegging ass_mfp,
1812: msc_full_pegging cmp_mfp,

Line 1815: msc_system_items cmp_msi,

1811: msc_full_pegging ass_mfp,
1812: msc_full_pegging cmp_mfp,
1813: msc_demands cmp_md,
1814: msd_level_values cmp_mlv,
1815: msc_system_items cmp_msi,
1816: msc_plan_organizations cmp_mpo
1817: where
1818: /* msc_system_items - assembly and msc_plans - assembly */
1819: ass_mpo.plan_id = p_supply_plan_id

Line 1818: /* msc_system_items - assembly and msc_plans - assembly */

1814: msd_level_values cmp_mlv,
1815: msc_system_items cmp_msi,
1816: msc_plan_organizations cmp_mpo
1817: where
1818: /* msc_system_items - assembly and msc_plans - assembly */
1819: ass_mpo.plan_id = p_supply_plan_id
1820: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
1821: and ass_msi.plan_id = ass_mpo.plan_id
1822: and ass_msi.organization_id = ass_mpo.organization_id

Line 1823: /* msc_system_items - assembly and msd_level_values - assembly */

1819: ass_mpo.plan_id = p_supply_plan_id
1820: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
1821: and ass_msi.plan_id = ass_mpo.plan_id
1822: and ass_msi.organization_id = ass_mpo.organization_id
1823: /* msc_system_items - assembly and msd_level_values - assembly */
1824: and ass_mlv.instance = ass_msi.sr_instance_id
1825: and ass_mlv.level_id = 1
1826: and ass_mlv.sr_level_pk = to_char(ass_msi.sr_inventory_item_id)
1827: /* msc_system_items - assembly and msc_demands - assembly */

Line 1827: /* msc_system_items - assembly and msc_demands - assembly */

1823: /* msc_system_items - assembly and msd_level_values - assembly */
1824: and ass_mlv.instance = ass_msi.sr_instance_id
1825: and ass_mlv.level_id = 1
1826: and ass_mlv.sr_level_pk = to_char(ass_msi.sr_inventory_item_id)
1827: /* msc_system_items - assembly and msc_demands - assembly */
1828: and ass_md.inventory_item_id = ass_msi.inventory_item_id
1829: and ass_md.origination_type in (6,8,29,30) --Include all independent Demand Types
1830: and ass_md.plan_id = ass_msi.plan_id
1831: and ass_md.sr_instance_id = ass_msi.sr_instance_id

Line 1848: /* msc_system_items - assembly and msd_leve_values - assembly */

1844: and cmp_md.inventory_item_id = cmp_msi.inventory_item_id
1845: and cmp_md.plan_id = cmp_msi.plan_id
1846: and cmp_md.sr_instance_id = cmp_msi.sr_instance_id
1847: and cmp_md.organization_id = cmp_msi.organization_id
1848: /* msc_system_items - assembly and msd_leve_values - assembly */
1849: and cmp_mlv.instance = ass_msi.sr_instance_id
1850: and cmp_mlv.level_id = 1
1851: and cmp_mlv.sr_level_pk = to_char(ass_msi.sr_inventory_item_id)
1852: /* msc_system_items - components and msc_demands - components */

Line 1852: /* msc_system_items - components and msc_demands - components */

1848: /* msc_system_items - assembly and msd_leve_values - assembly */
1849: and cmp_mlv.instance = ass_msi.sr_instance_id
1850: and cmp_mlv.level_id = 1
1851: and cmp_mlv.sr_level_pk = to_char(ass_msi.sr_inventory_item_id)
1852: /* msc_system_items - components and msc_demands - components */
1853: and cmp_msi.sr_instance_id = cmp_mpo.sr_instance_id
1854: and cmp_msi.plan_id = cmp_mpo.plan_id
1855: and cmp_msi.organization_id = cmp_mpo.organization_id
1856: and cmp_mpo.plan_id = p_supply_plan_id; -- For a given ascp plan