eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_AATP_PVT dependencies on MSC_AATP_FUNC

Line 185: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

181: 1, decode(decode (d.origination_type, -100, 30,d.origination_type),
182: 6, decode(d.source_organization_id,
183: NULL, DECODE(D.DEMAND_CLASS, null, null,
184: DECODE(p_demand_class, '-1',
185: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
186: null, null, p_item_id, p_org_id,
187: p_instance_id, TRUNC(
188: DECODE(RECORD_SOURCE,
189: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 198: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

194: p_level_id, D.DEMAND_CLASS),
195: D.DEMAND_CLASS)),
196: -23453, DECODE(D.DEMAND_CLASS, null, null,
197: DECODE(p_demand_class, '-1',
198: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
199: null, null, p_item_id, p_org_id,
200: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
201: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
202: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 209: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

205: p_level_id, D.DEMAND_CLASS), --plan by request date,promise date, schedule date
206: D.DEMAND_CLASS)),
207: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
208: DECODE(p_demand_class, '-1',
209: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
210: null, null, p_item_id, p_org_id,
211: p_instance_id, TRUNC(
212: DECODE(RECORD_SOURCE,
213: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 222: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

218: D.DEMAND_CLASS)), TO_CHAR(NULL)),
219: 30, decode(d.source_organization_id,
220: NULL, DECODE(D.DEMAND_CLASS, null, null,
221: DECODE(p_demand_class, '-1',
222: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
223: null, null, p_item_id, p_org_id,
224: p_instance_id, TRUNC(
225: DECODE(RECORD_SOURCE,
226: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 234: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

230: p_level_id, D.DEMAND_CLASS), --plan by request date,promise date, schedule date
231: D.DEMAND_CLASS)),
232: -23453, DECODE(D.DEMAND_CLASS, null, null,
233: DECODE(p_demand_class, '-1',
234: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
235: null, null, p_item_id, p_org_id,
236: p_instance_id, TRUNC(
237: DECODE(RECORD_SOURCE,
238: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 246: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

242: p_level_id, D.DEMAND_CLASS), --plan by request date,promise date, schedule date
243: D.DEMAND_CLASS)),
244: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
245: DECODE(p_demand_class, '-1',
246: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
247: null, null, p_item_id, p_org_id,
248: p_instance_id, TRUNC(
249: DECODE(RECORD_SOURCE,
250: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 258: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

254: p_level_id, D.DEMAND_CLASS), --plan by request date,promise date, schedule date
255: D.DEMAND_CLASS)), TO_CHAR(NULL)),
256: DECODE(D.DEMAND_CLASS, null, null,
257: DECODE(p_demand_class, '-1',
258: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
259: null, null, p_item_id, p_org_id,
260: p_instance_id, TRUNC(
261: DECODE(RECORD_SOURCE,
262: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 274: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

270: 0, TO_CHAR(NULL),
271: -- rajjain begin 07/19/2002
272: decode(decode (d.origination_type, -100, 30,d.origination_type),
273: 6, decode(d.source_organization_id,
274: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
275: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
276: p_org_id, p_instance_id,
277: TRUNC(DECODE(RECORD_SOURCE,
278: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 283: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

279: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
280: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
281: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
282: p_level_id, NULL),
283: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
284: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
285: p_org_id, p_instance_id,
286: TRUNC(DECODE(RECORD_SOURCE,
287: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 292: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

288: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
289: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
290: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
291: p_level_id, NULL),
292: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
293: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
294: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
295: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
296: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 302: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

298: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
299: p_level_id, NULL),
300: TO_CHAR(NULL)),
301: 30, decode(d.source_organization_id,
302: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
303: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
304: p_org_id, p_instance_id,
305: TRUNC(DECODE(RECORD_SOURCE,
306: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 311: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

307: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
308: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
309: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
310: p_level_id, NULL),
311: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
312: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
313: p_org_id, p_instance_id,
314: TRUNC(DECODE(RECORD_SOURCE,
315: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 320: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

316: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
317: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
318: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
319: p_level_id, NULL),
320: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
321: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
322: p_org_id, p_instance_id,
323: TRUNC(DECODE(RECORD_SOURCE,
324: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 330: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,

326: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
327: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
328: p_level_id, NULL),
329: TO_CHAR(NULL)),
330: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
331: p_item_id, p_org_id, p_instance_id,
332: TRUNC(DECODE(RECORD_SOURCE,
333: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
334: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 342: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,

338: -- rajjain end 07/19/2002
339: p_demand_class, 1,
340: Decode(D.Demand_Class, NULL, --4365873 If l_demand_class is not null and demand class is populated
341: -- on supplies record then 0 should be allocated.
342: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,
343: D.DEMAND_ID,
344: TRUNC(DECODE(RECORD_SOURCE,
345: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
346: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 372: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

368: 1, decode(decode (d.origination_type, -100, 30,d.origination_type),
369: 6, decode(d.source_organization_id,
370: NULL, DECODE(D.DEMAND_CLASS, null, null,
371: DECODE(p_demand_class, '-1',
372: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
373: null, null, p_item_id, p_org_id,
374: p_instance_id, TRUNC(
375: DECODE(RECORD_SOURCE,
376: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 384: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

380: p_level_id, D.DEMAND_CLASS),
381: D.DEMAND_CLASS)),
382: -23453, DECODE(D.DEMAND_CLASS, null, null,
383: DECODE(p_demand_class, '-1',
384: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
385: null, null, p_item_id, p_org_id,
386: p_instance_id,
387: TRUNC(DECODE(RECORD_SOURCE,
388: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 396: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

392: p_level_id, D.DEMAND_CLASS),
393: D.DEMAND_CLASS)),
394: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
395: DECODE(p_demand_class, '-1',
396: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
397: null, null, p_item_id, p_org_id,
398: p_instance_id,
399: TRUNC(DECODE(RECORD_SOURCE,
400: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 410: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

406: p_demand_class),
407: 30, decode(d.source_organization_id,
408: NULL, 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),

Line 422: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

418: p_level_id, D.DEMAND_CLASS),
419: D.DEMAND_CLASS)),
420: -23453, 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),

Line 434: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

430: p_level_id, D.DEMAND_CLASS),
431: D.DEMAND_CLASS)),
432: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
433: DECODE(p_demand_class, '-1',
434: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
435: null, null, p_item_id, p_org_id,
436: p_instance_id,
437: TRUNC(DECODE(RECORD_SOURCE,
438: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 447: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

443: D.DEMAND_CLASS)),
444: p_demand_class),
445: DECODE(D.DEMAND_CLASS, null, null,
446: DECODE(p_demand_class, '-1',
447: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
448: null, null, p_item_id, p_org_id,
449: p_instance_id, TRUNC(
450: DECODE(RECORD_SOURCE,
451: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 463: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

459: 0, p_demand_class,
460: -- rajjain begin 07/19/2002
461: decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
462: 6, decode(d.source_organization_id,
463: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
464: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
465: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
466: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
467: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 471: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

467: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
468: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
469: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
470: p_level_id, NULL),
471: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
472: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
473: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
474: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
475: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 479: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

475: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
476: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
477: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
478: p_level_id, NULL),
479: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
480: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
481: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
482: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
483: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 489: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

485: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
486: p_level_id, NULL),
487: p_demand_class),
488: 30, decode(d.source_organization_id,
489: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
490: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
491: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
492: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
493: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 497: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

493: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
494: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
495: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
496: p_level_id, NULL),
497: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
498: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
499: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
500: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
501: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 505: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

501: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
502: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
503: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
504: p_level_id, NULL),
505: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
506: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
507: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
508: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
509: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 514: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,

510: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
511: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
512: p_level_id, NULL),
513: p_demand_class),
514: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
515: p_item_id, p_org_id, p_instance_id,
516: TRUNC(DECODE(RECORD_SOURCE,
517: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
518: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 571: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

567: --2424357: Convert the demand calls in case of others for
568: --- demand class allocated ATP
569: 1, DECODE(S.DEMAND_CLASS, null, null,
570: DECODE(p_demand_class, '-1',
571: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
572: null,
573: null,
574: S.inventory_item_id,
575: p_org_id,

Line 583: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

579: p_level_id,
580: S.DEMAND_CLASS),S.DEMAND_CLASS)),
581: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
582: 0, TO_CHAR(NULL),
583: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
584: S.CUSTOMER_ID,
585: S.SHIP_TO_SITE_ID,
586: S.inventory_item_id,
587: p_org_id,

Line 595: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

591: p_level_id,
592: NULL))),
593: p_demand_class, 1,
594: NULL, nvl(MIHM.allocation_percent/100,1), --4365873
595: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
596: p_instance_id,
597: s.inventory_item_id,
598: p_org_id,
599: null,

Line 606: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

602: -- c.next_date -- 2859130
603: trunc(nvl(s.firm_date, s.new_schedule_date))), 1),*/
604: DECODE(
605: MIHM.allocation_percent/100, --4365873
606: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
607: p_instance_id,
608: s.inventory_item_id,
609: p_org_id,
610: null,

Line 707: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

703: 1, decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
704: 6, decode(d.source_organization_id,
705: NULL, DECODE(D.DEMAND_CLASS, null, null,
706: DECODE(p_demand_class, '-1',
707: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
708: null, null, p_item_id, p_org_id,
709: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
710: D.DEMAND_CLASS)),
711: -23453, DECODE(D.DEMAND_CLASS, null, null,

Line 713: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

709: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
710: D.DEMAND_CLASS)),
711: -23453, DECODE(D.DEMAND_CLASS, null, null,
712: DECODE(p_demand_class, '-1',
713: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
714: null, null, p_item_id, p_org_id,
715: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
716: D.DEMAND_CLASS)),
717: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,

Line 719: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

715: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
716: D.DEMAND_CLASS)),
717: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
718: DECODE(p_demand_class, '-1',
719: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
720: null, null, p_item_id, p_org_id,
721: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
722: D.DEMAND_CLASS)), TO_CHAR(NULL)),
723: 30, decode(d.source_organization_id,

Line 726: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

722: D.DEMAND_CLASS)), TO_CHAR(NULL)),
723: 30, decode(d.source_organization_id,
724: NULL, DECODE(D.DEMAND_CLASS, null, null,
725: DECODE(p_demand_class, '-1',
726: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
727: null, null, p_item_id, p_org_id,
728: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
729: D.DEMAND_CLASS)),
730: -23453, DECODE(D.DEMAND_CLASS, null, null,

Line 732: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

728: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
729: D.DEMAND_CLASS)),
730: -23453, DECODE(D.DEMAND_CLASS, null, null,
731: DECODE(p_demand_class, '-1',
732: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
733: null, null, p_item_id, p_org_id,
734: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
735: D.DEMAND_CLASS)),
736: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,

Line 738: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

734: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
735: D.DEMAND_CLASS)),
736: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
737: DECODE(p_demand_class, '-1',
738: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
739: null, null, p_item_id, p_org_id,
740: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
741: D.DEMAND_CLASS)), TO_CHAR(NULL)),
742: DECODE(D.DEMAND_CLASS, null, null,

Line 744: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

740: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
741: D.DEMAND_CLASS)), TO_CHAR(NULL)),
742: DECODE(D.DEMAND_CLASS, null, null,
743: DECODE(p_demand_class, '-1',
744: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
745: null, null, p_item_id, p_org_id,
746: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
747: D.DEMAND_CLASS))),
748: -- rajjain end

