[Home] [Help]
183: decode(d.origination_type,
184: 6, decode(d.source_organization_id,
185: NULL, DECODE(D.DEMAND_CLASS, null, null,
186: DECODE(p_demand_class, '-1',
187: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
188: null, null, p_item_id, p_org_id,
189: p_instance_id, TRUNC(
190: DECODE(RECORD_SOURCE,
191: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
196: p_level_id, D.DEMAND_CLASS),
197: D.DEMAND_CLASS)),
198: -23453, DECODE(D.DEMAND_CLASS, null, null,
199: DECODE(p_demand_class, '-1',
200: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
201: null, null, p_item_id, p_org_id,
202: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
203: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
204: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
207: p_level_id, D.DEMAND_CLASS), --plan by request date,promise date, schedule date
208: D.DEMAND_CLASS)),
209: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
210: DECODE(p_demand_class, '-1',
211: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
212: null, null, p_item_id, p_org_id,
213: p_instance_id, TRUNC(
214: DECODE(RECORD_SOURCE,
215: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
220: D.DEMAND_CLASS)), TO_CHAR(NULL)),
221: 30, decode(d.source_organization_id,
222: NULL, DECODE(D.DEMAND_CLASS, null, null,
223: DECODE(p_demand_class, '-1',
224: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
225: null, null, p_item_id, p_org_id,
226: p_instance_id, TRUNC(
227: DECODE(RECORD_SOURCE,
228: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
232: p_level_id, D.DEMAND_CLASS), --plan by request date,promise date, schedule date
233: D.DEMAND_CLASS)),
234: -23453, DECODE(D.DEMAND_CLASS, null, null,
235: DECODE(p_demand_class, '-1',
236: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
237: null, null, p_item_id, p_org_id,
238: p_instance_id, TRUNC(
239: DECODE(RECORD_SOURCE,
240: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
244: p_level_id, D.DEMAND_CLASS), --plan by request date,promise date, schedule date
245: D.DEMAND_CLASS)),
246: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
247: DECODE(p_demand_class, '-1',
248: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
249: null, null, p_item_id, p_org_id,
250: p_instance_id, TRUNC(
251: DECODE(RECORD_SOURCE,
252: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
256: p_level_id, D.DEMAND_CLASS), --plan by request date,promise date, schedule date
257: D.DEMAND_CLASS)), TO_CHAR(NULL)),
258: DECODE(D.DEMAND_CLASS, null, null,
259: DECODE(p_demand_class, '-1',
260: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
261: null, null, p_item_id, p_org_id,
262: p_instance_id, TRUNC(
263: DECODE(RECORD_SOURCE,
264: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
268: p_level_id, D.DEMAND_CLASS), --plan by request date,promise date, schedule date
269: D.DEMAND_CLASS))),
270: DECODE(D.DEMAND_CLASS, null, null, --10425563
271: DECODE(p_demand_class, '-1',
272: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
273: null, null, p_item_id, p_org_id,
274: p_instance_id, TRUNC(
275: DECODE(RECORD_SOURCE,
276: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
285: -- rajjain begin 07/19/2002
286: decode(MSC_ATP_PVT.G_INTERNAL_SALES_ORDER,'N', --10425563
287: decode(d.origination_type,
288: 6, decode(d.source_organization_id,
289: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
290: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
291: p_org_id, p_instance_id,
292: TRUNC(DECODE(RECORD_SOURCE,
293: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
294: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
295: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
296: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
297: p_level_id, NULL),
298: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
299: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
300: p_org_id, p_instance_id,
301: TRUNC(DECODE(RECORD_SOURCE,
302: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
303: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
304: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
305: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
306: p_level_id, NULL),
307: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
308: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
309: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
310: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
311: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
313: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
314: p_level_id, NULL),
315: TO_CHAR(NULL)),
316: 30, decode(d.source_organization_id,
317: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
318: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
319: p_org_id, p_instance_id,
320: TRUNC(DECODE(RECORD_SOURCE,
321: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
322: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
323: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
324: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
325: p_level_id, NULL),
326: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
327: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
328: p_org_id, p_instance_id,
329: TRUNC(DECODE(RECORD_SOURCE,
330: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
331: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
332: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
333: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
334: p_level_id, NULL),
335: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
336: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
337: p_org_id, p_instance_id,
338: TRUNC(DECODE(RECORD_SOURCE,
339: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
341: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
342: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
343: p_level_id, NULL),
344: TO_CHAR(NULL)),
345: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
346: p_item_id, p_org_id, p_instance_id,
347: TRUNC(DECODE(RECORD_SOURCE,
348: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
349: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
349: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
350: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
351: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))))--plan by request date,promise date, schedule date
352: ,p_level_id, NULL)),
353: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, --10425563
354: p_item_id, p_org_id, p_instance_id,
355: TRUNC(DECODE(RECORD_SOURCE,
356: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
357: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
362: -- rajjain end 07/19/2002
363: p_demand_class, 1,
364: Decode(D.Demand_Class, NULL, --4365873 If l_demand_class is not null and demand class is populated
365: -- on supplies record then 0 should be allocated.
366: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,
367: D.DEMAND_ID,
368: TRUNC(DECODE(RECORD_SOURCE,
369: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
370: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
394: decode(d.origination_type,
395: 6, decode(d.source_organization_id,
396: NULL, DECODE(D.DEMAND_CLASS, null, null,
397: DECODE(p_demand_class, '-1',
398: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
399: null, null, p_item_id, p_org_id,
400: p_instance_id, TRUNC(
401: DECODE(RECORD_SOURCE,
402: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
406: p_level_id, D.DEMAND_CLASS),
407: D.DEMAND_CLASS)),
408: -23453, DECODE(D.DEMAND_CLASS, null, null,
409: DECODE(p_demand_class, '-1',
410: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
411: null, null, p_item_id, p_org_id,
412: p_instance_id,
413: TRUNC(DECODE(RECORD_SOURCE,
414: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
418: p_level_id, D.DEMAND_CLASS),
419: D.DEMAND_CLASS)),
420: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
421: DECODE(p_demand_class, '-1',
422: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
423: null, null, p_item_id, p_org_id,
424: p_instance_id,
425: TRUNC(DECODE(RECORD_SOURCE,
426: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
432: p_demand_class),
433: 30, decode(d.source_organization_id,
434: NULL, DECODE(D.DEMAND_CLASS, null, null,
435: DECODE(p_demand_class, '-1',
436: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
437: null, null, p_item_id, p_org_id,
438: p_instance_id,
439: TRUNC(DECODE(RECORD_SOURCE,
440: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
444: p_level_id, D.DEMAND_CLASS),
445: D.DEMAND_CLASS)),
446: -23453, DECODE(D.DEMAND_CLASS, null, null,
447: DECODE(p_demand_class, '-1',
448: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
449: null, null, p_item_id, p_org_id,
450: p_instance_id,
451: TRUNC(DECODE(RECORD_SOURCE,
452: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
456: p_level_id, D.DEMAND_CLASS),
457: D.DEMAND_CLASS)),
458: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
459: DECODE(p_demand_class, '-1',
460: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
461: null, null, p_item_id, p_org_id,
462: p_instance_id,
463: TRUNC(DECODE(RECORD_SOURCE,
464: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
469: D.DEMAND_CLASS)),
470: p_demand_class),
471: DECODE(D.DEMAND_CLASS, null, null,
472: DECODE(p_demand_class, '-1',
473: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
474: null, null, p_item_id, p_org_id,
475: p_instance_id, TRUNC(
476: DECODE(RECORD_SOURCE,
477: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
481: , p_level_id, D.DEMAND_CLASS),
482: D.DEMAND_CLASS))),
483: DECODE(D.DEMAND_CLASS, null, null, --10425563
484: DECODE(p_demand_class, '-1',
485: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
486: null, null, p_item_id, p_org_id,
487: p_instance_id, TRUNC(
488: DECODE(RECORD_SOURCE,
489: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
498: -- rajjain begin 07/19/2002
499: decode(MSC_ATP_PVT.G_INTERNAL_SALES_ORDER,'N', --10425563
500: decode(d.origination_type,
501: 6, decode(d.source_organization_id,
502: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
503: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
504: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
505: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
506: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
506: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
507: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
508: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
509: p_level_id, NULL),
510: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
511: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
512: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
513: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
514: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
514: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
515: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
516: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
517: p_level_id, NULL),
518: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
519: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
520: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
521: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
522: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
524: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
525: p_level_id, NULL),
526: p_demand_class),
527: 30, decode(d.source_organization_id,
528: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
529: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
530: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
531: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
532: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
532: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
533: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
534: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
535: p_level_id, NULL),
536: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
537: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
538: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
539: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
540: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
540: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
541: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
542: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
543: p_level_id, NULL),
544: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
545: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
546: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
547: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
548: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
549: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
550: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
551: p_level_id, NULL),
552: p_demand_class),
553: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
554: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
555: p_item_id, p_org_id, p_instance_id,
556: TRUNC(DECODE
557: (RECORD_SOURCE,
565: )
566: )
567: ),p_level_id, NULL)
568: ),
569: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class( --10425563
570: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
571: p_item_id, p_org_id, p_instance_id,
572: TRUNC(DECODE
573: (RECORD_SOURCE,
630: --2424357: Convert the demand calls in case of others for
631: --- demand class allocated ATP
632: 1, DECODE(S.DEMAND_CLASS, null, null,
633: DECODE(p_demand_class, '-1',
634: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
635: null,
636: null,
637: S.inventory_item_id,
638: p_org_id,
642: p_level_id,
643: S.DEMAND_CLASS),S.DEMAND_CLASS)),
644: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
645: 0, TO_CHAR(NULL),
646: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
647: S.CUSTOMER_ID,
648: S.SHIP_TO_SITE_ID,
649: S.inventory_item_id,
650: p_org_id,
654: p_level_id,
655: NULL))),
656: p_demand_class, 1,
657: NULL, nvl(MIHM.allocation_percent/100,1), --4365873
658: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
659: p_instance_id,
660: s.inventory_item_id,
661: p_org_id,
662: null,
665: -- c.next_date -- 2859130
666: trunc(nvl(s.firm_date, s.new_schedule_date))), 1),*/
667: DECODE(
668: MIHM.allocation_percent/100, --4365873
669: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
670: p_instance_id,
671: s.inventory_item_id,
672: p_org_id,
673: null,
768: decode(d.origination_type,
769: 6, decode(d.source_organization_id,
770: NULL, DECODE(D.DEMAND_CLASS, null, null,
771: DECODE(p_demand_class, '-1',
772: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
773: null, null, p_item_id, p_org_id,
774: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
775: D.DEMAND_CLASS)),
776: -23453, DECODE(D.DEMAND_CLASS, null, null,
774: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
775: D.DEMAND_CLASS)),
776: -23453, DECODE(D.DEMAND_CLASS, null, null,
777: DECODE(p_demand_class, '-1',
778: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
779: null, null, p_item_id, p_org_id,
780: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
781: D.DEMAND_CLASS)),
782: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
780: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
781: D.DEMAND_CLASS)),
782: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
783: DECODE(p_demand_class, '-1',
784: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
785: null, null, p_item_id, p_org_id,
786: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
787: D.DEMAND_CLASS)), TO_CHAR(NULL)),
788: 30, decode(d.source_organization_id,
787: D.DEMAND_CLASS)), TO_CHAR(NULL)),
788: 30, decode(d.source_organization_id,
789: NULL, DECODE(D.DEMAND_CLASS, null, null,
790: DECODE(p_demand_class, '-1',
791: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
792: null, null, p_item_id, p_org_id,
793: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
794: D.DEMAND_CLASS)),
795: -23453, DECODE(D.DEMAND_CLASS, null, null,
793: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
794: D.DEMAND_CLASS)),
795: -23453, DECODE(D.DEMAND_CLASS, null, null,
796: DECODE(p_demand_class, '-1',
797: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
798: null, null, p_item_id, p_org_id,
799: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
800: D.DEMAND_CLASS)),
801: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
799: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
800: D.DEMAND_CLASS)),
801: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
802: DECODE(p_demand_class, '-1',
803: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
804: null, null, p_item_id, p_org_id,
805: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
806: D.DEMAND_CLASS)), TO_CHAR(NULL)),
807: DECODE(D.DEMAND_CLASS, null, null,
805: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
806: D.DEMAND_CLASS)), TO_CHAR(NULL)),
807: DECODE(D.DEMAND_CLASS, null, null,
808: DECODE(p_demand_class, '-1',
809: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
810: null, null, p_item_id, p_org_id,
811: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
812: D.DEMAND_CLASS))),
813: DECODE(D.DEMAND_CLASS, null, null, --10425563
811: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
812: D.DEMAND_CLASS))),
813: DECODE(D.DEMAND_CLASS, null, null, --10425563
814: DECODE(p_demand_class, '-1',
815: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
816: null, null, p_item_id, p_org_id,
817: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
818: D.DEMAND_CLASS))),
819: -- rajjain end
822: -- rajjain begin 07/19/2002
823: decode(MSC_ATP_PVT.G_INTERNAL_SALES_ORDER,'N', --10425563
824: decode(d.origination_type,
825: 6, decode(d.source_organization_id,
826: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
827: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
828: p_org_id, p_instance_id, c.calendar_date,
829: p_level_id, NULL),
830: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
826: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
827: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
828: p_org_id, p_instance_id, c.calendar_date,
829: p_level_id, NULL),
830: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
831: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
832: p_org_id, p_instance_id, c.calendar_date,
833: p_level_id, NULL),
834: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
830: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
831: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
832: p_org_id, p_instance_id, c.calendar_date,
833: p_level_id, NULL),
834: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
835: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
836: p_org_id, p_instance_id, c.calendar_date,
837: p_level_id, NULL),
838: TO_CHAR(NULL)),
836: p_org_id, p_instance_id, c.calendar_date,
837: p_level_id, NULL),
838: TO_CHAR(NULL)),
839: 30, decode(d.source_organization_id,
840: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
841: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
842: p_org_id, p_instance_id, c.calendar_date,
843: p_level_id, NULL),
844: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
840: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
841: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
842: p_org_id, p_instance_id, c.calendar_date,
843: p_level_id, NULL),
844: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
845: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
846: p_org_id, p_instance_id, c.calendar_date,
847: p_level_id, NULL),
848: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
844: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
845: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
846: p_org_id, p_instance_id, c.calendar_date,
847: p_level_id, NULL),
848: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
849: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
850: p_org_id, p_instance_id, c.calendar_date,
851: p_level_id, NULL),
852: TO_CHAR(NULL)),
849: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
850: p_org_id, p_instance_id, c.calendar_date,
851: p_level_id, NULL),
852: TO_CHAR(NULL)),
853: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
854: p_item_id, p_org_id, p_instance_id,
855: c.calendar_date,p_level_id, NULL)),
856: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, --10425563
857: p_item_id, p_org_id, p_instance_id,
852: TO_CHAR(NULL)),
853: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
854: p_item_id, p_org_id, p_instance_id,
855: c.calendar_date,p_level_id, NULL)),
856: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, --10425563
857: p_item_id, p_org_id, p_instance_id,
858: c.calendar_date,p_level_id, NULL))
859: )),
860: -- rajjain end 07/19/2002
859: )),
860: -- rajjain end 07/19/2002
861: p_demand_class, 1,
862: Decode(D.Demand_Class, NULL, --4365873
863: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,
864: D.DEMAND_ID,
865: c.calendar_date,
866: D.USING_ASSEMBLY_ITEM_ID,
867: DECODE(D.SOURCE_ORGANIZATION_ID,
887: decode(d.origination_type,
888: 6, decode(d.source_organization_id,
889: NULL, DECODE(D.DEMAND_CLASS, null, null,
890: DECODE(p_demand_class, '-1',
891: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
892: null, null, p_item_id, p_org_id,
893: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
894: D.DEMAND_CLASS)),
895: -23453, DECODE(D.DEMAND_CLASS, null, null,
893: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
894: D.DEMAND_CLASS)),
895: -23453, DECODE(D.DEMAND_CLASS, null, null,
896: DECODE(p_demand_class, '-1',
897: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
898: null, null, p_item_id, p_org_id,
899: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
900: D.DEMAND_CLASS)),
901: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
899: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
900: D.DEMAND_CLASS)),
901: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
902: DECODE(p_demand_class, '-1',
903: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
904: null, null, p_item_id, p_org_id,
905: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
906: D.DEMAND_CLASS)),
907: p_demand_class),
907: p_demand_class),
908: 30, decode(d.source_organization_id,
909: NULL, DECODE(D.DEMAND_CLASS, null, null,
910: DECODE(p_demand_class, '-1',
911: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
912: null, null, p_item_id, p_org_id,
913: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
914: D.DEMAND_CLASS)),
915: -23453, DECODE(D.DEMAND_CLASS, null, null,
913: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
914: D.DEMAND_CLASS)),
915: -23453, DECODE(D.DEMAND_CLASS, null, null,
916: DECODE(p_demand_class, '-1',
917: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
918: null, null, p_item_id, p_org_id,
919: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
920: D.DEMAND_CLASS)),
921: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
919: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
920: D.DEMAND_CLASS)),
921: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
922: DECODE(p_demand_class, '-1',
923: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
924: null, null, p_item_id, p_org_id,
925: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
926: D.DEMAND_CLASS)),
927: p_demand_class),
926: D.DEMAND_CLASS)),
927: p_demand_class),
928: DECODE(D.DEMAND_CLASS, null, null,
929: DECODE(p_demand_class, '-1',
930: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
931: null, null, p_item_id, p_org_id,
932: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
933: D.DEMAND_CLASS))),
934: DECODE(D.DEMAND_CLASS, null, null, --10425563
932: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
933: D.DEMAND_CLASS))),
934: DECODE(D.DEMAND_CLASS, null, null, --10425563
935: DECODE(p_demand_class, '-1',
936: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
937: null, null, p_item_id, p_org_id,
938: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
939: D.DEMAND_CLASS))),
940: -- rajjain end
943: -- rajjain begin 07/19/2002
944: decode(MSC_ATP_PVT.G_INTERNAL_SALES_ORDER,'N', --10425563
945: decode(d.origination_type,
946: 6, decode(d.source_organization_id,
947: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
948: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
949: p_org_id, p_instance_id, c.calendar_date,
950: p_level_id, NULL),
951: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
947: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
948: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
949: p_org_id, p_instance_id, c.calendar_date,
950: p_level_id, NULL),
951: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
952: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
953: p_org_id, p_instance_id, c.calendar_date,
954: p_level_id, NULL),
955: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
951: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
952: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
953: p_org_id, p_instance_id, c.calendar_date,
954: p_level_id, NULL),
955: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
956: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
957: p_org_id, p_instance_id, c.calendar_date,
958: p_level_id, NULL),
959: p_demand_class),
957: p_org_id, p_instance_id, c.calendar_date,
958: p_level_id, NULL),
959: p_demand_class),
960: 30, decode(d.source_organization_id,
961: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
962: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
963: p_org_id, p_instance_id, c.calendar_date,
964: p_level_id, NULL),
965: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
961: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
962: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
963: p_org_id, p_instance_id, c.calendar_date,
964: p_level_id, NULL),
965: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
966: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
967: p_org_id, p_instance_id, c.calendar_date,
968: p_level_id, NULL),
969: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
965: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
966: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
967: p_org_id, p_instance_id, c.calendar_date,
968: p_level_id, NULL),
969: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
970: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
971: p_org_id, p_instance_id, c.calendar_date,
972: p_level_id, NULL),
973: p_demand_class),
970: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
971: p_org_id, p_instance_id, c.calendar_date,
972: p_level_id, NULL),
973: p_demand_class),
974: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
975: p_item_id, p_org_id, p_instance_id,
976: c.calendar_date,p_level_id, NULL)),
977: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, --10425563
978: p_item_id, p_org_id, p_instance_id,
973: p_demand_class),
974: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
975: p_item_id, p_org_id, p_instance_id,
976: c.calendar_date,p_level_id, NULL)),
977: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, --10425563
978: p_item_id, p_org_id, p_instance_id,
979: c.calendar_date,p_level_id, NULL))
980: )),
981: -- rajjain end 07/19/2002
1026: --2424357: Convert the demand calls in case of others for
1027: --- demand class allocated ATP
1028: 1, DECODE(CS.DEMAND_CLASS, null, null,
1029: DECODE(p_demand_class, '-1',
1030: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1031: null,
1032: null,
1033: cs.inventory_item_id,
1034: p_org_id,
1037: p_level_id,
1038: CS.DEMAND_CLASS),CS.DEMAND_CLASS)),
1039: 2, DECODE(CS.CUSTOMER_ID, NULL, TO_CHAR(NULL),
1040: 0, TO_CHAR(NULL),
1041: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1042: CS.CUSTOMER_ID,
1043: CS.SHIP_TO_SITE_ID,
1044: cs.inventory_item_id,
1045: p_org_id,
1048: p_level_id,
1049: NULL))),
1050: p_demand_class, 1,
1051: NULL, nvl(MIHM.allocation_percent/100,1), --4365873
1052: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
1053: p_instance_id,
1054: cs.inventory_item_id,
1055: p_org_id,
1056: null,
1058: p_demand_class,
1059: cs.calendar_date), 1),*/
1060: DECODE(
1061: MIHM.allocation_percent/100, --4365873
1062: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
1063: p_instance_id,
1064: cs.inventory_item_id,
1065: p_org_id,
1066: null,
1184: decode(d.origination_type,
1185: 6, decode(d.source_organization_id,
1186: NULL, DECODE(D.DEMAND_CLASS, null, null,
1187: DECODE(p_demand_class, '-1',
1188: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1189: null, null, p_item_id, p_org_id,
1190: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1191: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1192: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1194: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1195: D.DEMAND_CLASS)),
1196: -23453, DECODE(D.DEMAND_CLASS, null, null,
1197: DECODE(p_demand_class, '-1',
1198: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1199: null, null, p_item_id, p_org_id,
1200: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1201: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1202: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1204: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1205: D.DEMAND_CLASS)),
1206: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1207: DECODE(p_demand_class, '-1',
1208: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1209: null, null, p_item_id, p_org_id,
1210: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1211: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1212: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1215: D.DEMAND_CLASS)), TO_CHAR(NULL)),
1216: 30, decode(d.source_organization_id,
1217: NULL, DECODE(D.DEMAND_CLASS, null, null,
1218: DECODE(p_demand_class, '-1',
1219: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1220: null, null, p_item_id, p_org_id,
1221: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1222: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1223: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1225: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1226: D.DEMAND_CLASS)),
1227: -23453, DECODE(D.DEMAND_CLASS, null, null,
1228: DECODE(p_demand_class, '-1',
1229: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1230: null, null, p_item_id, p_org_id,
1231: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1232: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1233: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1235: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1236: D.DEMAND_CLASS)),
1237: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1238: DECODE(p_demand_class, '-1',
1239: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1240: null, null, p_item_id, p_org_id,
1241: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1242: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1243: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1245: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1246: D.DEMAND_CLASS)), TO_CHAR(NULL)),
1247: DECODE(D.DEMAND_CLASS, null, null,
1248: DECODE(p_demand_class, '-1',
1249: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1250: null, null, p_item_id, p_org_id,
1251: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1252: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1253: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1255: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1256: D.DEMAND_CLASS))),
1257: DECODE(D.DEMAND_CLASS, null, null, --10425563
1258: DECODE(p_demand_class, '-1',
1259: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1260: null, null, p_item_id, p_org_id,
1261: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1262: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1263: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1270: -- rajjain begin 07/19/2002
1271: decode(MSC_ATP_PVT.G_INTERNAL_SALES_ORDER,'N', --10425563
1272: decode(d.origination_type,
1273: 6, decode(d.source_organization_id,
1274: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1275: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1276: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1277: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1278: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1278: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1279: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1280: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1281: p_level_id, NULL),
1282: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1283: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1284: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1285: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1286: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1286: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1287: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1288: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1289: p_level_id, NULL),
1290: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1291: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1292: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1293: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1294: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1296: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1297: p_level_id, NULL),
1298: TO_CHAR(NULL)),
1299: 30, decode(d.source_organization_id,
1300: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1301: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1302: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1303: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1304: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1304: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1305: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1306: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1307: p_level_id, NULL),
1308: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1309: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1310: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1311: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1312: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1312: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1313: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1314: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1315: p_level_id, NULL),
1316: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1317: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1318: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1319: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1320: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1321: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1322: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1323: p_level_id, NULL),
1324: TO_CHAR(NULL)),
1325: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
1326: p_item_id, p_org_id, p_instance_id,
1327: TRUNC(DECODE(RECORD_SOURCE,
1328: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1329: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1328: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1329: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1330: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1331: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),p_level_id, NULL)),
1332: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, --10425563
1333: p_item_id, p_org_id, p_instance_id,
1334: TRUNC(DECODE(RECORD_SOURCE,
1335: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1336: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1339: )),
1340: -- rajjain end 07/19/2002
1341: p_demand_class, 1,
1342: Decode(D.Demand_Class, NULL, --4365873
1343: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,
1344: D.DEMAND_ID,
1345: TRUNC(DECODE(RECORD_SOURCE,
1346: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1347: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1371: decode(d.origination_type,
1372: 6, decode(d.source_organization_id,
1373: NULL, DECODE(D.DEMAND_CLASS, null, null,
1374: DECODE(p_demand_class, '-1',
1375: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1376: null, null, p_item_id, p_org_id,
1377: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1378: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1379: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1381: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1382: D.DEMAND_CLASS)),
1383: -23453, DECODE(D.DEMAND_CLASS, null, null,
1384: DECODE(p_demand_class, '-1',
1385: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1386: null, null, p_item_id, p_org_id,
1387: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1388: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1389: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1391: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1392: D.DEMAND_CLASS)),
1393: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1394: DECODE(p_demand_class, '-1',
1395: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1396: null, null, p_item_id, p_org_id,
1397: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1398: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1399: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1403: p_demand_class),
1404: 30, decode(d.source_organization_id,
1405: NULL, DECODE(D.DEMAND_CLASS, null, null,
1406: DECODE(p_demand_class, '-1',
1407: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1408: null, null, p_item_id, p_org_id,
1409: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1410: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1411: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1413: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1414: D.DEMAND_CLASS)),
1415: -23453, DECODE(D.DEMAND_CLASS, null, null,
1416: DECODE(p_demand_class, '-1',
1417: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1418: null, null, p_item_id, p_org_id,
1419: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1420: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1421: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1423: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1424: D.DEMAND_CLASS)),
1425: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1426: DECODE(p_demand_class, '-1',
1427: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1428: null, null, p_item_id, p_org_id,
1429: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1430: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1431: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1434: D.DEMAND_CLASS)),
1435: p_demand_class),
1436: DECODE(D.DEMAND_CLASS, null, null,
1437: DECODE(p_demand_class, '-1',
1438: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1439: null, null, p_item_id, p_org_id,
1440: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1441: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1442: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1444: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1445: D.DEMAND_CLASS))),
1446: DECODE(D.DEMAND_CLASS, null, null, --10425563
1447: DECODE(p_demand_class, '-1',
1448: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1449: null, null, p_item_id, p_org_id,
1450: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1451: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1452: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1459: -- rajjain begin 07/19/2002
1460: decode(MSC_ATP_PVT.G_INTERNAL_SALES_ORDER,'N', --10425563
1461: decode(d.origination_type,
1462: 6, decode(d.source_organization_id,
1463: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1464: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1465: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1466: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1467: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1467: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1468: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1469: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1470: p_level_id, NULL),
1471: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1472: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1473: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1474: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1475: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1475: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1476: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1477: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1478: p_level_id, NULL),
1479: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1480: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1481: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1482: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1483: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1485: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1486: p_level_id, NULL),
1487: p_demand_class),
1488: 30, decode(d.source_organization_id,
1489: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1490: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1491: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1492: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1493: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1493: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1494: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1495: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1496: p_level_id, NULL),
1497: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1498: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1499: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1500: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1501: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1501: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1502: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1503: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1504: p_level_id, NULL),
1505: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1506: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1507: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1508: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1509: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1510: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1511: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1512: p_level_id, NULL),
1513: p_demand_class),
1514: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
1515: p_item_id, p_org_id, p_instance_id,
1516: TRUNC(DECODE(RECORD_SOURCE,
1517: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1518: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1517: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1518: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1519: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1520: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),p_level_id, NULL)),
1521: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, --10425563
1522: p_item_id, p_org_id, p_instance_id,
1523: TRUNC(DECODE(RECORD_SOURCE,
1524: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1525: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1575: --2424357: Convert the demand calls in case of others for
1576: --- demand class allocated ATP
1577: 1, DECODE(S.DEMAND_CLASS, null, null,
1578: DECODE(p_demand_class, '-1',
1579: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1580: null,
1581: null,
1582: S.inventory_item_id,
1583: p_org_id,
1586: p_level_id,
1587: S.DEMAND_CLASS),S.DEMAND_CLASS)),
1588: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
1589: 0, TO_CHAR(NULL),
1590: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1591: S.CUSTOMER_ID,
1592: S.SHIP_TO_SITE_ID,
1593: S.inventory_item_id,
1594: p_org_id,
1597: p_level_id,
1598: NULL))),
1599: p_demand_class, 1,
1600: NULL, nvl(MIHM.allocation_percent/100,1), --4365873
1601: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
1602: p_instance_id,
1603: s.inventory_item_id,
1604: p_org_id,
1605: null,
1606: null,
1607: p_demand_class,
1608: trunc(nvl(s.firm_date, s.new_schedule_date))), 1),*/
1609: DECODE(MIHM.allocation_percent/100, --4365873
1610: /*MSC_AATP_FUNC.Get_DC_Alloc_Percent(
1611: p_instance_id,
1612: s.inventory_item_id,
1613: p_org_id,
1614: null,
1716: decode(d.origination_type,
1717: 6, decode(d.source_organization_id,
1718: NULL, DECODE(D.DEMAND_CLASS, null, null,
1719: DECODE(p_demand_class, '-1',
1720: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1721: null, null, p_item_id, p_org_id,
1722: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1723: D.DEMAND_CLASS)),
1724: -23453, DECODE(D.DEMAND_CLASS, null, null,
1722: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1723: D.DEMAND_CLASS)),
1724: -23453, DECODE(D.DEMAND_CLASS, null, null,
1725: DECODE(p_demand_class, '-1',
1726: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1727: null, null, p_item_id, p_org_id,
1728: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1729: D.DEMAND_CLASS)),
1730: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1728: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1729: D.DEMAND_CLASS)),
1730: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1731: DECODE(p_demand_class, '-1',
1732: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1733: null, null, p_item_id, p_org_id,
1734: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1735: D.DEMAND_CLASS)), TO_CHAR(NULL)),
1736: 30, decode(d.source_organization_id,
1735: D.DEMAND_CLASS)), TO_CHAR(NULL)),
1736: 30, decode(d.source_organization_id,
1737: NULL, DECODE(D.DEMAND_CLASS, null, null,
1738: DECODE(p_demand_class, '-1',
1739: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1740: null, null, p_item_id, p_org_id,
1741: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1742: D.DEMAND_CLASS)),
1743: -23453, DECODE(D.DEMAND_CLASS, null, null,
1741: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1742: D.DEMAND_CLASS)),
1743: -23453, DECODE(D.DEMAND_CLASS, null, null,
1744: DECODE(p_demand_class, '-1',
1745: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1746: null, null, p_item_id, p_org_id,
1747: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1748: D.DEMAND_CLASS)),
1749: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1747: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1748: D.DEMAND_CLASS)),
1749: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1750: DECODE(p_demand_class, '-1',
1751: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1752: null, null, p_item_id, p_org_id,
1753: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1754: D.DEMAND_CLASS)), TO_CHAR(NULL)),
1755: DECODE(D.DEMAND_CLASS, null, null,
1753: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1754: D.DEMAND_CLASS)), TO_CHAR(NULL)),
1755: DECODE(D.DEMAND_CLASS, null, null,
1756: DECODE(p_demand_class, '-1',
1757: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1758: null, null, p_item_id, p_org_id,
1759: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1760: D.DEMAND_CLASS))),
1761: DECODE(D.DEMAND_CLASS, null, null, --10425563
1759: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1760: D.DEMAND_CLASS))),
1761: DECODE(D.DEMAND_CLASS, null, null, --10425563
1762: DECODE(p_demand_class, '-1',
1763: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1764: null, null, p_item_id, p_org_id,
1765: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1766: D.DEMAND_CLASS))),
1767: -- rajjain end
1770: -- rajjain begin 07/19/2002
1771: decode(MSC_ATP_PVT.G_INTERNAL_SALES_ORDER,'N', --10425563
1772: decode(d.origination_type,
1773: 6, decode(d.source_organization_id,
1774: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1775: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1776: p_org_id, p_instance_id, c.calendar_date,
1777: p_level_id, NULL),
1778: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1774: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1775: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1776: p_org_id, p_instance_id, c.calendar_date,
1777: p_level_id, NULL),
1778: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1779: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1780: p_org_id, p_instance_id, c.calendar_date,
1781: p_level_id, NULL),
1782: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1778: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1779: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1780: p_org_id, p_instance_id, c.calendar_date,
1781: p_level_id, NULL),
1782: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1783: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1784: p_org_id, p_instance_id, c.calendar_date,
1785: p_level_id, NULL),
1786: TO_CHAR(NULL)),
1784: p_org_id, p_instance_id, c.calendar_date,
1785: p_level_id, NULL),
1786: TO_CHAR(NULL)),
1787: 30, decode(d.source_organization_id,
1788: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1789: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1790: p_org_id, p_instance_id, c.calendar_date,
1791: p_level_id, NULL),
1792: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1788: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1789: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1790: p_org_id, p_instance_id, c.calendar_date,
1791: p_level_id, NULL),
1792: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1793: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1794: p_org_id, p_instance_id, c.calendar_date,
1795: p_level_id, NULL),
1796: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1792: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1793: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1794: p_org_id, p_instance_id, c.calendar_date,
1795: p_level_id, NULL),
1796: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1797: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1798: p_org_id, p_instance_id, c.calendar_date,
1799: p_level_id, NULL),
1800: TO_CHAR(NULL)),
1797: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1798: p_org_id, p_instance_id, c.calendar_date,
1799: p_level_id, NULL),
1800: TO_CHAR(NULL)),
1801: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, --10425563
1802: p_item_id, p_org_id, p_instance_id,
1803: c.calendar_date,p_level_id, NULL)),
1804: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
1805: p_item_id, p_org_id, p_instance_id,
1800: TO_CHAR(NULL)),
1801: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, --10425563
1802: p_item_id, p_org_id, p_instance_id,
1803: c.calendar_date,p_level_id, NULL)),
1804: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
1805: p_item_id, p_org_id, p_instance_id,
1806: c.calendar_date,p_level_id, NULL)))),
1807: -- rajjain end 07/19/2002
1808: p_demand_class, 1,
1806: c.calendar_date,p_level_id, NULL)))),
1807: -- rajjain end 07/19/2002
1808: p_demand_class, 1,
1809: Decode(D.Demand_Class, NULL, --4365873
1810: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,
1811: D.DEMAND_ID,
1812: c.calendar_date,
1813: D.USING_ASSEMBLY_ITEM_ID,
1814: DECODE(D.SOURCE_ORGANIZATION_ID,
1834: decode(d.origination_type,
1835: 6, decode(d.source_organization_id,
1836: NULL, DECODE(D.DEMAND_CLASS, null, null,
1837: DECODE(p_demand_class, '-1',
1838: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1839: null, null, p_item_id, p_org_id,
1840: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1841: D.DEMAND_CLASS)),
1842: -23453, DECODE(D.DEMAND_CLASS, null, null,
1840: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1841: D.DEMAND_CLASS)),
1842: -23453, DECODE(D.DEMAND_CLASS, null, null,
1843: DECODE(p_demand_class, '-1',
1844: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1845: null, null, p_item_id, p_org_id,
1846: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1847: D.DEMAND_CLASS)),
1848: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1846: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1847: D.DEMAND_CLASS)),
1848: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1849: DECODE(p_demand_class, '-1',
1850: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1851: null, null, p_item_id, p_org_id,
1852: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1853: D.DEMAND_CLASS)),
1854: p_demand_class),
1854: p_demand_class),
1855: 30, decode(d.source_organization_id,
1856: NULL, DECODE(D.DEMAND_CLASS, null, null,
1857: DECODE(p_demand_class, '-1',
1858: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1859: null, null, p_item_id, p_org_id,
1860: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1861: D.DEMAND_CLASS)),
1862: -23453, DECODE(D.DEMAND_CLASS, null, null,
1860: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1861: D.DEMAND_CLASS)),
1862: -23453, DECODE(D.DEMAND_CLASS, null, null,
1863: DECODE(p_demand_class, '-1',
1864: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1865: null, null, p_item_id, p_org_id,
1866: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1867: D.DEMAND_CLASS)),
1868: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1866: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1867: D.DEMAND_CLASS)),
1868: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1869: DECODE(p_demand_class, '-1',
1870: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1871: null, null, p_item_id, p_org_id,
1872: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1873: D.DEMAND_CLASS)),
1874: p_demand_class),
1873: D.DEMAND_CLASS)),
1874: p_demand_class),
1875: DECODE(D.DEMAND_CLASS, null, null,
1876: DECODE(p_demand_class, '-1',
1877: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1878: null, null, p_item_id, p_org_id,
1879: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1880: D.DEMAND_CLASS))),
1881: DECODE(D.DEMAND_CLASS, null, null, --10425563
1879: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1880: D.DEMAND_CLASS))),
1881: DECODE(D.DEMAND_CLASS, null, null, --10425563
1882: DECODE(p_demand_class, '-1',
1883: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1884: null, null, p_item_id, p_org_id,
1885: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1886: D.DEMAND_CLASS))),
1887: -- rajjain end
1890: -- rajjain begin 07/19/2002
1891: decode(MSC_ATP_PVT.G_INTERNAL_SALES_ORDER,'N', --10425563
1892: decode(d.origination_type,
1893: 6, decode(d.source_organization_id,
1894: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1895: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1896: p_org_id, p_instance_id, c.calendar_date,
1897: p_level_id, NULL),
1898: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1894: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1895: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1896: p_org_id, p_instance_id, c.calendar_date,
1897: p_level_id, NULL),
1898: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1899: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1900: p_org_id, p_instance_id, c.calendar_date,
1901: p_level_id, NULL),
1902: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1898: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1899: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1900: p_org_id, p_instance_id, c.calendar_date,
1901: p_level_id, NULL),
1902: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1903: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1904: p_org_id, p_instance_id, c.calendar_date,
1905: p_level_id, NULL),
1906: p_demand_class),
1904: p_org_id, p_instance_id, c.calendar_date,
1905: p_level_id, NULL),
1906: p_demand_class),
1907: 30, decode(d.source_organization_id,
1908: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1909: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1910: p_org_id, p_instance_id, c.calendar_date,
1911: p_level_id, NULL),
1912: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1908: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1909: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1910: p_org_id, p_instance_id, c.calendar_date,
1911: p_level_id, NULL),
1912: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1913: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1914: p_org_id, p_instance_id, c.calendar_date,
1915: p_level_id, NULL),
1916: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1912: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1913: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1914: p_org_id, p_instance_id, c.calendar_date,
1915: p_level_id, NULL),
1916: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1917: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1918: p_org_id, p_instance_id, c.calendar_date,
1919: p_level_id, NULL),
1920: p_demand_class),
1917: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1918: p_org_id, p_instance_id, c.calendar_date,
1919: p_level_id, NULL),
1920: p_demand_class),
1921: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
1922: p_item_id, p_org_id, p_instance_id,
1923: c.calendar_date,p_level_id, NULL)),
1924: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, --10425563
1925: p_item_id, p_org_id, p_instance_id,
1920: p_demand_class),
1921: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
1922: p_item_id, p_org_id, p_instance_id,
1923: c.calendar_date,p_level_id, NULL)),
1924: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, --10425563
1925: p_item_id, p_org_id, p_instance_id,
1926: c.calendar_date,p_level_id, NULL))
1927: )),
1928: -- rajjain end 07/19/2002
1972: --2424357: Convert the demand calls in case of others for
1973: --- demand class allocated ATP
1974: 1, DECODE(CS.DEMAND_CLASS, null, null,
1975: DECODE(p_demand_class, '-1',
1976: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1977: null,
1978: null,
1979: cs.inventory_item_id,
1980: p_org_id,
1983: p_level_id,
1984: CS.DEMAND_CLASS),CS.DEMAND_CLASS)),
1985: 2, DECODE(CS.CUSTOMER_ID, NULL, TO_CHAR(NULL),
1986: 0, TO_CHAR(NULL),
1987: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1988: CS.CUSTOMER_ID,
1989: CS.SHIP_TO_SITE_ID,
1990: cs.inventory_item_id,
1991: p_org_id,
1994: p_level_id,
1995: NULL))),
1996: p_demand_class, 1,
1997: NULL, nvl(MIHM.allocation_percent/100,1), --4365873
1998: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
1999: p_instance_id,
2000: s.inventory_item_id,
2001: p_org_id,
2002: null,
2004: p_demand_class,
2005: c.calendar_date), 1),*/
2006: DECODE(
2007: MIHM.allocation_percent/100, --4365873
2008: /*MSC_AATP_FUNC.Get_DC_Alloc_Percent(
2009: p_instance_id,
2010: s.inventory_item_id,
2011: p_org_id,
2012: null,
2178: decode(d.origination_type,
2179: 6, decode(d.source_organization_id,
2180: NULL, DECODE(D.DEMAND_CLASS, null, null,
2181: DECODE(p_demand_class, '-1',
2182: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2183: null, null, p_item_id, p_org_id,
2184: p_instance_id, trunc(DECODE(RECORD_SOURCE,
2185: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2186: -- Bug 3550296 and 3574164. IMPLEMENT_DATE AND DMD_SATISFIED_DATE are changed to
2190: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2191: D.DEMAND_CLASS)),
2192: -23453, DECODE(D.DEMAND_CLASS, null, null,
2193: DECODE(p_demand_class, '-1',
2194: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2195: null, null, p_item_id, p_org_id,
2196: p_instance_id, trunc(DECODE(RECORD_SOURCE,
2197: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2198: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2200: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2201: D.DEMAND_CLASS)),
2202: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2203: DECODE(p_demand_class, '-1',
2204: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2205: null, null, p_item_id, p_org_id,
2206: p_instance_id, trunc(DECODE(RECORD_SOURCE,
2207: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2208: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2211: D.DEMAND_CLASS)), NULL),
2212: 30, decode(d.source_organization_id,
2213: NULL, DECODE(D.DEMAND_CLASS, null, null,
2214: DECODE(p_demand_class, '-1',
2215: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2216: null, null, p_item_id, p_org_id,
2217: p_instance_id, trunc(DECODE(RECORD_SOURCE,
2218: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2219: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2221: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2222: D.DEMAND_CLASS)),
2223: -23453, DECODE(D.DEMAND_CLASS, null, null,
2224: DECODE(p_demand_class, '-1',
2225: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2226: null, null, p_item_id, p_org_id,
2227: p_instance_id, trunc(DECODE(RECORD_SOURCE,
2228: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2229: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2231: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2232: D.DEMAND_CLASS)),
2233: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2234: DECODE(p_demand_class, '-1',
2235: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2236: null, null, p_item_id, p_org_id,
2237: p_instance_id, trunc(DECODE(RECORD_SOURCE,
2238: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2239: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2241: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2242: D.DEMAND_CLASS)), NULL),
2243: DECODE(D.DEMAND_CLASS, null, null,
2244: DECODE(p_demand_class, '-1',
2245: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2246: null, null, p_item_id, p_org_id,
2247: p_instance_id, trunc(DECODE(RECORD_SOURCE,
2248: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2249: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2251: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2252: D.DEMAND_CLASS))),
2253: DECODE(D.DEMAND_CLASS, null, null, --10425563
2254: DECODE(p_demand_class, '-1',
2255: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2256: null, null, p_item_id, p_org_id,
2257: p_instance_id, trunc(DECODE(RECORD_SOURCE,
2258: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2259: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2266: -- rajjain begin 07/19/2002
2267: decode(MSC_ATP_PVT.G_INTERNAL_SALES_ORDER,'N', --10425563
2268: decode(d.origination_type,
2269: 6, decode(d.source_organization_id,
2270: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2271: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2272: p_org_id, p_instance_id, trunc(DECODE(RECORD_SOURCE,
2273: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2274: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2274: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2275: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2276: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2277: p_level_id, NULL),
2278: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2279: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2280: p_org_id, p_instance_id, trunc(DECODE(RECORD_SOURCE,
2281: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2282: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2282: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2283: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2284: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2285: p_level_id, NULL),
2286: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2287: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2288: p_org_id, p_instance_id, trunc(DECODE(RECORD_SOURCE,
2289: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2290: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2292: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2293: p_level_id, NULL),
2294: NULL),
2295: 30, decode(d.source_organization_id,
2296: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2297: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2298: p_org_id, p_instance_id, trunc(DECODE(RECORD_SOURCE,
2299: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2300: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2300: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2301: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2302: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2303: p_level_id, NULL),
2304: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2305: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2306: p_org_id, p_instance_id, trunc(DECODE(RECORD_SOURCE,
2307: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2308: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2308: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2309: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2310: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2311: p_level_id, NULL),
2312: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2313: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2314: p_org_id, p_instance_id, trunc(DECODE(RECORD_SOURCE,
2315: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2316: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2317: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2318: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2319: p_level_id, NULL),
2320: NULL),
2321: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
2322: p_item_id, p_org_id, p_instance_id,
2323: trunc(DECODE(RECORD_SOURCE,
2324: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2325: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2324: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2325: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2326: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2327: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),p_level_id, NULL)),
2328: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, --10425563
2329: p_item_id, p_org_id, p_instance_id,
2330: trunc(DECODE(RECORD_SOURCE,
2331: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2332: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2335: )),
2336: -- rajjain end 07/19/2002
2337: p_demand_class, 1,
2338: Decode(D.Demand_Class, NULL, --4365873
2339: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,
2340: D.DEMAND_ID,
2341: trunc(DECODE(RECORD_SOURCE,
2342: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2343: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2367: decode(d.origination_type,
2368: 6, decode(d.source_organization_id,
2369: NULL, DECODE(D.DEMAND_CLASS, null, null,
2370: DECODE(p_demand_class, '-1',
2371: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2372: null, null, p_item_id, p_org_id,
2373: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2374: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2375: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2377: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2378: D.DEMAND_CLASS)),
2379: -23453, DECODE(D.DEMAND_CLASS, null, null,
2380: DECODE(p_demand_class, '-1',
2381: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2382: null, null, p_item_id, p_org_id,
2383: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2384: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2385: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2387: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2388: D.DEMAND_CLASS)),
2389: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2390: DECODE(p_demand_class, '-1',
2391: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2392: null, null, p_item_id, p_org_id,
2393: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2394: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2395: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2399: p_demand_class),
2400: 30, decode(d.source_organization_id,
2401: NULL, DECODE(D.DEMAND_CLASS, null, null,
2402: DECODE(p_demand_class, '-1',
2403: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2404: null, null, p_item_id, p_org_id,
2405: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2406: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2407: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2409: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2410: D.DEMAND_CLASS)),
2411: -23453, DECODE(D.DEMAND_CLASS, null, null,
2412: DECODE(p_demand_class, '-1',
2413: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2414: null, null, p_item_id, p_org_id,
2415: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2416: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2417: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2419: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2420: D.DEMAND_CLASS)),
2421: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2422: DECODE(p_demand_class, '-1',
2423: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2424: null, null, p_item_id, p_org_id,
2425: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2426: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2427: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2430: D.DEMAND_CLASS)),
2431: p_demand_class),
2432: DECODE(D.DEMAND_CLASS, null, null,
2433: DECODE(p_demand_class, '-1',
2434: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2435: null, null, p_item_id, p_org_id,
2436: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2437: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2438: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2440: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2441: D.DEMAND_CLASS))),
2442: DECODE(D.DEMAND_CLASS, null, null, --10425563
2443: DECODE(p_demand_class, '-1',
2444: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2445: null, null, p_item_id, p_org_id,
2446: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2447: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2448: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2455: -- rajjain begin 07/19/2002
2456: decode(MSC_ATP_PVT.G_INTERNAL_SALES_ORDER,'N', --10425563
2457: decode(d.origination_type,
2458: 6, decode(d.source_organization_id,
2459: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2460: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2461: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2462: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2463: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2463: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2464: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2465: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2466: p_level_id, NULL),
2467: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2468: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2469: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2470: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2471: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2471: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2472: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2473: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2474: p_level_id, NULL),
2475: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2476: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2477: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2478: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2479: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2481: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2482: p_level_id, NULL),
2483: p_demand_class),
2484: 30, decode(d.source_organization_id,
2485: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2486: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2487: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2488: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2489: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2489: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2490: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2491: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2492: p_level_id, NULL),
2493: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2494: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2495: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2496: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2497: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2497: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2498: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2499: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2500: p_level_id, NULL),
2501: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2502: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2503: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2504: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2505: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2506: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2507: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2508: p_level_id, NULL),
2509: p_demand_class),
2510: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
2511: p_item_id, p_org_id, p_instance_id,
2512: TRUNC(DECODE(RECORD_SOURCE,
2513: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2514: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2513: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2514: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2515: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2516: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),p_level_id, NULL)),
2517: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, --10425563
2518: p_item_id, p_org_id, p_instance_id,
2519: TRUNC(DECODE(RECORD_SOURCE,
2520: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2521: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2629: DECODE(DECODE(G_HIERARCHY_PROFILE,
2630: --2424357
2631: 1, DECODE(S.DEMAND_CLASS, null, null,
2632: DECODE(p_demand_class,'-1',
2633: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2634: null,
2635: null,
2636: S.inventory_item_id,
2637: p_org_id,
2640: p_level_id,
2641: S.DEMAND_CLASS), S.DEMAND_CLASS)),
2642: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
2643: --0, TO_CHAR(NULL),
2644: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2645: S.CUSTOMER_ID,
2646: S.SHIP_TO_SITE_ID,
2647: S.inventory_item_id,
2648: p_org_id,
2651: p_level_id,
2652: NULL))),
2653: p_demand_class, 1,
2654: NULL, NVL(MIHM.allocation_percent/100,--4365873
2655: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
2656: p_instance_id,
2657: s.inventory_item_id,
2658: p_org_id,
2659: null,
2661: p_demand_class,
2662: TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE))),*/
2663: 1),
2664: DECODE(MIHM.allocation_percent/100, --4365873
2665: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
2666: p_instance_id,
2667: s.inventory_item_id,
2668: p_org_id,
2669: null,
2849: decode(d.origination_type,
2850: 6, decode(d.source_organization_id,
2851: NULL, DECODE(D.DEMAND_CLASS, null, null,
2852: DECODE(p_demand_class, '-1',
2853: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2854: null, null, p_item_id, p_org_id,
2855: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2856: D.DEMAND_CLASS)),
2857: -23453, DECODE(D.DEMAND_CLASS, null, null,
2855: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2856: D.DEMAND_CLASS)),
2857: -23453, DECODE(D.DEMAND_CLASS, null, null,
2858: DECODE(p_demand_class, '-1',
2859: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2860: null, null, p_item_id, p_org_id,
2861: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2862: D.DEMAND_CLASS)),
2863: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2861: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2862: D.DEMAND_CLASS)),
2863: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2864: DECODE(p_demand_class, '-1',
2865: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2866: null, null, p_item_id, p_org_id,
2867: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2868: D.DEMAND_CLASS)), NULL),
2869: 30, decode(d.source_organization_id,
2868: D.DEMAND_CLASS)), NULL),
2869: 30, decode(d.source_organization_id,
2870: NULL, DECODE(D.DEMAND_CLASS, null, null,
2871: DECODE(p_demand_class, '-1',
2872: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2873: null, null, p_item_id, p_org_id,
2874: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2875: D.DEMAND_CLASS)),
2876: -23453, DECODE(D.DEMAND_CLASS, null, null,
2874: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2875: D.DEMAND_CLASS)),
2876: -23453, DECODE(D.DEMAND_CLASS, null, null,
2877: DECODE(p_demand_class, '-1',
2878: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2879: null, null, p_item_id, p_org_id,
2880: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2881: D.DEMAND_CLASS)),
2882: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2880: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2881: D.DEMAND_CLASS)),
2882: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2883: DECODE(p_demand_class, '-1',
2884: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2885: null, null, p_item_id, p_org_id,
2886: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2887: D.DEMAND_CLASS)), NULL),
2888: DECODE(D.DEMAND_CLASS, null, null,
2886: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2887: D.DEMAND_CLASS)), NULL),
2888: DECODE(D.DEMAND_CLASS, null, null,
2889: DECODE(p_demand_class, '-1',
2890: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2891: null, null, p_item_id, p_org_id,
2892: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2893: D.DEMAND_CLASS))),
2894: DECODE(D.DEMAND_CLASS, null, null, --10425563
2892: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2893: D.DEMAND_CLASS))),
2894: DECODE(D.DEMAND_CLASS, null, null, --10425563
2895: DECODE(p_demand_class, '-1',
2896: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2897: null, null, p_item_id, p_org_id,
2898: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2899: D.DEMAND_CLASS))),
2900: -- rajjain end
2903: -- rajjain begin 07/19/2002
2904: decode(MSC_ATP_PVT.G_INTERNAL_SALES_ORDER,'N', --10425563
2905: decode(d.origination_type,
2906: 6, decode(d.source_organization_id,
2907: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2908: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2909: p_org_id, p_instance_id, c.calendar_date,
2910: p_level_id, NULL),
2911: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2907: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2908: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2909: p_org_id, p_instance_id, c.calendar_date,
2910: p_level_id, NULL),
2911: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2912: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2913: p_org_id, p_instance_id, c.calendar_date,
2914: p_level_id, NULL),
2915: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2911: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2912: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2913: p_org_id, p_instance_id, c.calendar_date,
2914: p_level_id, NULL),
2915: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2916: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2917: p_org_id, p_instance_id, c.calendar_date,
2918: p_level_id, NULL),
2919: NULL),
2917: p_org_id, p_instance_id, c.calendar_date,
2918: p_level_id, NULL),
2919: NULL),
2920: 30, decode(d.source_organization_id,
2921: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2922: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2923: p_org_id, p_instance_id, c.calendar_date,
2924: p_level_id, NULL),
2925: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2921: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2922: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2923: p_org_id, p_instance_id, c.calendar_date,
2924: p_level_id, NULL),
2925: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2926: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2927: p_org_id, p_instance_id, c.calendar_date,
2928: p_level_id, NULL),
2929: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2925: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2926: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2927: p_org_id, p_instance_id, c.calendar_date,
2928: p_level_id, NULL),
2929: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2930: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2931: p_org_id, p_instance_id, c.calendar_date,
2932: p_level_id, NULL),
2933: NULL),
2930: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2931: p_org_id, p_instance_id, c.calendar_date,
2932: p_level_id, NULL),
2933: NULL),
2934: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
2935: p_item_id, p_org_id, p_instance_id,
2936: c.calendar_date,p_level_id, NULL)),
2937: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, --10425563
2938: p_item_id, p_org_id, p_instance_id,
2933: NULL),
2934: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
2935: p_item_id, p_org_id, p_instance_id,
2936: c.calendar_date,p_level_id, NULL)),
2937: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, --10425563
2938: p_item_id, p_org_id, p_instance_id,
2939: c.calendar_date,p_level_id, NULL))
2940: )),
2941: -- rajjain end 07/19/2002
2940: )),
2941: -- rajjain end 07/19/2002
2942: p_demand_class, 1,
2943: Decode(D.Demand_Class, NULL, --4365873
2944: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,
2945: D.DEMAND_ID,
2946: c.calendar_date,
2947: D.USING_ASSEMBLY_ITEM_ID,
2948: DECODE(D.SOURCE_ORGANIZATION_ID,
2968: decode(d.origination_type,
2969: 6, decode(d.source_organization_id,
2970: NULL, DECODE(D.DEMAND_CLASS, null, null,
2971: DECODE(p_demand_class, '-1',
2972: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2973: null, null, p_item_id, p_org_id,
2974: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2975: D.DEMAND_CLASS)),
2976: -23453, DECODE(D.DEMAND_CLASS, null, null,
2974: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2975: D.DEMAND_CLASS)),
2976: -23453, DECODE(D.DEMAND_CLASS, null, null,
2977: DECODE(p_demand_class, '-1',
2978: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2979: null, null, p_item_id, p_org_id,
2980: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2981: D.DEMAND_CLASS)),
2982: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2980: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2981: D.DEMAND_CLASS)),
2982: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2983: DECODE(p_demand_class, '-1',
2984: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2985: null, null, p_item_id, p_org_id,
2986: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2987: D.DEMAND_CLASS)),
2988: p_demand_class),
2988: p_demand_class),
2989: 30, decode(d.source_organization_id,
2990: NULL, DECODE(D.DEMAND_CLASS, null, null,
2991: DECODE(p_demand_class, '-1',
2992: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2993: null, null, p_item_id, p_org_id,
2994: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2995: D.DEMAND_CLASS)),
2996: -23453, DECODE(D.DEMAND_CLASS, null, null,
2994: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2995: D.DEMAND_CLASS)),
2996: -23453, DECODE(D.DEMAND_CLASS, null, null,
2997: DECODE(p_demand_class, '-1',
2998: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2999: null, null, p_item_id, p_org_id,
3000: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
3001: D.DEMAND_CLASS)),
3002: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
3000: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
3001: D.DEMAND_CLASS)),
3002: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
3003: DECODE(p_demand_class, '-1',
3004: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3005: null, null, p_item_id, p_org_id,
3006: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
3007: D.DEMAND_CLASS)),
3008: p_demand_class),
3007: D.DEMAND_CLASS)),
3008: p_demand_class),
3009: DECODE(D.DEMAND_CLASS, null, null,
3010: DECODE(p_demand_class, '-1',
3011: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3012: null, null, p_item_id, p_org_id,
3013: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
3014: D.DEMAND_CLASS))),
3015: DECODE(D.DEMAND_CLASS, null, null,
3013: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
3014: D.DEMAND_CLASS))),
3015: DECODE(D.DEMAND_CLASS, null, null,
3016: DECODE(p_demand_class, '-1',
3017: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3018: null, null, p_item_id, p_org_id,
3019: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
3020: D.DEMAND_CLASS))),
3021: -- rajjain end
3024: -- rajjain begin 07/19/2002
3025: decode(MSC_ATP_PVT.G_INTERNAL_SALES_ORDER,'N',
3026: decode(d.origination_type,
3027: 6, decode(d.source_organization_id,
3028: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3029: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
3030: p_org_id, p_instance_id, c.calendar_date,
3031: p_level_id, NULL),
3032: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3028: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3029: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
3030: p_org_id, p_instance_id, c.calendar_date,
3031: p_level_id, NULL),
3032: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3033: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
3034: p_org_id, p_instance_id, c.calendar_date,
3035: p_level_id, NULL),
3036: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3032: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3033: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
3034: p_org_id, p_instance_id, c.calendar_date,
3035: p_level_id, NULL),
3036: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3037: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
3038: p_org_id, p_instance_id, c.calendar_date,
3039: p_level_id, NULL),
3040: p_demand_class),
3038: p_org_id, p_instance_id, c.calendar_date,
3039: p_level_id, NULL),
3040: p_demand_class),
3041: 30, decode(d.source_organization_id,
3042: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3043: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
3044: p_org_id, p_instance_id, c.calendar_date,
3045: p_level_id, NULL),
3046: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3042: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3043: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
3044: p_org_id, p_instance_id, c.calendar_date,
3045: p_level_id, NULL),
3046: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3047: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
3048: p_org_id, p_instance_id, c.calendar_date,
3049: p_level_id, NULL),
3050: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3046: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3047: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
3048: p_org_id, p_instance_id, c.calendar_date,
3049: p_level_id, NULL),
3050: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3051: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
3052: p_org_id, p_instance_id, c.calendar_date,
3053: p_level_id, NULL),
3054: p_demand_class),
3051: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
3052: p_org_id, p_instance_id, c.calendar_date,
3053: p_level_id, NULL),
3054: p_demand_class),
3055: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
3056: p_item_id, p_org_id, p_instance_id,
3057: c.calendar_date,p_level_id, NULL)),
3058: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
3059: p_item_id, p_org_id, p_instance_id,
3054: p_demand_class),
3055: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
3056: p_item_id, p_org_id, p_instance_id,
3057: c.calendar_date,p_level_id, NULL)),
3058: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
3059: p_item_id, p_org_id, p_instance_id,
3060: c.calendar_date,p_level_id, NULL)) --10425563
3061: )),
3062: -- rajjain end 07/19/2002
3168: DECODE(DECODE(G_HIERARCHY_PROFILE,
3169: --2424357
3170: 1, DECODE(CS.DEMAND_CLASS, null, null,
3171: DECODE(p_demand_class,'-1',
3172: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3173: null,
3174: null,
3175: cs.inventory_item_id,
3176: p_org_id,
3179: p_level_id,
3180: CS.DEMAND_CLASS), CS.DEMAND_CLASS)),
3181: 2, DECODE(CS.CUSTOMER_ID, NULL, TO_CHAR(NULL),
3182: --0, TO_CHAR(NULL),
3183: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3184: CS.CUSTOMER_ID,
3185: CS.SHIP_TO_SITE_ID,
3186: cs.inventory_item_id,
3187: p_org_id,
3190: p_level_id,
3191: NULL))),
3192: p_demand_class, 1,
3193: NULL, nvl(MIHM.allocation_percent/100,1), --4365873
3194: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
3195: p_instance_id,
3196: cs.inventory_item_id,
3197: p_org_id,
3198: null,
3200: p_demand_class,
3201: cs.calendar_date), 1),*/
3202: DECODE(
3203: MIHM.allocation_percent/100, --4365873
3204: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
3205: p_instance_id,
3206: cs.inventory_item_id,
3207: p_org_id,
3208: null,
6112: DECODE(DECODE(G_HIERARCHY_PROFILE,
6113: --bug 2424357
6114: 1, DECODE(S.DEMAND_CLASS, null, null,
6115: DECODE(l_demand_class, '-1',
6116: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
6117: null,
6118: null,
6119: p_department_id,
6120: p_resource_id,
6132: l_level_id,
6133: S.DEMAND_CLASS), S.DEMAND_CLASS)),
6134: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
6135: 0, TO_CHAR(NULL),
6136: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6137: S.CUSTOMER_ID,
6138: S.SHIP_TO_SITE_ID,
6139: s.inventory_item_id,
6140: p_organization_id,
6153: l_demand_class, 1,
6154: --bug 4089293: If l_demand_class is not null and demand class is populated
6155: -- on supplies record then 0 should be allocated.
6156: Decode (S.Demand_Class, NULL,
6157: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(
6158: -- 2859130 C.CALENDAR_DATE,
6159: -- Bug 3348095
6160: -- For ATP created records use end_date
6161: -- otherwise start_date
6172: DECODE(G_HIERARCHY_PROFILE,
6173: --2424357
6174: 1, DECODE(S.DEMAND_CLASS, null, null,
6175: DECODE(l_demand_class, -1,
6176: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
6177: null,
6178: null,
6179: p_department_id,
6180: p_resource_id,
6192: l_level_id,
6193: S.DEMAND_CLASS), S.DEMAND_CLASS)),
6194: 2, DECODE(S.CUSTOMER_ID, NULL, l_demand_class,
6195: 0, l_demand_class,
6196: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6197: S.CUSTOMER_ID,
6198: S.SHIP_TO_SITE_ID,
6199: l_inv_item_id,
6200: p_organization_id,
6263: MNRA.to_time,MNRA.to_time + 24*3600,
6264: MNRA.to_time) - MNRA.from_time)/3600) *
6265: NVL((MRHM.allocation_percent/100), 1)
6266: /*
6267: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
6268: p_instance_id,
6269: null,
6270: p_organization_id,
6271: p_department_id,
6326: DECODE(DECODE(G_HIERARCHY_PROFILE,
6327: --bug 2424357
6328: 1, DECODE(S.DEMAND_CLASS, null, null,
6329: DECODE(l_demand_class, '-1',
6330: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
6331: null,
6332: null,
6333: p_department_id,
6334: p_resource_id,
6338: l_level_id,
6339: S.DEMAND_CLASS), S.DEMAND_CLASS)),
6340: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
6341: 0, TO_CHAR(NULL),
6342: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6343: S.CUSTOMER_ID,
6344: S.SHIP_TO_SITE_ID,
6345: s.inventory_item_id,
6346: p_organization_id,
6351: l_demand_class, 1,
6352: --bug 4156016: If l_demand_class is not null and demand class is populated
6353: -- on supplies record then 0 should be allocated.
6354: Decode (S.Demand_Class, NULL,
6355: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(C.CALENDAR_DATE,
6356: REQ.ASSEMBLY_ITEM_ID,
6357: p_organization_id,
6358: p_instance_id,
6359: p_department_id,
6361: DECODE(G_HIERARCHY_PROFILE,
6362: --2424357
6363: 1, DECODE(S.DEMAND_CLASS, null, null,
6364: DECODE(l_demand_class, -1,
6365: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
6366: null,
6367: null,
6368: p_department_id,
6369: p_resource_id,
6373: l_level_id,
6374: S.DEMAND_CLASS), S.DEMAND_CLASS)),
6375: 2, DECODE(S.CUSTOMER_ID, NULL, l_demand_class,
6376: 0, l_demand_class,
6377: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6378: S.CUSTOMER_ID,
6379: S.SHIP_TO_SITE_ID,
6380: l_inv_item_id,
6381: p_organization_id,
6441: MNRA.to_time,MNRA.to_time + 24*3600,
6442: MNRA.to_time) - MNRA.from_time)/3600) *
6443: NVL((MRHM.allocation_percent/100), 1)
6444: /*
6445: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
6446: p_instance_id,
6447: null,
6448: p_organization_id,
6449: p_department_id,
6506: DECODE(DECODE(G_HIERARCHY_PROFILE,
6507: --2424357
6508: 1, DECODE(S.DEMAND_CLASS, null, null,
6509: DECODE(l_demand_class, '-1',
6510: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
6511: null,
6512: null,
6513: p_department_id,
6514: p_resource_id,
6526: l_level_id,
6527: S.DEMAND_CLASS),S.DEMAND_CLASS)),
6528: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
6529: 0, TO_CHAR(NULL),
6530: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6531: S.CUSTOMER_ID,
6532: S.SHIP_TO_SITE_ID,
6533: s.inventory_item_id,
6534: p_organization_id,
6547: l_demand_class, 1,
6548: --bug 4156016: If l_demand_class is not null and demand class is populated
6549: -- on supplies record then 0 should be allocated.
6550: Decode (S.Demand_Class, NULL,
6551: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(
6552: -- 2859130 C.CALENDAR_DATE,
6553: -- Bug 3348095
6554: -- For ATP created records use end_date
6555: -- otherwise start_date
6566: DECODE(G_HIERARCHY_PROFILE,
6567: --2424357
6568: 1, DECODE(S.DEMAND_CLASS, null, null,
6569: DECODE(l_demand_class, '-1',
6570: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
6571: null,
6572: null,
6573: p_department_id,
6574: p_resource_id,
6586: l_level_id,
6587: S.DEMAND_CLASS), S.DEMAND_CLASS)),
6588: 2, DECODE(S.CUSTOMER_ID, NULL, l_demand_class,
6589: 0, l_demand_class,
6590: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6591: S.CUSTOMER_ID,
6592: S.SHIP_TO_SITE_ID,
6593: l_inv_item_id,
6594: p_organization_id,
6654: MNRA.to_time,MNRA.to_time + 24*3600,
6655: MNRA.to_time) - MNRA.from_time)/3600) *
6656: NVL((MRHM.allocation_percent/100), 1)
6657: /*
6658: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
6659: p_instance_id,
6660: null,
6661: p_organization_id,
6662: p_department_id,
6711: DECODE(DECODE(G_HIERARCHY_PROFILE,
6712: --2424357
6713: 1, DECODE(S.DEMAND_CLASS, null, null,
6714: DECODE(l_demand_class, '-1',
6715: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
6716: null,
6717: null,
6718: p_department_id,
6719: p_resource_id,
6723: l_level_id,
6724: S.DEMAND_CLASS),S.DEMAND_CLASS)),
6725: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
6726: 0, TO_CHAR(NULL),
6727: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6728: S.CUSTOMER_ID,
6729: S.SHIP_TO_SITE_ID,
6730: s.inventory_item_id,
6731: p_organization_id,
6736: l_demand_class, 1,
6737: --bug 4156016: If l_demand_class is not null and demand class is populated
6738: -- on supplies record then 0 should be allocated.
6739: Decode (S.Demand_Class, NULL,
6740: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(C.CALENDAR_DATE,
6741: REQ.ASSEMBLY_ITEM_ID,
6742: p_organization_id,
6743: p_instance_id,
6744: p_department_id,
6746: DECODE(G_HIERARCHY_PROFILE,
6747: --2424357
6748: 1, DECODE(S.DEMAND_CLASS, null, null,
6749: DECODE(l_demand_class, '-1',
6750: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
6751: null,
6752: null,
6753: p_department_id,
6754: p_resource_id,
6758: l_level_id,
6759: S.DEMAND_CLASS), S.DEMAND_CLASS)),
6760: 2, DECODE(S.CUSTOMER_ID, NULL, l_demand_class,
6761: 0, l_demand_class,
6762: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6763: S.CUSTOMER_ID,
6764: S.SHIP_TO_SITE_ID,
6765: l_inv_item_id,
6766: p_organization_id,
6823: MNRA.to_time,MNRA.to_time + 24*3600,
6824: MNRA.to_time) - MNRA.from_time)/3600) *
6825: NVL((MRHM.allocation_percent/100), 1)
6826: /*
6827: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
6828: p_instance_id,
6829: null,
6830: p_organization_id,
6831: p_department_id,
6953: DECODE(DECODE(G_HIERARCHY_PROFILE,
6954: --2424357
6955: 1, DECODE(S.DEMAND_CLASS, null, null,
6956: DECODE(l_demand_class, '-1',
6957: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
6958: null,
6959: null,
6960: p_department_id,
6961: p_resource_id,
6973: l_level_id,
6974: S.DEMAND_CLASS), S.DEMAND_CLASS)),
6975: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
6976: 0, TO_CHAR(NULL),
6977: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6978: S.CUSTOMER_ID,
6979: S.SHIP_TO_SITE_ID,
6980: s.inventory_item_id,
6981: p_organization_id,
6994: l_demand_class, 1,
6995: --bug 4156016: If l_demand_class is not null and demand class is populated
6996: -- on supplies record then 0 should be allocated.
6997: Decode (S.Demand_Class, NULL,
6998: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(
6999: -- 2859130 C.CALENDAR_DATE,
7000: -- Bug 3348095
7001: -- For ATP created records use end_date
7002: -- otherwise start_date
7013: DECODE(G_HIERARCHY_PROFILE,
7014: ---2424357
7015: 1, DECODE(S.DEMAND_CLASS, null, null,
7016: DECODE(l_demand_class, '-1',
7017: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
7018: null,
7019: null,
7020: p_department_id,
7021: p_resource_id,
7033: l_level_id,
7034: S.DEMAND_CLASS), S.DEMAND_CLASS)),
7035: 2, DECODE(S.CUSTOMER_ID, NULL, l_demand_class,
7036: 0, l_demand_class,
7037: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7038: S.CUSTOMER_ID,
7039: S.SHIP_TO_SITE_ID,
7040: l_inv_item_id,
7041: p_organization_id,
7159: MNRA.to_time,to_time + 24*3600,
7160: MNRA.to_time) - MNRA.from_time)/3600) *
7161: DECODE(p_scenario_id, -1, 1, NVL((MRHM.allocation_percent/100), 1)) col24,
7162: --bug 4156016
7163: /* NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
7164: p_instance_id,
7165: null,
7166: p_organization_id,
7167: p_department_id,
7290: DECODE(DECODE(G_HIERARCHY_PROFILE,
7291: --2424357
7292: 1, DECODE(S.DEMAND_CLASS, null, null,
7293: DECODE(l_demand_class, '-1',
7294: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
7295: null,
7296: null,
7297: p_department_id,
7298: p_resource_id,
7302: l_level_id,
7303: S.DEMAND_CLASS), S.DEMAND_CLASS)),
7304: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
7305: 0, TO_CHAR(NULL),
7306: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7307: S.CUSTOMER_ID,
7308: S.SHIP_TO_SITE_ID,
7309: s.inventory_item_id,
7310: p_organization_id,
7315: l_demand_class, 1,
7316: --bug 4156016: If l_demand_class is not null and demand class is populated
7317: -- on supplies record then 0 should be allocated.
7318: Decode (S.Demand_Class, NULL,
7319: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(
7320: C.CALENDAR_DATE,
7321: REQ.ASSEMBLY_ITEM_ID,
7322: p_organization_id,
7323: p_instance_id,
7326: DECODE(G_HIERARCHY_PROFILE,
7327: ---2424357
7328: 1, DECODE(S.DEMAND_CLASS, null, null,
7329: DECODE(l_demand_class, '-1',
7330: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
7331: null,
7332: null,
7333: p_department_id,
7334: p_resource_id,
7338: l_level_id,
7339: S.DEMAND_CLASS), S.DEMAND_CLASS)),
7340: 2, DECODE(S.CUSTOMER_ID, NULL, l_demand_class,
7341: 0, l_demand_class,
7342: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7343: S.CUSTOMER_ID,
7344: S.SHIP_TO_SITE_ID,
7345: l_inv_item_id,
7346: p_organization_id,
7454: MNRA.to_time,to_time + 24*3600,
7455: MNRA.to_time) - MNRA.from_time)/3600) *
7456: DECODE(p_scenario_id, -1, 1, NVL((MRHM.allocation_percent/100), 1)) col24,
7457: --bug 4156016
7458: /* NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
7459: p_instance_id,
7460: null,
7461: p_organization_id,
7462: p_department_id,
7583: DECODE(DECODE(G_HIERARCHY_PROFILE,
7584: --2424357
7585: 1, DECODE(S.DEMAND_CLASS, null, null,
7586: DECODE(l_demand_class, '-1',
7587: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
7588: null,
7589: null,
7590: p_department_id,
7591: p_resource_id,
7603: l_level_id,
7604: S.DEMAND_CLASS), S.DEMAND_CLASS)),
7605: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
7606: 0, TO_CHAR(NULL),
7607: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7608: S.CUSTOMER_ID,
7609: S.SHIP_TO_SITE_ID,
7610: s.inventory_item_id,
7611: p_organization_id,
7624: l_demand_class, 1,
7625: --bug 4156016: If l_demand_class is not null and demand class is populated
7626: -- on supplies record then 0 should be allocated.
7627: Decode (S.Demand_Class, NULL,
7628: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(
7629: -- 2859130 C.CALENDAR_DATE,
7630: -- Bug 3348095
7631: -- For ATP created records use end_date
7632: -- otherwise start_date
7643: DECODE(G_HIERARCHY_PROFILE,
7644: --2424357
7645: 1, DECODE(S.DEMAND_CLASS, null, null,
7646: DECODE(l_demand_class, '-1',
7647: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
7648: null,
7649: null,
7650: p_department_id,
7651: p_resource_id,
7663: l_level_id,
7664: S.DEMAND_CLASS), S.DEMAND_CLASS)),
7665: 2, DECODE(S.CUSTOMER_ID, NULL, l_demand_class,
7666: 0, l_demand_class,
7667: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7668: S.CUSTOMER_ID,
7669: S.SHIP_TO_SITE_ID,
7670: l_inv_item_id,
7671: p_organization_id,
7782: MNRA.to_time,to_time + 24*3600,
7783: MNRA.to_time) - MNRA.from_time)/3600) *
7784: DECODE(p_scenario_id, -1, 1, NVL((MRHM.allocation_percent/100), 1)) col24,
7785: --bug 4156016
7786: /* NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
7787: p_instance_id,
7788: null,
7789: p_organization_id,
7790: p_department_id,
7909: DECODE(DECODE(G_HIERARCHY_PROFILE,
7910: --2424357
7911: 1, DECODE(S.DEMAND_CLASS, null, null,
7912: DECODE(l_demand_class, '-1',
7913: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
7914: null,
7915: null,
7916: p_department_id,
7917: p_resource_id,
7921: l_level_id,
7922: S.DEMAND_CLASS), S.DEMAND_CLASS)),
7923: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
7924: 0, TO_CHAR(NULL),
7925: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7926: S.CUSTOMER_ID,
7927: S.SHIP_TO_SITE_ID,
7928: s.inventory_item_id,
7929: p_organization_id,
7934: l_demand_class, 1,
7935: --bug 4156016: If l_demand_class is not null and demand class is populated
7936: -- on supplies record then 0 should be allocated.
7937: Decode (S.Demand_Class, NULL,
7938: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(C.CALENDAR_DATE,
7939: REQ.ASSEMBLY_ITEM_ID,
7940: p_organization_id,
7941: p_instance_id,
7942: p_department_id,
7944: DECODE(G_HIERARCHY_PROFILE,
7945: --2424357
7946: 1, DECODE(S.DEMAND_CLASS, null, null,
7947: DECODE(l_demand_class, '-1',
7948: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
7949: null,
7950: null,
7951: p_department_id,
7952: p_resource_id,
7956: l_level_id,
7957: S.DEMAND_CLASS), S.DEMAND_CLASS)),
7958: 2, DECODE(S.CUSTOMER_ID, NULL, l_demand_class,
7959: 0, l_demand_class,
7960: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7961: S.CUSTOMER_ID,
7962: S.SHIP_TO_SITE_ID,
7963: l_inv_item_id,
7964: p_organization_id,
8065: MNRA.to_time,to_time + 24*3600,
8066: MNRA.to_time) - MNRA.from_time)/3600) *
8067: DECODE(p_scenario_id, -1, 1, NVL((MRHM.allocation_percent/100), 1)) col24,
8068: --bug 4156016
8069: /* NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
8070: p_instance_id,
8071: null,
8072: p_organization_id,
8073: p_department_id,
8996: p_sup_atp_info_rec.instance_id, p_sup_atp_info_rec.plan_id,
8997: l_inv_item_id, p_sup_atp_info_rec.organization_id,
8998: p_sup_atp_info_rec.supplier_id, p_sup_atp_info_rec.supplier_site_id,
8999: cs.seq_num - p_sup_atp_info_rec.sysdate_seq_num),0))*
9000: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(l_instance_id,
9001: s.inventory_item_id,
9002: p_sup_atp_info_rec.organization_id,
9003: null,
9004: null,
9051: DECODE(DECODE(G_HIERARCHY_PROFILE,
9052: --2424357
9053: 1, DECODE(p.DEMAND_CLASS, null, null,
9054: DECODE(l_demand_class, '-1',
9055: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
9056: null,
9057: null,
9058: p.inventory_item_id,
9059: p.organization_id,
9065: l_level_id,
9066: p.DEMAND_CLASS), p.DEMAND_CLASS)),
9067: 2, DECODE(p.CUSTOMER_ID, NULL, TO_CHAR(NULL),
9068: 0, TO_CHAR(NULL),
9069: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
9070: p.CUSTOMER_ID,
9071: p.SHIP_TO_SITE_ID,
9072: p.inventory_item_id,
9073: p.organization_id,
9079: l_level_id,
9080: NULL))),
9081: l_demand_class, 1,
9082: NULL, NVL(MIHM.allocation_percent/100, --4365873
9083: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,
9084: p.inventory_item_id ,
9085: p.organization_id,
9086: null,
9087: null,
9091: p.new_dock_date
9092: ))),*/
9093: 1), --4135752
9094: DECODE(MIHM.allocation_percent/100,
9095: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,
9096: p.inventory_item_id,
9097: p.organization_id,
9098: null,
9099: null,
9156: p_sup_atp_info_rec.instance_id, p_sup_atp_info_rec.plan_id,
9157: p_sup_atp_info_rec.inventory_item_id, p_sup_atp_info_rec.organization_id,
9158: p_sup_atp_info_rec.supplier_id, p_sup_atp_info_rec.supplier_site_id,
9159: cs.seq_num - p_sup_atp_info_rec.sysdate_seq_num),0))*
9160: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(l_instance_id,
9161: s.inventory_item_id,
9162: p_sup_atp_info_rec.organization_id,
9163: null,
9164: null,
9212: DECODE(DECODE(G_HIERARCHY_PROFILE,
9213: --2424357
9214: 1, DECODE(p.DEMAND_CLASS, null, null,
9215: DECODE(l_demand_class, '-1',
9216: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
9217: null,
9218: null,
9219: p.inventory_item_id,
9220: p.organization_id,
9226: l_level_id,
9227: p.DEMAND_CLASS), p.DEMAND_CLASS)),
9228: 2, DECODE(p.CUSTOMER_ID, NULL, TO_CHAR(NULL),
9229: 0, TO_CHAR(NULL),
9230: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
9231: p.CUSTOMER_ID,
9232: p.SHIP_TO_SITE_ID,
9233: p.inventory_item_id,
9234: p.organization_id,
9240: l_level_id,
9241: NULL))),
9242: l_demand_class, 1,
9243: NULL, NVL(MIHM.allocation_percent/100, --4365874
9244: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,
9245: p.inventory_item_id ,
9246: p.organization_id,
9247: null,
9248: null,
9252: p.new_dock_date
9253: ))),*/
9254: 1), --4135752
9255: DECODE(MIHM.allocation_percent/100,
9256: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,
9257: p.inventory_item_id,
9258: p.organization_id,
9259: null,
9260: null,
9373: p_sup_atp_info_rec.supplier_id,
9374: p_sup_atp_info_rec.supplier_site_id,
9375: cs.seq_num - p_sup_atp_info_rec.sysdate_seq_num),0)) *
9376: NVL(MIHM.allocation_percent/100, --4365873
9377: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
9378: l_instance_id,
9379: s.inventory_item_id,
9380: p_sup_atp_info_rec.organization_id,
9381: null,
9474: DECODE(DECODE(G_HIERARCHY_PROFILE,
9475: --2424357
9476: 1, DECODE(p.DEMAND_CLASS, null, null,
9477: DECODE(l_demand_class, '-1',
9478: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
9479: null,
9480: null,
9481: p.inventory_item_id,
9482: p.organization_id,
9488: l_level_id,
9489: p.DEMAND_CLASS), p.DEMAND_CLASS)),
9490: 2, DECODE(p.CUSTOMER_ID, NULL, TO_CHAR(NULL),
9491: 0, TO_CHAR(NULL),
9492: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
9493: p.CUSTOMER_ID,
9494: p.SHIP_TO_SITE_ID,
9495: p.inventory_item_id,
9496: p.organization_id,
9502: l_level_id,
9503: NULL))),
9504: l_demand_class, 1,
9505: NULL, NVL(MIHM.allocation_percent/100, --4365873
9506: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,
9507: p.inventory_item_id ,
9508: p.organization_id,
9509: null,
9510: null,
9514: p.new_dock_date
9515: ))),*/
9516: 1),
9517: DECODE(MIHM.allocation_percent/100,
9518: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,
9519: p.inventory_item_id,
9520: p.organization_id,
9521: null,
9522: null,
9658: p_sup_atp_info_rec.supplier_id,
9659: p_sup_atp_info_rec.supplier_site_id,
9660: cs.seq_num - p_sup_atp_info_rec.sysdate_seq_num),0)) *
9661: NVL(MIHM.allocation_percent/100, --4365873
9662: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
9663: l_instance_id,
9664: cs.inventory_item_id,
9665: p_sup_atp_info_rec.organization_id,
9666: null,
9757: DECODE(DECODE(G_HIERARCHY_PROFILE,
9758: --2424357
9759: 1, DECODE(p.DEMAND_CLASS, null, null,
9760: DECODE(l_demand_class, '-1',
9761: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
9762: null,
9763: null,
9764: p.inventory_item_id,
9765: p.organization_id,
9771: l_level_id,
9772: p.DEMAND_CLASS), p.DEMAND_CLASS)),
9773: 2, DECODE(p.CUSTOMER_ID, NULL, TO_CHAR(NULL),
9774: 0, TO_CHAR(NULL),
9775: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
9776: p.CUSTOMER_ID,
9777: p.SHIP_TO_SITE_ID,
9778: p.inventory_item_id,
9779: p.organization_id,
9785: l_level_id,
9786: NULL))),
9787: l_demand_class, 1,
9788: NULL, NVL(MIHM.allocation_percent/100, --4365873
9789: /*NULL, NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,
9790: p.inventory_item_id ,
9791: p.organization_id,
9792: null,
9793: null,
9797: p.new_dock_date
9798: ))),*/
9799: 1),
9800: DECODE(MIHM.allocation_percent/100,
9801: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,
9802: p.inventory_item_id,
9803: p.organization_id,
9804: null,
9805: null,
10786: 'Get_Hierarchy_Demand_Class for Demand Class');
10787: END IF;
10788: -- Code for Get_Hierarchy_Demand_Class
10789:
10790: l_demand_class := MSC_AATP_FUNC.Get_Hierarchy_Demand_Class
10791: (
10792: NULL, --partner_id
10793: NULL, --partner_site_id
10794: --p_inventory_item_id,