Line 754: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

750: 0, TO_CHAR(NULL),
751: -- rajjain begin 07/19/2002
752: decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
753: 6, decode(d.source_organization_id,
754: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
755: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
756: p_org_id, p_instance_id, c.calendar_date,
757: p_level_id, NULL),
758: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 758: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

754: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
755: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
756: p_org_id, p_instance_id, c.calendar_date,
757: p_level_id, NULL),
758: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
759: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
760: p_org_id, p_instance_id, c.calendar_date,
761: p_level_id, NULL),
762: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 762: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

758: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
759: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
760: p_org_id, p_instance_id, c.calendar_date,
761: p_level_id, NULL),
762: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
763: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
764: p_org_id, p_instance_id, c.calendar_date,
765: p_level_id, NULL),
766: TO_CHAR(NULL)),

Line 768: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

764: p_org_id, p_instance_id, c.calendar_date,
765: p_level_id, NULL),
766: TO_CHAR(NULL)),
767: 30, decode(d.source_organization_id,
768: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
769: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
770: p_org_id, p_instance_id, c.calendar_date,
771: p_level_id, NULL),
772: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 772: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

768: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
769: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
770: p_org_id, p_instance_id, c.calendar_date,
771: p_level_id, NULL),
772: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
773: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
774: p_org_id, p_instance_id, c.calendar_date,
775: p_level_id, NULL),
776: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 776: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

772: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
773: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
774: p_org_id, p_instance_id, c.calendar_date,
775: p_level_id, NULL),
776: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
777: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
778: p_org_id, p_instance_id, c.calendar_date,
779: p_level_id, NULL),
780: TO_CHAR(NULL)),

Line 781: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,

777: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
778: p_org_id, p_instance_id, c.calendar_date,
779: p_level_id, NULL),
780: TO_CHAR(NULL)),
781: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
782: p_item_id, p_org_id, p_instance_id,
783: c.calendar_date,p_level_id, NULL)))),
784: -- rajjain end 07/19/2002
785: p_demand_class, 1,

Line 787: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,

783: c.calendar_date,p_level_id, NULL)))),
784: -- rajjain end 07/19/2002
785: p_demand_class, 1,
786: Decode(D.Demand_Class, NULL, --4365873
787: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,
788: D.DEMAND_ID,
789: c.calendar_date,
790: D.USING_ASSEMBLY_ITEM_ID,
791: DECODE(D.SOURCE_ORGANIZATION_ID,

Line 813: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

809: 1, decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
810: 6, decode(d.source_organization_id,
811: NULL, DECODE(D.DEMAND_CLASS, null, null,
812: DECODE(p_demand_class, '-1',
813: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
814: null, null, p_item_id, p_org_id,
815: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
816: D.DEMAND_CLASS)),
817: -23453, DECODE(D.DEMAND_CLASS, null, null,

Line 819: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

815: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
816: D.DEMAND_CLASS)),
817: -23453, DECODE(D.DEMAND_CLASS, null, null,
818: DECODE(p_demand_class, '-1',
819: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
820: null, null, p_item_id, p_org_id,
821: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
822: D.DEMAND_CLASS)),
823: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,

Line 825: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

821: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
822: D.DEMAND_CLASS)),
823: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
824: DECODE(p_demand_class, '-1',
825: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
826: null, null, p_item_id, p_org_id,
827: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
828: D.DEMAND_CLASS)),
829: p_demand_class),

Line 833: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

829: p_demand_class),
830: 30, decode(d.source_organization_id,
831: NULL, DECODE(D.DEMAND_CLASS, null, null,
832: DECODE(p_demand_class, '-1',
833: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
834: null, null, p_item_id, p_org_id,
835: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
836: D.DEMAND_CLASS)),
837: -23453, DECODE(D.DEMAND_CLASS, null, null,

Line 839: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

835: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
836: D.DEMAND_CLASS)),
837: -23453, DECODE(D.DEMAND_CLASS, null, null,
838: DECODE(p_demand_class, '-1',
839: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
840: null, null, p_item_id, p_org_id,
841: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
842: D.DEMAND_CLASS)),
843: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,

Line 845: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

841: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
842: D.DEMAND_CLASS)),
843: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
844: DECODE(p_demand_class, '-1',
845: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
846: null, null, p_item_id, p_org_id,
847: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
848: D.DEMAND_CLASS)),
849: p_demand_class),

Line 852: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

848: D.DEMAND_CLASS)),
849: p_demand_class),
850: DECODE(D.DEMAND_CLASS, null, null,
851: DECODE(p_demand_class, '-1',
852: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
853: null, null, p_item_id, p_org_id,
854: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
855: D.DEMAND_CLASS))),
856: -- rajjain end

Line 862: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

858: 0, p_demand_class,
859: -- rajjain begin 07/19/2002
860: decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
861: 6, decode(d.source_organization_id,
862: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
863: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
864: p_org_id, p_instance_id, c.calendar_date,
865: p_level_id, NULL),
866: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 866: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

862: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
863: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
864: p_org_id, p_instance_id, c.calendar_date,
865: p_level_id, NULL),
866: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
867: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
868: p_org_id, p_instance_id, c.calendar_date,
869: p_level_id, NULL),
870: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 870: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

866: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
867: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
868: p_org_id, p_instance_id, c.calendar_date,
869: p_level_id, NULL),
870: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
871: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
872: p_org_id, p_instance_id, c.calendar_date,
873: p_level_id, NULL),
874: p_demand_class),

Line 876: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

872: p_org_id, p_instance_id, c.calendar_date,
873: p_level_id, NULL),
874: p_demand_class),
875: 30, decode(d.source_organization_id,
876: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
877: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
878: p_org_id, p_instance_id, c.calendar_date,
879: p_level_id, NULL),
880: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 880: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

876: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
877: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
878: p_org_id, p_instance_id, c.calendar_date,
879: p_level_id, NULL),
880: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
881: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
882: p_org_id, p_instance_id, c.calendar_date,
883: p_level_id, NULL),
884: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 884: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

880: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
881: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
882: p_org_id, p_instance_id, c.calendar_date,
883: p_level_id, NULL),
884: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
885: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
886: p_org_id, p_instance_id, c.calendar_date,
887: p_level_id, NULL),
888: p_demand_class),

Line 889: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,

885: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
886: p_org_id, p_instance_id, c.calendar_date,
887: p_level_id, NULL),
888: p_demand_class),
889: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
890: p_item_id, p_org_id, p_instance_id,
891: c.calendar_date,p_level_id, NULL)))),
892: -- rajjain end 07/19/2002
893: p_demand_class,

Line 941: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

937: --2424357: Convert the demand calls in case of others for
938: --- demand class allocated ATP
939: 1, DECODE(CS.DEMAND_CLASS, null, null,
940: DECODE(p_demand_class, '-1',
941: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
942: null,
943: null,
944: cs.inventory_item_id,
945: p_org_id,

Line 952: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

948: p_level_id,
949: CS.DEMAND_CLASS),CS.DEMAND_CLASS)),
950: 2, DECODE(CS.CUSTOMER_ID, NULL, TO_CHAR(NULL),
951: 0, TO_CHAR(NULL),
952: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
953: CS.CUSTOMER_ID,
954: CS.SHIP_TO_SITE_ID,
955: cs.inventory_item_id,
956: p_org_id,

Line 963: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

959: p_level_id,
960: NULL))),
961: p_demand_class, 1,
962: NULL, nvl(MIHM.allocation_percent/100,1), --4365873
963: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
964: p_instance_id,
965: cs.inventory_item_id,
966: p_org_id,
967: null,

Line 973: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

969: p_demand_class,
970: cs.calendar_date), 1),*/
971: DECODE(
972: MIHM.allocation_percent/100, --4365873
973: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
974: p_instance_id,
975: cs.inventory_item_id,
976: p_org_id,
977: null,

Line 1097: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1093: 1, decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
1094: 6, decode(d.source_organization_id,
1095: NULL, DECODE(D.DEMAND_CLASS, null, null,
1096: DECODE(p_demand_class, '-1',
1097: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1098: null, null, p_item_id, p_org_id,
1099: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1100: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1101: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1107: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1103: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1104: D.DEMAND_CLASS)),
1105: -23453, DECODE(D.DEMAND_CLASS, null, null,
1106: DECODE(p_demand_class, '-1',
1107: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1108: null, null, p_item_id, p_org_id,
1109: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1110: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1111: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1117: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1113: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1114: D.DEMAND_CLASS)),
1115: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1116: DECODE(p_demand_class, '-1',
1117: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1118: null, null, p_item_id, p_org_id,
1119: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1120: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1121: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1128: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1124: D.DEMAND_CLASS)), TO_CHAR(NULL)),
1125: 30, decode(d.source_organization_id,
1126: NULL, DECODE(D.DEMAND_CLASS, null, null,
1127: DECODE(p_demand_class, '-1',
1128: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1129: null, null, p_item_id, p_org_id,
1130: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1131: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1132: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1138: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1134: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1135: D.DEMAND_CLASS)),
1136: -23453, DECODE(D.DEMAND_CLASS, null, null,
1137: DECODE(p_demand_class, '-1',
1138: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1139: null, null, p_item_id, p_org_id,
1140: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1141: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1142: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1148: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1144: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1145: D.DEMAND_CLASS)),
1146: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1147: DECODE(p_demand_class, '-1',
1148: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1149: null, null, p_item_id, p_org_id,
1150: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1151: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1152: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1158: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1154: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1155: D.DEMAND_CLASS)), TO_CHAR(NULL)),
1156: DECODE(D.DEMAND_CLASS, null, null,
1157: DECODE(p_demand_class, '-1',
1158: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1159: null, null, p_item_id, p_org_id,
1160: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1161: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1162: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1172: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1168: 0, TO_CHAR(NULL),
1169: -- rajjain begin 07/19/2002
1170: decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
1171: 6, decode(d.source_organization_id,
1172: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1173: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1174: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1175: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1176: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1180: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1176: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1177: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1178: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1179: p_level_id, NULL),
1180: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1181: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1182: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1183: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1184: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1188: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1184: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1185: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1186: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1187: p_level_id, NULL),
1188: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1189: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1190: p_org_id, 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,

Line 1198: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1194: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1195: p_level_id, NULL),
1196: TO_CHAR(NULL)),
1197: 30, decode(d.source_organization_id,
1198: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1199: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1200: p_org_id, 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,

Line 1206: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1202: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1203: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1204: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1205: p_level_id, NULL),
1206: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1207: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1208: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1209: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1210: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1214: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1210: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1211: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1212: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1213: p_level_id, NULL),
1214: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1215: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1216: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1217: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1218: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1223: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,

1219: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1220: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1221: p_level_id, NULL),
1222: TO_CHAR(NULL)),
1223: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
1224: p_item_id, p_org_id, p_instance_id,
1225: TRUNC(DECODE(RECORD_SOURCE,
1226: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1227: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1233: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,

1229: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),p_level_id, NULL)))),
1230: -- rajjain end 07/19/2002
1231: p_demand_class, 1,
1232: Decode(D.Demand_Class, NULL, --4365873
1233: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,
1234: D.DEMAND_ID,
1235: TRUNC(DECODE(RECORD_SOURCE,
1236: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1237: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1263: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1259: 1, decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
1260: 6, decode(d.source_organization_id,
1261: NULL, DECODE(D.DEMAND_CLASS, null, null,
1262: DECODE(p_demand_class, '-1',
1263: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1264: null, null, p_item_id, p_org_id,
1265: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1266: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1267: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1273: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1269: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1270: D.DEMAND_CLASS)),
1271: -23453, DECODE(D.DEMAND_CLASS, null, null,
1272: DECODE(p_demand_class, '-1',
1273: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1274: null, null, p_item_id, p_org_id,
1275: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1276: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1277: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1283: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1279: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1280: D.DEMAND_CLASS)),
1281: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1282: DECODE(p_demand_class, '-1',
1283: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1284: null, null, p_item_id, p_org_id,
1285: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1286: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1287: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1295: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1291: p_demand_class),
1292: 30, decode(d.source_organization_id,
1293: NULL, DECODE(D.DEMAND_CLASS, null, null,
1294: DECODE(p_demand_class, '-1',
1295: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1296: null, null, p_item_id, p_org_id,
1297: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1298: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1299: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1305: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1301: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1302: D.DEMAND_CLASS)),
1303: -23453, DECODE(D.DEMAND_CLASS, null, null,
1304: DECODE(p_demand_class, '-1',
1305: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1306: null, null, p_item_id, p_org_id,
1307: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1308: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1309: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1315: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1311: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1312: D.DEMAND_CLASS)),
1313: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1314: DECODE(p_demand_class, '-1',
1315: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1316: null, null, p_item_id, p_org_id,
1317: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1318: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1319: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1326: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1322: D.DEMAND_CLASS)),
1323: p_demand_class),
1324: DECODE(D.DEMAND_CLASS, null, null,
1325: DECODE(p_demand_class, '-1',
1326: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1327: null, null, p_item_id, p_org_id,
1328: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1329: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1330: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1340: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1336: 0, p_demand_class,
1337: -- rajjain begin 07/19/2002
1338: decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
1339: 6, decode(d.source_organization_id,
1340: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1341: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1342: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1343: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1344: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1348: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1344: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1345: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1346: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1347: p_level_id, NULL),
1348: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1349: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1350: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1351: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1352: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1356: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1352: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1353: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1354: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1355: p_level_id, NULL),
1356: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1357: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1358: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1359: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1360: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1366: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1362: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1363: p_level_id, NULL),
1364: p_demand_class),
1365: 30, decode(d.source_organization_id,
1366: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1367: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1368: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1369: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1370: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1374: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1370: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1371: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1372: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1373: p_level_id, NULL),
1374: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1375: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1376: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1377: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1378: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1382: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1378: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1379: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1380: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1381: p_level_id, NULL),
1382: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1383: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1384: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
1385: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1386: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1391: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,

1387: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1388: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1389: p_level_id, NULL),
1390: p_demand_class),
1391: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
1392: p_item_id, p_org_id, p_instance_id,
1393: TRUNC(DECODE(RECORD_SOURCE,
1394: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1395: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1448: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1444: --2424357: Convert the demand calls in case of others for
1445: --- demand class allocated ATP
1446: 1, DECODE(S.DEMAND_CLASS, null, null,
1447: DECODE(p_demand_class, '-1',
1448: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1449: null,
1450: null,
1451: S.inventory_item_id,
1452: p_org_id,

Line 1459: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1455: p_level_id,
1456: S.DEMAND_CLASS),S.DEMAND_CLASS)),
1457: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
1458: 0, TO_CHAR(NULL),
1459: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1460: S.CUSTOMER_ID,
1461: S.SHIP_TO_SITE_ID,
1462: S.inventory_item_id,
1463: p_org_id,

Line 1470: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

1466: p_level_id,
1467: NULL))),
1468: p_demand_class, 1,
1469: NULL, nvl(MIHM.allocation_percent/100,1), --4365873
1470: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
1471: p_instance_id,
1472: s.inventory_item_id,
1473: p_org_id,
1474: null,

Line 1479: /*MSC_AATP_FUNC.Get_DC_Alloc_Percent(

1475: null,
1476: p_demand_class,
1477: trunc(nvl(s.firm_date, s.new_schedule_date))), 1),*/
1478: DECODE(MIHM.allocation_percent/100, --4365873
1479: /*MSC_AATP_FUNC.Get_DC_Alloc_Percent(
1480: p_instance_id,
1481: s.inventory_item_id,
1482: p_org_id,
1483: null,

Line 1587: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1583: 1, decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
1584: 6, decode(d.source_organization_id,
1585: NULL, DECODE(D.DEMAND_CLASS, null, null,
1586: DECODE(p_demand_class, '-1',
1587: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1588: null, null, p_item_id, p_org_id,
1589: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1590: D.DEMAND_CLASS)),
1591: -23453, DECODE(D.DEMAND_CLASS, null, null,

Line 1593: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1589: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1590: D.DEMAND_CLASS)),
1591: -23453, DECODE(D.DEMAND_CLASS, null, null,
1592: DECODE(p_demand_class, '-1',
1593: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1594: null, null, p_item_id, p_org_id,
1595: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1596: D.DEMAND_CLASS)),
1597: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,

Line 1599: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1595: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1596: D.DEMAND_CLASS)),
1597: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1598: DECODE(p_demand_class, '-1',
1599: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1600: null, null, p_item_id, p_org_id,
1601: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1602: D.DEMAND_CLASS)), TO_CHAR(NULL)),
1603: 30, decode(d.source_organization_id,

Line 1606: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1602: D.DEMAND_CLASS)), TO_CHAR(NULL)),
1603: 30, decode(d.source_organization_id,
1604: NULL, DECODE(D.DEMAND_CLASS, null, null,
1605: DECODE(p_demand_class, '-1',
1606: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1607: null, null, p_item_id, p_org_id,
1608: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1609: D.DEMAND_CLASS)),
1610: -23453, DECODE(D.DEMAND_CLASS, null, null,

Line 1612: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1608: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1609: D.DEMAND_CLASS)),
1610: -23453, DECODE(D.DEMAND_CLASS, null, null,
1611: DECODE(p_demand_class, '-1',
1612: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1613: null, null, p_item_id, p_org_id,
1614: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1615: D.DEMAND_CLASS)),
1616: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,

Line 1618: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1614: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1615: D.DEMAND_CLASS)),
1616: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1617: DECODE(p_demand_class, '-1',
1618: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1619: null, null, p_item_id, p_org_id,
1620: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1621: D.DEMAND_CLASS)), TO_CHAR(NULL)),
1622: DECODE(D.DEMAND_CLASS, null, null,

Line 1624: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1620: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1621: D.DEMAND_CLASS)), TO_CHAR(NULL)),
1622: DECODE(D.DEMAND_CLASS, null, null,
1623: DECODE(p_demand_class, '-1',
1624: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1625: null, null, p_item_id, p_org_id,
1626: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1627: D.DEMAND_CLASS))),
1628: -- rajjain end

Line 1634: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1630: 0, TO_CHAR(NULL),
1631: -- rajjain begin 07/19/2002
1632: decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
1633: 6, decode(d.source_organization_id,
1634: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1635: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1636: p_org_id, p_instance_id, c.calendar_date,
1637: p_level_id, NULL),
1638: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 1638: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1634: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1635: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1636: p_org_id, p_instance_id, c.calendar_date,
1637: p_level_id, NULL),
1638: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1639: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1640: p_org_id, p_instance_id, c.calendar_date,
1641: p_level_id, NULL),
1642: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 1642: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1638: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1639: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1640: p_org_id, p_instance_id, c.calendar_date,
1641: p_level_id, NULL),
1642: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1643: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1644: p_org_id, p_instance_id, c.calendar_date,
1645: p_level_id, NULL),
1646: TO_CHAR(NULL)),

Line 1648: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1644: p_org_id, p_instance_id, c.calendar_date,
1645: p_level_id, NULL),
1646: TO_CHAR(NULL)),
1647: 30, decode(d.source_organization_id,
1648: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1649: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1650: p_org_id, p_instance_id, c.calendar_date,
1651: p_level_id, NULL),
1652: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 1652: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1648: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1649: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1650: p_org_id, p_instance_id, c.calendar_date,
1651: p_level_id, NULL),
1652: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1653: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1654: p_org_id, p_instance_id, c.calendar_date,
1655: p_level_id, NULL),
1656: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 1656: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1652: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1653: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1654: p_org_id, p_instance_id, c.calendar_date,
1655: p_level_id, NULL),
1656: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1657: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1658: p_org_id, p_instance_id, c.calendar_date,
1659: p_level_id, NULL),
1660: TO_CHAR(NULL)),

Line 1661: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,

1657: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1658: p_org_id, p_instance_id, c.calendar_date,
1659: p_level_id, NULL),
1660: TO_CHAR(NULL)),
1661: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
1662: p_item_id, p_org_id, p_instance_id,
1663: c.calendar_date,p_level_id, NULL)))),
1664: -- rajjain end 07/19/2002
1665: p_demand_class, 1,

Line 1667: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,

1663: c.calendar_date,p_level_id, NULL)))),
1664: -- rajjain end 07/19/2002
1665: p_demand_class, 1,
1666: Decode(D.Demand_Class, NULL, --4365873
1667: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,
1668: D.DEMAND_ID,
1669: c.calendar_date,
1670: D.USING_ASSEMBLY_ITEM_ID,
1671: DECODE(D.SOURCE_ORGANIZATION_ID,

Line 1693: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1689: 1, decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
1690: 6, decode(d.source_organization_id,
1691: NULL, DECODE(D.DEMAND_CLASS, null, null,
1692: DECODE(p_demand_class, '-1',
1693: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1694: null, null, p_item_id, p_org_id,
1695: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1696: D.DEMAND_CLASS)),
1697: -23453, DECODE(D.DEMAND_CLASS, null, null,

Line 1699: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1695: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1696: D.DEMAND_CLASS)),
1697: -23453, DECODE(D.DEMAND_CLASS, null, null,
1698: DECODE(p_demand_class, '-1',
1699: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1700: null, null, p_item_id, p_org_id,
1701: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1702: D.DEMAND_CLASS)),
1703: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,

Line 1705: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1701: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1702: D.DEMAND_CLASS)),
1703: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1704: DECODE(p_demand_class, '-1',
1705: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1706: null, null, p_item_id, p_org_id,
1707: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1708: D.DEMAND_CLASS)),
1709: p_demand_class),

Line 1713: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1709: p_demand_class),
1710: 30, decode(d.source_organization_id,
1711: NULL, DECODE(D.DEMAND_CLASS, null, null,
1712: DECODE(p_demand_class, '-1',
1713: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1714: null, null, p_item_id, p_org_id,
1715: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1716: D.DEMAND_CLASS)),
1717: -23453, DECODE(D.DEMAND_CLASS, null, null,

Line 1719: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1715: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1716: D.DEMAND_CLASS)),
1717: -23453, DECODE(D.DEMAND_CLASS, null, null,
1718: DECODE(p_demand_class, '-1',
1719: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1720: null, null, p_item_id, p_org_id,
1721: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1722: D.DEMAND_CLASS)),
1723: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,

Line 1725: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1721: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1722: D.DEMAND_CLASS)),
1723: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1724: DECODE(p_demand_class, '-1',
1725: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1726: null, null, p_item_id, p_org_id,
1727: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
1728: D.DEMAND_CLASS)),
1729: p_demand_class),

Line 1732: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1728: D.DEMAND_CLASS)),
1729: p_demand_class),
1730: 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))),
1736: -- rajjain end

Line 1742: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1738: 0, p_demand_class,
1739: -- rajjain begin 07/19/2002
1740: decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
1741: 6, decode(d.source_organization_id,
1742: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1743: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1744: p_org_id, p_instance_id, c.calendar_date,
1745: p_level_id, NULL),
1746: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 1746: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1742: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1743: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1744: p_org_id, p_instance_id, c.calendar_date,
1745: p_level_id, NULL),
1746: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1747: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1748: p_org_id, p_instance_id, c.calendar_date,
1749: p_level_id, NULL),
1750: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 1750: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1746: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1747: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1748: p_org_id, p_instance_id, c.calendar_date,
1749: p_level_id, NULL),
1750: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1751: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1752: p_org_id, p_instance_id, c.calendar_date,
1753: p_level_id, NULL),
1754: p_demand_class),

Line 1756: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1752: p_org_id, p_instance_id, c.calendar_date,
1753: p_level_id, NULL),
1754: p_demand_class),
1755: 30, decode(d.source_organization_id,
1756: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1757: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1758: p_org_id, p_instance_id, c.calendar_date,
1759: p_level_id, NULL),
1760: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 1760: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1756: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1757: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1758: p_org_id, p_instance_id, c.calendar_date,
1759: p_level_id, NULL),
1760: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1761: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1762: p_org_id, p_instance_id, c.calendar_date,
1763: p_level_id, NULL),
1764: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 1764: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1760: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1761: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1762: p_org_id, p_instance_id, c.calendar_date,
1763: p_level_id, NULL),
1764: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1765: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1766: p_org_id, p_instance_id, c.calendar_date,
1767: p_level_id, NULL),
1768: p_demand_class),

Line 1769: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,

1765: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
1766: p_org_id, p_instance_id, c.calendar_date,
1767: p_level_id, NULL),
1768: p_demand_class),
1769: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
1770: p_item_id, p_org_id, p_instance_id,
1771: c.calendar_date,p_level_id, NULL)))),
1772: -- rajjain end 07/19/2002
1773: p_demand_class,

Line 1820: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1816: --2424357: Convert the demand calls in case of others for
1817: --- demand class allocated ATP
1818: 1, DECODE(CS.DEMAND_CLASS, null, null,
1819: DECODE(p_demand_class, '-1',
1820: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1821: null,
1822: null,
1823: cs.inventory_item_id,
1824: p_org_id,

Line 1831: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1827: p_level_id,
1828: CS.DEMAND_CLASS),CS.DEMAND_CLASS)),
1829: 2, DECODE(CS.CUSTOMER_ID, NULL, TO_CHAR(NULL),
1830: 0, TO_CHAR(NULL),
1831: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1832: CS.CUSTOMER_ID,
1833: CS.SHIP_TO_SITE_ID,
1834: cs.inventory_item_id,
1835: p_org_id,

Line 1842: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

1838: p_level_id,
1839: NULL))),
1840: p_demand_class, 1,
1841: NULL, nvl(MIHM.allocation_percent/100,1), --4365873
1842: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
1843: p_instance_id,
1844: s.inventory_item_id,
1845: p_org_id,
1846: null,

Line 1852: /*MSC_AATP_FUNC.Get_DC_Alloc_Percent(

1848: p_demand_class,
1849: c.calendar_date), 1),*/
1850: DECODE(
1851: MIHM.allocation_percent/100, --4365873
1852: /*MSC_AATP_FUNC.Get_DC_Alloc_Percent(
1853: p_instance_id,
1854: s.inventory_item_id,
1855: p_org_id,
1856: null,

Line 2024: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2020: 1, decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
2021: 6, decode(d.source_organization_id,
2022: NULL, DECODE(D.DEMAND_CLASS, null, null,
2023: DECODE(p_demand_class, '-1',
2024: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2025: null, null, p_item_id, p_org_id,
2026: p_instance_id, trunc(DECODE(RECORD_SOURCE,
2027: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2028: -- Bug 3550296 and 3574164. IMPLEMENT_DATE AND DMD_SATISFIED_DATE are changed to

Line 2036: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2032: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2033: D.DEMAND_CLASS)),
2034: -23453, DECODE(D.DEMAND_CLASS, null, null,
2035: DECODE(p_demand_class, '-1',
2036: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2037: null, null, p_item_id, p_org_id,
2038: p_instance_id, trunc(DECODE(RECORD_SOURCE,
2039: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2040: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2046: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2042: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2043: D.DEMAND_CLASS)),
2044: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2045: DECODE(p_demand_class, '-1',
2046: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2047: null, null, p_item_id, p_org_id,
2048: p_instance_id, trunc(DECODE(RECORD_SOURCE,
2049: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2050: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2057: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2053: D.DEMAND_CLASS)), NULL),
2054: 30, decode(d.source_organization_id,
2055: NULL, DECODE(D.DEMAND_CLASS, null, null,
2056: DECODE(p_demand_class, '-1',
2057: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2058: null, null, p_item_id, p_org_id,
2059: p_instance_id, trunc(DECODE(RECORD_SOURCE,
2060: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2061: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2067: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2063: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2064: D.DEMAND_CLASS)),
2065: -23453, DECODE(D.DEMAND_CLASS, null, null,
2066: DECODE(p_demand_class, '-1',
2067: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2068: null, null, p_item_id, p_org_id,
2069: p_instance_id, trunc(DECODE(RECORD_SOURCE,
2070: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2071: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2077: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2073: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2074: D.DEMAND_CLASS)),
2075: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2076: DECODE(p_demand_class, '-1',
2077: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2078: null, null, p_item_id, p_org_id,
2079: p_instance_id, trunc(DECODE(RECORD_SOURCE,
2080: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2081: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2087: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2083: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2084: D.DEMAND_CLASS)), NULL),
2085: DECODE(D.DEMAND_CLASS, null, null,
2086: DECODE(p_demand_class, '-1',
2087: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2088: null, null, p_item_id, p_org_id,
2089: p_instance_id, trunc(DECODE(RECORD_SOURCE,
2090: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2091: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2101: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2097: 0, NULL,
2098: -- rajjain begin 07/19/2002
2099: decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
2100: 6, decode(d.source_organization_id,
2101: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2102: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2103: p_org_id, p_instance_id, trunc(DECODE(RECORD_SOURCE,
2104: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2105: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2109: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2105: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2106: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2107: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2108: p_level_id, NULL),
2109: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2110: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2111: p_org_id, p_instance_id, trunc(DECODE(RECORD_SOURCE,
2112: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2113: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2117: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2113: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2114: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2115: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2116: p_level_id, NULL),
2117: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2118: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2119: p_org_id, p_instance_id, trunc(DECODE(RECORD_SOURCE,
2120: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2121: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2127: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2123: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2124: p_level_id, NULL),
2125: NULL),
2126: 30, decode(d.source_organization_id,
2127: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2128: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2129: p_org_id, p_instance_id, trunc(DECODE(RECORD_SOURCE,
2130: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2131: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2135: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2131: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2132: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2133: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2134: p_level_id, NULL),
2135: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2136: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2137: p_org_id, p_instance_id, trunc(DECODE(RECORD_SOURCE,
2138: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2139: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2143: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2139: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2140: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2141: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2142: p_level_id, NULL),
2143: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2144: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2145: p_org_id, p_instance_id, trunc(DECODE(RECORD_SOURCE,
2146: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2147: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2152: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,

2148: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2149: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2150: p_level_id, NULL),
2151: NULL),
2152: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
2153: p_item_id, p_org_id, p_instance_id,
2154: trunc(DECODE(RECORD_SOURCE,
2155: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2156: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2162: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,

2158: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),p_level_id, NULL)))),
2159: -- rajjain end 07/19/2002
2160: p_demand_class, 1,
2161: Decode(D.Demand_Class, NULL, --4365873
2162: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,
2163: D.DEMAND_ID,
2164: trunc(DECODE(RECORD_SOURCE,
2165: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2166: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2192: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2188: 1, decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
2189: 6, decode(d.source_organization_id,
2190: NULL, DECODE(D.DEMAND_CLASS, null, null,
2191: DECODE(p_demand_class, '-1',
2192: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2193: null, null, p_item_id, p_org_id,
2194: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2195: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2196: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2202: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2198: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2199: D.DEMAND_CLASS)),
2200: -23453, DECODE(D.DEMAND_CLASS, null, null,
2201: DECODE(p_demand_class, '-1',
2202: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2203: null, null, p_item_id, p_org_id,
2204: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2205: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2206: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2212: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2208: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2209: D.DEMAND_CLASS)),
2210: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2211: DECODE(p_demand_class, '-1',
2212: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2213: null, null, p_item_id, p_org_id,
2214: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2215: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2216: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2224: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2220: p_demand_class),
2221: 30, decode(d.source_organization_id,
2222: NULL, DECODE(D.DEMAND_CLASS, null, null,
2223: DECODE(p_demand_class, '-1',
2224: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2225: null, null, p_item_id, p_org_id,
2226: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2227: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2228: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2234: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2230: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2231: D.DEMAND_CLASS)),
2232: -23453, DECODE(D.DEMAND_CLASS, null, null,
2233: DECODE(p_demand_class, '-1',
2234: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2235: null, null, p_item_id, p_org_id,
2236: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2237: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2238: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2244: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2240: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2241: D.DEMAND_CLASS)),
2242: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2243: DECODE(p_demand_class, '-1',
2244: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2245: null, null, p_item_id, p_org_id,
2246: p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2247: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2248: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2255: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2251: D.DEMAND_CLASS)),
2252: p_demand_class),
2253: DECODE(D.DEMAND_CLASS, null, null,
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,

Line 2269: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2265: 0, p_demand_class,
2266: -- rajjain begin 07/19/2002
2267: decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
2268: 6, decode(d.source_organization_id,
2269: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2270: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2271: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2272: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2273: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2277: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2273: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2274: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2275: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2276: p_level_id, NULL),
2277: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2278: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2279: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2280: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2281: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2285: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2281: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2282: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2283: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2284: p_level_id, NULL),
2285: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2286: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2287: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2288: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2289: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2295: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2291: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2292: p_level_id, NULL),
2293: p_demand_class),
2294: 30, decode(d.source_organization_id,
2295: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2296: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2297: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2298: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2299: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2303: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2299: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2300: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2301: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2302: p_level_id, NULL),
2303: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2304: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2305: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2306: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2307: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2311: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2307: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2308: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2309: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2310: p_level_id, NULL),
2311: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2312: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2313: p_org_id, p_instance_id, TRUNC(DECODE(RECORD_SOURCE,
2314: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2315: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2320: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,

2316: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2317: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2318: p_level_id, NULL),
2319: p_demand_class),
2320: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
2321: p_item_id, p_org_id, p_instance_id,
2322: TRUNC(DECODE(RECORD_SOURCE,
2323: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2324: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2435: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2431: DECODE(DECODE(G_HIERARCHY_PROFILE,
2432: --2424357
2433: 1, DECODE(S.DEMAND_CLASS, null, null,
2434: DECODE(p_demand_class,'-1',
2435: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2436: null,
2437: null,
2438: S.inventory_item_id,
2439: p_org_id,

Line 2446: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2442: p_level_id,
2443: S.DEMAND_CLASS), S.DEMAND_CLASS)),
2444: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
2445: --0, TO_CHAR(NULL),
2446: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2447: S.CUSTOMER_ID,
2448: S.SHIP_TO_SITE_ID,
2449: S.inventory_item_id,
2450: p_org_id,

Line 2457: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

2453: p_level_id,
2454: NULL))),
2455: p_demand_class, 1,
2456: NULL, NVL(MIHM.allocation_percent/100,--4365873
2457: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
2458: p_instance_id,
2459: s.inventory_item_id,
2460: p_org_id,
2461: null,

Line 2467: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

2463: p_demand_class,
2464: TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE))),*/
2465: 1),
2466: DECODE(MIHM.allocation_percent/100, --4365873
2467: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
2468: p_instance_id,
2469: s.inventory_item_id,
2470: p_org_id,
2471: null,

Line 2653: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2649: 1, decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
2650: 6, decode(d.source_organization_id,
2651: NULL, DECODE(D.DEMAND_CLASS, null, null,
2652: DECODE(p_demand_class, '-1',
2653: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2654: null, null, p_item_id, p_org_id,
2655: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2656: D.DEMAND_CLASS)),
2657: -23453, DECODE(D.DEMAND_CLASS, null, null,

Line 2659: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2655: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2656: D.DEMAND_CLASS)),
2657: -23453, DECODE(D.DEMAND_CLASS, null, null,
2658: DECODE(p_demand_class, '-1',
2659: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2660: null, null, p_item_id, p_org_id,
2661: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2662: D.DEMAND_CLASS)),
2663: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,

Line 2665: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2661: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2662: D.DEMAND_CLASS)),
2663: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2664: DECODE(p_demand_class, '-1',
2665: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2666: null, null, p_item_id, p_org_id,
2667: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2668: D.DEMAND_CLASS)), NULL),
2669: 30, decode(d.source_organization_id,

Line 2672: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2668: D.DEMAND_CLASS)), NULL),
2669: 30, decode(d.source_organization_id,
2670: NULL, DECODE(D.DEMAND_CLASS, null, null,
2671: DECODE(p_demand_class, '-1',
2672: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2673: null, null, p_item_id, p_org_id,
2674: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2675: D.DEMAND_CLASS)),
2676: -23453, DECODE(D.DEMAND_CLASS, null, null,

Line 2678: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2674: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2675: D.DEMAND_CLASS)),
2676: -23453, DECODE(D.DEMAND_CLASS, null, null,
2677: DECODE(p_demand_class, '-1',
2678: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2679: null, null, p_item_id, p_org_id,
2680: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2681: D.DEMAND_CLASS)),
2682: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,

Line 2684: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2680: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2681: D.DEMAND_CLASS)),
2682: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2683: DECODE(p_demand_class, '-1',
2684: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2685: null, null, p_item_id, p_org_id,
2686: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2687: D.DEMAND_CLASS)), NULL),
2688: DECODE(D.DEMAND_CLASS, null, null,

Line 2690: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2686: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2687: D.DEMAND_CLASS)), NULL),
2688: DECODE(D.DEMAND_CLASS, null, null,
2689: DECODE(p_demand_class, '-1',
2690: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2691: null, null, p_item_id, p_org_id,
2692: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2693: D.DEMAND_CLASS))),
2694: -- rajjain end

Line 2700: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2696: 0, NULL,
2697: -- rajjain begin 07/19/2002
2698: decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
2699: 6, decode(d.source_organization_id,
2700: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2701: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2702: p_org_id, p_instance_id, c.calendar_date,
2703: p_level_id, NULL),
2704: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 2704: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2700: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2701: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2702: p_org_id, p_instance_id, c.calendar_date,
2703: p_level_id, NULL),
2704: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2705: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2706: p_org_id, p_instance_id, c.calendar_date,
2707: p_level_id, NULL),
2708: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 2708: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2704: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2705: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2706: p_org_id, p_instance_id, c.calendar_date,
2707: p_level_id, NULL),
2708: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2709: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2710: p_org_id, p_instance_id, c.calendar_date,
2711: p_level_id, NULL),
2712: NULL),

Line 2714: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2710: p_org_id, p_instance_id, c.calendar_date,
2711: p_level_id, NULL),
2712: NULL),
2713: 30, decode(d.source_organization_id,
2714: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2715: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2716: p_org_id, p_instance_id, c.calendar_date,
2717: p_level_id, NULL),
2718: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 2718: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2714: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2715: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2716: p_org_id, p_instance_id, c.calendar_date,
2717: p_level_id, NULL),
2718: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2719: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2720: p_org_id, p_instance_id, c.calendar_date,
2721: p_level_id, NULL),
2722: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 2722: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2718: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2719: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2720: p_org_id, p_instance_id, c.calendar_date,
2721: p_level_id, NULL),
2722: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2723: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2724: p_org_id, p_instance_id, c.calendar_date,
2725: p_level_id, NULL),
2726: NULL),

Line 2727: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,

2723: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2724: p_org_id, p_instance_id, c.calendar_date,
2725: p_level_id, NULL),
2726: NULL),
2727: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
2728: p_item_id, p_org_id, p_instance_id,
2729: c.calendar_date,p_level_id, NULL)))),
2730: -- rajjain end 07/19/2002
2731: p_demand_class, 1,

Line 2733: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,

2729: c.calendar_date,p_level_id, NULL)))),
2730: -- rajjain end 07/19/2002
2731: p_demand_class, 1,
2732: Decode(D.Demand_Class, NULL, --4365873
2733: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,
2734: D.DEMAND_ID,
2735: c.calendar_date,
2736: D.USING_ASSEMBLY_ITEM_ID,
2737: DECODE(D.SOURCE_ORGANIZATION_ID,

Line 2759: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2755: 1, decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
2756: 6, decode(d.source_organization_id,
2757: NULL, DECODE(D.DEMAND_CLASS, null, null,
2758: DECODE(p_demand_class, '-1',
2759: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2760: null, null, p_item_id, p_org_id,
2761: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2762: D.DEMAND_CLASS)),
2763: -23453, DECODE(D.DEMAND_CLASS, null, null,

Line 2765: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2761: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2762: D.DEMAND_CLASS)),
2763: -23453, DECODE(D.DEMAND_CLASS, null, null,
2764: DECODE(p_demand_class, '-1',
2765: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2766: null, null, p_item_id, p_org_id,
2767: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2768: D.DEMAND_CLASS)),
2769: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,

Line 2771: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2767: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2768: D.DEMAND_CLASS)),
2769: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2770: DECODE(p_demand_class, '-1',
2771: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2772: null, null, p_item_id, p_org_id,
2773: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2774: D.DEMAND_CLASS)),
2775: p_demand_class),

Line 2779: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2775: p_demand_class),
2776: 30, decode(d.source_organization_id,
2777: NULL, DECODE(D.DEMAND_CLASS, null, null,
2778: DECODE(p_demand_class, '-1',
2779: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2780: null, null, p_item_id, p_org_id,
2781: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2782: D.DEMAND_CLASS)),
2783: -23453, DECODE(D.DEMAND_CLASS, null, null,

Line 2785: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2781: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2782: D.DEMAND_CLASS)),
2783: -23453, DECODE(D.DEMAND_CLASS, null, null,
2784: DECODE(p_demand_class, '-1',
2785: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2786: null, null, p_item_id, p_org_id,
2787: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2788: D.DEMAND_CLASS)),
2789: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,

Line 2791: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2787: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2788: D.DEMAND_CLASS)),
2789: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
2790: DECODE(p_demand_class, '-1',
2791: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2792: null, null, p_item_id, p_org_id,
2793: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2794: D.DEMAND_CLASS)),
2795: p_demand_class),

Line 2798: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2794: D.DEMAND_CLASS)),
2795: p_demand_class),
2796: DECODE(D.DEMAND_CLASS, null, null,
2797: DECODE(p_demand_class, '-1',
2798: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2799: null, null, p_item_id, p_org_id,
2800: p_instance_id, c.calendar_date, p_level_id, D.DEMAND_CLASS),
2801: D.DEMAND_CLASS))),
2802: -- rajjain end

Line 2808: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2804: 0, p_demand_class,
2805: -- rajjain begin 07/19/2002
2806: decode(decode (d.origination_type, -100, 30,d.origination_type), --5027568
2807: 6, decode(d.source_organization_id,
2808: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2809: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2810: p_org_id, p_instance_id, c.calendar_date,
2811: p_level_id, NULL),
2812: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 2812: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2808: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2809: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2810: p_org_id, p_instance_id, c.calendar_date,
2811: p_level_id, NULL),
2812: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2813: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2814: p_org_id, p_instance_id, c.calendar_date,
2815: p_level_id, NULL),
2816: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 2816: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2812: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2813: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2814: p_org_id, p_instance_id, c.calendar_date,
2815: p_level_id, NULL),
2816: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2817: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2818: p_org_id, p_instance_id, c.calendar_date,
2819: p_level_id, NULL),
2820: p_demand_class),

Line 2822: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2818: p_org_id, p_instance_id, c.calendar_date,
2819: p_level_id, NULL),
2820: p_demand_class),
2821: 30, decode(d.source_organization_id,
2822: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2823: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2824: p_org_id, p_instance_id, c.calendar_date,
2825: p_level_id, NULL),
2826: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 2826: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2822: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2823: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2824: p_org_id, p_instance_id, c.calendar_date,
2825: p_level_id, NULL),
2826: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2827: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2828: p_org_id, p_instance_id, c.calendar_date,
2829: p_level_id, NULL),
2830: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

Line 2830: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2826: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2827: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2828: p_org_id, p_instance_id, c.calendar_date,
2829: p_level_id, NULL),
2830: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2831: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2832: p_org_id, p_instance_id, c.calendar_date,
2833: p_level_id, NULL),
2834: p_demand_class),

Line 2835: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,

2831: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, p_item_id,
2832: p_org_id, p_instance_id, c.calendar_date,
2833: p_level_id, NULL),
2834: p_demand_class),
2835: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
2836: p_item_id, p_org_id, p_instance_id,
2837: c.calendar_date,p_level_id, NULL)))),
2838: -- rajjain end 07/19/2002
2839: p_demand_class,

Line 2948: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2944: DECODE(DECODE(G_HIERARCHY_PROFILE,
2945: --2424357
2946: 1, DECODE(CS.DEMAND_CLASS, null, null,
2947: DECODE(p_demand_class,'-1',
2948: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2949: null,
2950: null,
2951: cs.inventory_item_id,
2952: p_org_id,

Line 2959: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2955: p_level_id,
2956: CS.DEMAND_CLASS), CS.DEMAND_CLASS)),
2957: 2, DECODE(CS.CUSTOMER_ID, NULL, TO_CHAR(NULL),
2958: --0, TO_CHAR(NULL),
2959: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2960: CS.CUSTOMER_ID,
2961: CS.SHIP_TO_SITE_ID,
2962: cs.inventory_item_id,
2963: p_org_id,

Line 2970: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

2966: p_level_id,
2967: NULL))),
2968: p_demand_class, 1,
2969: NULL, nvl(MIHM.allocation_percent/100,1), --4365873
2970: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
2971: p_instance_id,
2972: cs.inventory_item_id,
2973: p_org_id,
2974: null,

Line 2980: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

2976: p_demand_class,
2977: cs.calendar_date), 1),*/
2978: DECODE(
2979: MIHM.allocation_percent/100, --4365873
2980: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
2981: p_instance_id,
2982: cs.inventory_item_id,
2983: p_org_id,
2984: null,

Line 5886: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(

5882: DECODE(DECODE(G_HIERARCHY_PROFILE,
5883: --bug 2424357
5884: 1, DECODE(S.DEMAND_CLASS, null, null,
5885: DECODE(l_demand_class, '-1',
5886: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
5887: null,
5888: null,
5889: p_department_id,
5890: p_resource_id,

Line 5906: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

5902: l_level_id,
5903: S.DEMAND_CLASS), S.DEMAND_CLASS)),
5904: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
5905: 0, TO_CHAR(NULL),
5906: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
5907: S.CUSTOMER_ID,
5908: S.SHIP_TO_SITE_ID,
5909: s.inventory_item_id,
5910: p_organization_id,

Line 5927: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(

5923: l_demand_class, 1,
5924: --bug 4089293: If l_demand_class is not null and demand class is populated
5925: -- on supplies record then 0 should be allocated.
5926: Decode (S.Demand_Class, NULL,
5927: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(
5928: -- 2859130 C.CALENDAR_DATE,
5929: -- Bug 3348095
5930: -- For ATP created records use end_date
5931: -- otherwise start_date

Line 5946: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(

5942: DECODE(G_HIERARCHY_PROFILE,
5943: --2424357
5944: 1, DECODE(S.DEMAND_CLASS, null, null,
5945: DECODE(l_demand_class, -1,
5946: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
5947: null,
5948: null,
5949: p_department_id,
5950: p_resource_id,

Line 5966: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

5962: l_level_id,
5963: S.DEMAND_CLASS), S.DEMAND_CLASS)),
5964: 2, DECODE(S.CUSTOMER_ID, NULL, l_demand_class,
5965: 0, l_demand_class,
5966: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
5967: S.CUSTOMER_ID,
5968: S.SHIP_TO_SITE_ID,
5969: l_inv_item_id,
5970: p_organization_id,

Line 6037: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

6033: MNRA.to_time,MNRA.to_time + 24*3600,
6034: MNRA.to_time) - MNRA.from_time)/3600) *
6035: NVL((MRHM.allocation_percent/100), 1)
6036: /*
6037: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
6038: p_instance_id,
6039: null,
6040: p_organization_id,
6041: p_department_id,

Line 6100: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(

6096: DECODE(DECODE(G_HIERARCHY_PROFILE,
6097: --bug 2424357
6098: 1, DECODE(S.DEMAND_CLASS, null, null,
6099: DECODE(l_demand_class, '-1',
6100: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
6101: null,
6102: null,
6103: p_department_id,
6104: p_resource_id,

Line 6112: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

6108: l_level_id,
6109: S.DEMAND_CLASS), S.DEMAND_CLASS)),
6110: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
6111: 0, TO_CHAR(NULL),
6112: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6113: S.CUSTOMER_ID,
6114: S.SHIP_TO_SITE_ID,
6115: s.inventory_item_id,
6116: p_organization_id,

Line 6125: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(C.CALENDAR_DATE,

6121: l_demand_class, 1,
6122: --bug 4156016: If l_demand_class is not null and demand class is populated
6123: -- on supplies record then 0 should be allocated.
6124: Decode (S.Demand_Class, NULL,
6125: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(C.CALENDAR_DATE,
6126: REQ.ASSEMBLY_ITEM_ID,
6127: p_organization_id,
6128: p_instance_id,
6129: p_department_id,

Line 6135: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(

6131: DECODE(G_HIERARCHY_PROFILE,
6132: --2424357
6133: 1, DECODE(S.DEMAND_CLASS, null, null,
6134: DECODE(l_demand_class, -1,
6135: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
6136: null,
6137: null,
6138: p_department_id,
6139: p_resource_id,

Line 6147: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

6143: l_level_id,
6144: S.DEMAND_CLASS), S.DEMAND_CLASS)),
6145: 2, DECODE(S.CUSTOMER_ID, NULL, l_demand_class,
6146: 0, l_demand_class,
6147: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6148: S.CUSTOMER_ID,
6149: S.SHIP_TO_SITE_ID,
6150: l_inv_item_id,
6151: p_organization_id,

Line 6215: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

6211: MNRA.to_time,MNRA.to_time + 24*3600,
6212: MNRA.to_time) - MNRA.from_time)/3600) *
6213: NVL((MRHM.allocation_percent/100), 1)
6214: /*
6215: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
6216: p_instance_id,
6217: null,
6218: p_organization_id,
6219: p_department_id,

Line 6280: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(

6276: DECODE(DECODE(G_HIERARCHY_PROFILE,
6277: --2424357
6278: 1, DECODE(S.DEMAND_CLASS, null, null,
6279: DECODE(l_demand_class, '-1',
6280: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
6281: null,
6282: null,
6283: p_department_id,
6284: p_resource_id,

Line 6300: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

6296: l_level_id,
6297: S.DEMAND_CLASS),S.DEMAND_CLASS)),
6298: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
6299: 0, TO_CHAR(NULL),
6300: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6301: S.CUSTOMER_ID,
6302: S.SHIP_TO_SITE_ID,
6303: s.inventory_item_id,
6304: p_organization_id,

Line 6321: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(

6317: l_demand_class, 1,
6318: --bug 4156016: If l_demand_class is not null and demand class is populated
6319: -- on supplies record then 0 should be allocated.
6320: Decode (S.Demand_Class, NULL,
6321: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(
6322: -- 2859130 C.CALENDAR_DATE,
6323: -- Bug 3348095
6324: -- For ATP created records use end_date
6325: -- otherwise start_date

Line 6340: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(

6336: DECODE(G_HIERARCHY_PROFILE,
6337: --2424357
6338: 1, DECODE(S.DEMAND_CLASS, null, null,
6339: DECODE(l_demand_class, '-1',
6340: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
6341: null,
6342: null,
6343: p_department_id,
6344: p_resource_id,

Line 6360: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

6356: l_level_id,
6357: S.DEMAND_CLASS), S.DEMAND_CLASS)),
6358: 2, DECODE(S.CUSTOMER_ID, NULL, l_demand_class,
6359: 0, l_demand_class,
6360: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6361: S.CUSTOMER_ID,
6362: S.SHIP_TO_SITE_ID,
6363: l_inv_item_id,
6364: p_organization_id,

Line 6428: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

6424: MNRA.to_time,MNRA.to_time + 24*3600,
6425: MNRA.to_time) - MNRA.from_time)/3600) *
6426: NVL((MRHM.allocation_percent/100), 1)
6427: /*
6428: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
6429: p_instance_id,
6430: null,
6431: p_organization_id,
6432: p_department_id,

Line 6485: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(

6481: DECODE(DECODE(G_HIERARCHY_PROFILE,
6482: --2424357
6483: 1, DECODE(S.DEMAND_CLASS, null, null,
6484: DECODE(l_demand_class, '-1',
6485: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
6486: null,
6487: null,
6488: p_department_id,
6489: p_resource_id,

Line 6497: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

6493: l_level_id,
6494: S.DEMAND_CLASS),S.DEMAND_CLASS)),
6495: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
6496: 0, TO_CHAR(NULL),
6497: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6498: S.CUSTOMER_ID,
6499: S.SHIP_TO_SITE_ID,
6500: s.inventory_item_id,
6501: p_organization_id,

Line 6510: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(C.CALENDAR_DATE,

6506: l_demand_class, 1,
6507: --bug 4156016: If l_demand_class is not null and demand class is populated
6508: -- on supplies record then 0 should be allocated.
6509: Decode (S.Demand_Class, NULL,
6510: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(C.CALENDAR_DATE,
6511: REQ.ASSEMBLY_ITEM_ID,
6512: p_organization_id,
6513: p_instance_id,
6514: p_department_id,

Line 6520: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(

6516: DECODE(G_HIERARCHY_PROFILE,
6517: --2424357
6518: 1, DECODE(S.DEMAND_CLASS, null, null,
6519: DECODE(l_demand_class, '-1',
6520: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
6521: null,
6522: null,
6523: p_department_id,
6524: p_resource_id,

Line 6532: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

6528: l_level_id,
6529: S.DEMAND_CLASS), S.DEMAND_CLASS)),
6530: 2, DECODE(S.CUSTOMER_ID, NULL, l_demand_class,
6531: 0, l_demand_class,
6532: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6533: S.CUSTOMER_ID,
6534: S.SHIP_TO_SITE_ID,
6535: l_inv_item_id,
6536: p_organization_id,

Line 6597: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

6593: MNRA.to_time,MNRA.to_time + 24*3600,
6594: MNRA.to_time) - MNRA.from_time)/3600) *
6595: NVL((MRHM.allocation_percent/100), 1)
6596: /*
6597: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
6598: p_instance_id,
6599: null,
6600: p_organization_id,
6601: p_department_id,

Line 6727: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(

6723: DECODE(DECODE(G_HIERARCHY_PROFILE,
6724: --2424357
6725: 1, DECODE(S.DEMAND_CLASS, null, null,
6726: DECODE(l_demand_class, '-1',
6727: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
6728: null,
6729: null,
6730: p_department_id,
6731: p_resource_id,

Line 6747: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

6743: l_level_id,
6744: S.DEMAND_CLASS), S.DEMAND_CLASS)),
6745: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
6746: 0, TO_CHAR(NULL),
6747: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6748: S.CUSTOMER_ID,
6749: S.SHIP_TO_SITE_ID,
6750: s.inventory_item_id,
6751: p_organization_id,

Line 6768: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(

6764: l_demand_class, 1,
6765: --bug 4156016: If l_demand_class is not null and demand class is populated
6766: -- on supplies record then 0 should be allocated.
6767: Decode (S.Demand_Class, NULL,
6768: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(
6769: -- 2859130 C.CALENDAR_DATE,
6770: -- Bug 3348095
6771: -- For ATP created records use end_date
6772: -- otherwise start_date

Line 6787: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(

6783: DECODE(G_HIERARCHY_PROFILE,
6784: ---2424357
6785: 1, DECODE(S.DEMAND_CLASS, null, null,
6786: DECODE(l_demand_class, '-1',
6787: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
6788: null,
6789: null,
6790: p_department_id,
6791: p_resource_id,

Line 6807: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

6803: l_level_id,
6804: S.DEMAND_CLASS), S.DEMAND_CLASS)),
6805: 2, DECODE(S.CUSTOMER_ID, NULL, l_demand_class,
6806: 0, l_demand_class,
6807: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6808: S.CUSTOMER_ID,
6809: S.SHIP_TO_SITE_ID,
6810: l_inv_item_id,
6811: p_organization_id,

Line 6933: /* NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

6929: MNRA.to_time,to_time + 24*3600,
6930: MNRA.to_time) - MNRA.from_time)/3600) *
6931: DECODE(p_scenario_id, -1, 1, NVL((MRHM.allocation_percent/100), 1)) col24,
6932: --bug 4156016
6933: /* NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
6934: p_instance_id,
6935: null,
6936: p_organization_id,
6937: p_department_id,

Line 7064: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(

7060: DECODE(DECODE(G_HIERARCHY_PROFILE,
7061: --2424357
7062: 1, DECODE(S.DEMAND_CLASS, null, null,
7063: DECODE(l_demand_class, '-1',
7064: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
7065: null,
7066: null,
7067: p_department_id,
7068: p_resource_id,

Line 7076: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

7072: l_level_id,
7073: S.DEMAND_CLASS), S.DEMAND_CLASS)),
7074: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
7075: 0, TO_CHAR(NULL),
7076: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7077: S.CUSTOMER_ID,
7078: S.SHIP_TO_SITE_ID,
7079: s.inventory_item_id,
7080: p_organization_id,

Line 7089: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(

7085: l_demand_class, 1,
7086: --bug 4156016: If l_demand_class is not null and demand class is populated
7087: -- on supplies record then 0 should be allocated.
7088: Decode (S.Demand_Class, NULL,
7089: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(
7090: C.CALENDAR_DATE,
7091: REQ.ASSEMBLY_ITEM_ID,
7092: p_organization_id,
7093: p_instance_id,

Line 7100: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(

7096: DECODE(G_HIERARCHY_PROFILE,
7097: ---2424357
7098: 1, DECODE(S.DEMAND_CLASS, null, null,
7099: DECODE(l_demand_class, '-1',
7100: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
7101: null,
7102: null,
7103: p_department_id,
7104: p_resource_id,

Line 7112: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

7108: l_level_id,
7109: S.DEMAND_CLASS), S.DEMAND_CLASS)),
7110: 2, DECODE(S.CUSTOMER_ID, NULL, l_demand_class,
7111: 0, l_demand_class,
7112: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7113: S.CUSTOMER_ID,
7114: S.SHIP_TO_SITE_ID,
7115: l_inv_item_id,
7116: p_organization_id,

Line 7228: /* NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

7224: MNRA.to_time,to_time + 24*3600,
7225: MNRA.to_time) - MNRA.from_time)/3600) *
7226: DECODE(p_scenario_id, -1, 1, NVL((MRHM.allocation_percent/100), 1)) col24,
7227: --bug 4156016
7228: /* NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
7229: p_instance_id,
7230: null,
7231: p_organization_id,
7232: p_department_id,

Line 7357: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(

7353: DECODE(DECODE(G_HIERARCHY_PROFILE,
7354: --2424357
7355: 1, DECODE(S.DEMAND_CLASS, null, null,
7356: DECODE(l_demand_class, '-1',
7357: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
7358: null,
7359: null,
7360: p_department_id,
7361: p_resource_id,

Line 7377: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

7373: l_level_id,
7374: S.DEMAND_CLASS), S.DEMAND_CLASS)),
7375: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
7376: 0, TO_CHAR(NULL),
7377: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7378: S.CUSTOMER_ID,
7379: S.SHIP_TO_SITE_ID,
7380: s.inventory_item_id,
7381: p_organization_id,

Line 7398: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(

7394: l_demand_class, 1,
7395: --bug 4156016: If l_demand_class is not null and demand class is populated
7396: -- on supplies record then 0 should be allocated.
7397: Decode (S.Demand_Class, NULL,
7398: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(
7399: -- 2859130 C.CALENDAR_DATE,
7400: -- Bug 3348095
7401: -- For ATP created records use end_date
7402: -- otherwise start_date

Line 7417: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(

7413: DECODE(G_HIERARCHY_PROFILE,
7414: --2424357
7415: 1, DECODE(S.DEMAND_CLASS, null, null,
7416: DECODE(l_demand_class, '-1',
7417: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
7418: null,
7419: null,
7420: p_department_id,
7421: p_resource_id,

Line 7437: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

7433: l_level_id,
7434: S.DEMAND_CLASS), S.DEMAND_CLASS)),
7435: 2, DECODE(S.CUSTOMER_ID, NULL, l_demand_class,
7436: 0, l_demand_class,
7437: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7438: S.CUSTOMER_ID,
7439: S.SHIP_TO_SITE_ID,
7440: l_inv_item_id,
7441: p_organization_id,

Line 7556: /* NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

7552: MNRA.to_time,to_time + 24*3600,
7553: MNRA.to_time) - MNRA.from_time)/3600) *
7554: DECODE(p_scenario_id, -1, 1, NVL((MRHM.allocation_percent/100), 1)) col24,
7555: --bug 4156016
7556: /* NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
7557: p_instance_id,
7558: null,
7559: p_organization_id,
7560: p_department_id,

Line 7683: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(

7679: DECODE(DECODE(G_HIERARCHY_PROFILE,
7680: --2424357
7681: 1, DECODE(S.DEMAND_CLASS, null, null,
7682: DECODE(l_demand_class, '-1',
7683: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
7684: null,
7685: null,
7686: p_department_id,
7687: p_resource_id,

Line 7695: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

7691: l_level_id,
7692: S.DEMAND_CLASS), S.DEMAND_CLASS)),
7693: 2, DECODE(S.CUSTOMER_ID, NULL, TO_CHAR(NULL),
7694: 0, TO_CHAR(NULL),
7695: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7696: S.CUSTOMER_ID,
7697: S.SHIP_TO_SITE_ID,
7698: s.inventory_item_id,
7699: p_organization_id,

Line 7708: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(C.CALENDAR_DATE,

7704: l_demand_class, 1,
7705: --bug 4156016: If l_demand_class is not null and demand class is populated
7706: -- on supplies record then 0 should be allocated.
7707: Decode (S.Demand_Class, NULL,
7708: MSC_AATP_FUNC.Get_Res_Demand_Alloc_Percent(C.CALENDAR_DATE,
7709: REQ.ASSEMBLY_ITEM_ID,
7710: p_organization_id,
7711: p_instance_id,
7712: p_department_id,

Line 7718: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(

7714: DECODE(G_HIERARCHY_PROFILE,
7715: --2424357
7716: 1, DECODE(S.DEMAND_CLASS, null, null,
7717: DECODE(l_demand_class, '-1',
7718: MSC_AATP_FUNC.Get_RES_Hierarchy_Demand_Class(
7719: null,
7720: null,
7721: p_department_id,
7722: p_resource_id,

Line 7730: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

7726: l_level_id,
7727: S.DEMAND_CLASS), S.DEMAND_CLASS)),
7728: 2, DECODE(S.CUSTOMER_ID, NULL, l_demand_class,
7729: 0, l_demand_class,
7730: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7731: S.CUSTOMER_ID,
7732: S.SHIP_TO_SITE_ID,
7733: l_inv_item_id,
7734: p_organization_id,

Line 7839: /* NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

7835: MNRA.to_time,to_time + 24*3600,
7836: MNRA.to_time) - MNRA.from_time)/3600) *
7837: DECODE(p_scenario_id, -1, 1, NVL((MRHM.allocation_percent/100), 1)) col24,
7838: --bug 4156016
7839: /* NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
7840: p_instance_id,
7841: null,
7842: p_organization_id,
7843: p_department_id,

Line 8769: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(l_instance_id,

8765: p_sup_atp_info_rec.instance_id, p_sup_atp_info_rec.plan_id,
8766: l_inv_item_id, p_sup_atp_info_rec.organization_id,
8767: p_sup_atp_info_rec.supplier_id, p_sup_atp_info_rec.supplier_site_id,
8768: cs.seq_num - p_sup_atp_info_rec.sysdate_seq_num),0))*
8769: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(l_instance_id,
8770: s.inventory_item_id,
8771: p_sup_atp_info_rec.organization_id,
8772: null,
8773: null,

Line 8824: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

8820: DECODE(DECODE(G_HIERARCHY_PROFILE,
8821: --2424357
8822: 1, DECODE(p.DEMAND_CLASS, null, null,
8823: DECODE(l_demand_class, '-1',
8824: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
8825: null,
8826: null,
8827: p.inventory_item_id,
8828: p.organization_id,

Line 8838: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

8834: l_level_id,
8835: p.DEMAND_CLASS), p.DEMAND_CLASS)),
8836: 2, DECODE(p.CUSTOMER_ID, NULL, TO_CHAR(NULL),
8837: 0, TO_CHAR(NULL),
8838: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
8839: p.CUSTOMER_ID,
8840: p.SHIP_TO_SITE_ID,
8841: p.inventory_item_id,
8842: p.organization_id,

Line 8852: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,

8848: l_level_id,
8849: NULL))),
8850: l_demand_class, 1,
8851: NULL, NVL(MIHM.allocation_percent/100, --4365873
8852: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,
8853: p.inventory_item_id ,
8854: p.organization_id,
8855: null,
8856: null,

Line 8864: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,

8860: p.new_dock_date
8861: ))),*/
8862: 1), --4135752
8863: DECODE(MIHM.allocation_percent/100,
8864: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,
8865: p.inventory_item_id,
8866: p.organization_id,
8867: null,
8868: null,

Line 8929: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(l_instance_id,

8925: p_sup_atp_info_rec.instance_id, p_sup_atp_info_rec.plan_id,
8926: p_sup_atp_info_rec.inventory_item_id, p_sup_atp_info_rec.organization_id,
8927: p_sup_atp_info_rec.supplier_id, p_sup_atp_info_rec.supplier_site_id,
8928: cs.seq_num - p_sup_atp_info_rec.sysdate_seq_num),0))*
8929: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(l_instance_id,
8930: s.inventory_item_id,
8931: p_sup_atp_info_rec.organization_id,
8932: null,
8933: null,

Line 8985: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

8981: DECODE(DECODE(G_HIERARCHY_PROFILE,
8982: --2424357
8983: 1, DECODE(p.DEMAND_CLASS, null, null,
8984: DECODE(l_demand_class, '-1',
8985: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
8986: null,
8987: null,
8988: p.inventory_item_id,
8989: p.organization_id,

Line 8999: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

8995: l_level_id,
8996: p.DEMAND_CLASS), p.DEMAND_CLASS)),
8997: 2, DECODE(p.CUSTOMER_ID, NULL, TO_CHAR(NULL),
8998: 0, TO_CHAR(NULL),
8999: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
9000: p.CUSTOMER_ID,
9001: p.SHIP_TO_SITE_ID,
9002: p.inventory_item_id,
9003: p.organization_id,

Line 9013: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,

9009: l_level_id,
9010: NULL))),
9011: l_demand_class, 1,
9012: NULL, NVL(MIHM.allocation_percent/100, --4365874
9013: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,
9014: p.inventory_item_id ,
9015: p.organization_id,
9016: null,
9017: null,

Line 9025: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,

9021: p.new_dock_date
9022: ))),*/
9023: 1), --4135752
9024: DECODE(MIHM.allocation_percent/100,
9025: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,
9026: p.inventory_item_id,
9027: p.organization_id,
9028: null,
9029: null,

Line 9146: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

9142: p_sup_atp_info_rec.supplier_id,
9143: p_sup_atp_info_rec.supplier_site_id,
9144: cs.seq_num - p_sup_atp_info_rec.sysdate_seq_num),0)) *
9145: NVL(MIHM.allocation_percent/100, --4365873
9146: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
9147: l_instance_id,
9148: s.inventory_item_id,
9149: p_sup_atp_info_rec.organization_id,
9150: null,

Line 9247: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

9243: DECODE(DECODE(G_HIERARCHY_PROFILE,
9244: --2424357
9245: 1, DECODE(p.DEMAND_CLASS, null, null,
9246: DECODE(l_demand_class, '-1',
9247: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
9248: null,
9249: null,
9250: p.inventory_item_id,
9251: p.organization_id,

Line 9261: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

9257: l_level_id,
9258: p.DEMAND_CLASS), p.DEMAND_CLASS)),
9259: 2, DECODE(p.CUSTOMER_ID, NULL, TO_CHAR(NULL),
9260: 0, TO_CHAR(NULL),
9261: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
9262: p.CUSTOMER_ID,
9263: p.SHIP_TO_SITE_ID,
9264: p.inventory_item_id,
9265: p.organization_id,

Line 9275: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,

9271: l_level_id,
9272: NULL))),
9273: l_demand_class, 1,
9274: NULL, NVL(MIHM.allocation_percent/100, --4365873
9275: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,
9276: p.inventory_item_id ,
9277: p.organization_id,
9278: null,
9279: null,

Line 9287: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,

9283: p.new_dock_date
9284: ))),*/
9285: 1),
9286: DECODE(MIHM.allocation_percent/100,
9287: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,
9288: p.inventory_item_id,
9289: p.organization_id,
9290: null,
9291: null,

Line 9431: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

9427: p_sup_atp_info_rec.supplier_id,
9428: p_sup_atp_info_rec.supplier_site_id,
9429: cs.seq_num - p_sup_atp_info_rec.sysdate_seq_num),0)) *
9430: NVL(MIHM.allocation_percent/100, --4365873
9431: /*NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
9432: l_instance_id,
9433: cs.inventory_item_id,
9434: p_sup_atp_info_rec.organization_id,
9435: null,

Line 9530: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

9526: DECODE(DECODE(G_HIERARCHY_PROFILE,
9527: --2424357
9528: 1, DECODE(p.DEMAND_CLASS, null, null,
9529: DECODE(l_demand_class, '-1',
9530: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
9531: null,
9532: null,
9533: p.inventory_item_id,
9534: p.organization_id,

Line 9544: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

9540: l_level_id,
9541: p.DEMAND_CLASS), p.DEMAND_CLASS)),
9542: 2, DECODE(p.CUSTOMER_ID, NULL, TO_CHAR(NULL),
9543: 0, TO_CHAR(NULL),
9544: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
9545: p.CUSTOMER_ID,
9546: p.SHIP_TO_SITE_ID,
9547: p.inventory_item_id,
9548: p.organization_id,

Line 9558: /*NULL, NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,

9554: l_level_id,
9555: NULL))),
9556: l_demand_class, 1,
9557: NULL, NVL(MIHM.allocation_percent/100, --4365873
9558: /*NULL, NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,
9559: p.inventory_item_id ,
9560: p.organization_id,
9561: null,
9562: null,

Line 9570: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,

9566: p.new_dock_date
9567: ))),*/
9568: 1),
9569: DECODE(MIHM.allocation_percent/100,
9570: /*DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p.sr_instance_id,
9571: p.inventory_item_id,
9572: p.organization_id,
9573: null,
9574: null,

Line 10559: l_demand_class := MSC_AATP_FUNC.Get_Hierarchy_Demand_Class

10555: 'Get_Hierarchy_Demand_Class for Demand Class');
10556: END IF;
10557: -- Code for Get_Hierarchy_Demand_Class
10558:
10559: l_demand_class := MSC_AATP_FUNC.Get_Hierarchy_Demand_Class
10560: (
10561: NULL, --partner_id
10562: NULL, --partner_site_id
10563: --p_inventory_item_id,