[Home] [Help]
82: allocated_quantity,
83: pf_display_flag
84: -- time_phased_atp changes end
85: ) VALUES (
86: MSC_ATP_PVT.G_SESSION_ID,
87: x_atp_supply_demand.level(k),
88: x_atp_supply_demand.identifier(k),
89: x_atp_supply_demand.scenario_id(k),
90: x_atp_supply_demand.inventory_item_id(k),
159: GREATEST(
160: TRUNC(DECODE(RECORD_SOURCE,
161: 2,
162: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
163: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
164: 2,
165: (NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
166: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
167: p_sys_next_date)SD_DATE, --plan by request date,promise date, schedule date--3099066
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),
190: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
191: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
192: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
193: --plan by request date,promise date, schedule date
194: p_level_id, D.DEMAND_CLASS),
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,
203: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
204: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
205: p_level_id, D.DEMAND_CLASS), --plan by request date,promise date, schedule date
206: D.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),
214: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
215: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
216: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
217: p_level_id, D.DEMAND_CLASS), --plan by request date,promise date, schedule date
218: D.DEMAND_CLASS)), TO_CHAR(NULL)),
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),
227: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
228: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
229: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
230: p_level_id, D.DEMAND_CLASS), --plan by request date,promise date, schedule date
231: D.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),
239: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
240: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
241: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
242: p_level_id, D.DEMAND_CLASS), --plan by request date,promise date, schedule date
243: D.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),
251: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
252: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
253: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
254: p_level_id, D.DEMAND_CLASS), --plan by request date,promise date, schedule date
255: D.DEMAND_CLASS)), TO_CHAR(NULL)),
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),
263: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
264: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
265: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
266: p_level_id, D.DEMAND_CLASS), --plan by request date,promise date, schedule date
267: D.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),
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),
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(
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,
297: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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)),
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),
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),
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),
325: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
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,
335: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
336: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))))--plan by request date,promise date, schedule date
337: ,p_level_id, NULL)))),
338: -- rajjain end 07/19/2002
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,
347: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
348: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
349: D.USING_ASSEMBLY_ITEM_ID,
350: DECODE(D.SOURCE_ORGANIZATION_ID,
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),
377: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
378: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
379: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
380: p_level_id, D.DEMAND_CLASS),
381: D.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),
389: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
390: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
391: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
392: p_level_id, D.DEMAND_CLASS),
393: D.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),
401: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
402: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
403: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
404: p_level_id, D.DEMAND_CLASS),
405: D.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),
415: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
416: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
417: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
418: p_level_id, D.DEMAND_CLASS),
419: D.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),
427: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
428: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
429: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
430: p_level_id, D.DEMAND_CLASS),
431: D.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),
439: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
440: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
441: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), --plan by request date,promise date, schedule date
442: p_level_id, D.DEMAND_CLASS),
443: D.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),
452: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
453: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
454: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))))--plan by request date,promise date, schedule date
455: , p_level_id, D.DEMAND_CLASS),
456: D.DEMAND_CLASS))),
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,
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(
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,
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(
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,
484: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
485: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
486: p_level_id, NULL),
487: p_demand_class),
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,
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(
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,
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(
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,
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,
519: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
520: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),p_level_id, NULL)))),
521: -- rajjain end 07/19/2002
522: p_demand_class,
549: -- C.PRIOR_DATE + 1)
550: --bug3693892 added trunc
551: AND TRUNC(DECODE(RECORD_SOURCE,
552: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
553: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
554: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
555: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))) <
556: TRUNC(NVL(p_itf,DECODE(RECORD_SOURCE,
557: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
554: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
555: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))) <
556: TRUNC(NVL(p_itf,DECODE(RECORD_SOURCE,
557: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
558: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
559: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
560: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))+1))
561: UNION ALL
562: SELECT --C.NEXT_DATE SD_DATE, -- 2859130
913: -- Bug 3550296 and 3574164. IMPLEMENT_DATE AND DMD_SATISFIED_DATE are changed to
914: -- IMPLEMENT_SHIP_DATE and PLANNED_SHIP_DATE resp.
915: BETWEEN TRUNC(DECODE(RECORD_SOURCE,
916: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
917: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
918: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
919: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))))
920: AND TRUNC(NVL(D.ASSEMBLY_DEMAND_COMP_DATE,
921: DECODE(RECORD_SOURCE,
919: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))))
920: AND TRUNC(NVL(D.ASSEMBLY_DEMAND_COMP_DATE,
921: DECODE(RECORD_SOURCE,
922: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
923: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
924: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
925: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))))
926: AND (( D.ORIGINATION_TYPE = 4
927: AND C.SEQ_NUM IS NOT NULL) OR
1070: GREATEST(
1071: TRUNC(DECODE(RECORD_SOURCE,
1072: 2,
1073: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1074: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1075: 2,
1076: (NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1077: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))))
1078: ,p_sys_next_date) SD_DATE, --3099066 --plan by request date
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,
1102: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
1112: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
1122: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1123: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1124: D.DEMAND_CLASS)), TO_CHAR(NULL)),
1125: 30, decode(d.source_organization_id,
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,
1133: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
1143: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
1153: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
1163: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1164: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1165: D.DEMAND_CLASS))),
1166: -- rajjain end
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,
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(
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,
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(
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,
1193: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1194: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1195: p_level_id, NULL),
1196: TO_CHAR(NULL)),
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,
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(
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,
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(
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,
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,
1228: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
1238: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1239: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1240: D.USING_ASSEMBLY_ITEM_ID,
1241: DECODE(D.SOURCE_ORGANIZATION_ID,
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,
1268: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
1278: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
1288: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1289: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1290: D.DEMAND_CLASS)),
1291: p_demand_class),
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,
1300: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
1310: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
1320: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1321: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1322: D.DEMAND_CLASS)),
1323: p_demand_class),
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,
1331: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1332: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
1333: D.DEMAND_CLASS))),
1334: -- rajjain end
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,
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(
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,
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(
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,
1361: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1362: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
1363: p_level_id, NULL),
1364: p_demand_class),
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,
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(
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,
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(
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,
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,
1396: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1397: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),p_level_id, NULL)))),
1398: -- rajjain end 07/19/2002
1399: p_demand_class,
1425: -- C.PRIOR_DATE + 1)
1426: --bug3693892 added trunc
1427: AND TRUNC(DECODE(RECORD_SOURCE,
1428: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1429: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1430: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1431: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))) <
1432: TRUNC(NVL(p_itf,DECODE(RECORD_SOURCE,
1433: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1430: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1431: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))) <
1432: TRUNC(NVL(p_itf,DECODE(RECORD_SOURCE,
1433: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1434: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1435: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1436: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))) + 1))
1437: UNION ALL
1438: SELECT -- C.NEXT_DATE SD_DATE, -- 2859130
1792: -- Bug 3550296 and 3574164. IMPLEMENT_DATE AND DMD_SATISFIED_DATE are changed to
1793: -- IMPLEMENT_SHIP_DATE and PLANNED_SHIP_DATE resp.
1794: AND C.CALENDAR_DATE BETWEEN TRUNC(DECODE(RECORD_SOURCE,
1795: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1796: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1797: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1798: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))) AND
1799: TRUNC(NVL(D.ASSEMBLY_DEMAND_COMP_DATE,
1800: DECODE(RECORD_SOURCE,
1798: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))) AND
1799: TRUNC(NVL(D.ASSEMBLY_DEMAND_COMP_DATE,
1800: DECODE(RECORD_SOURCE,
1801: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1802: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1803: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1804: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))))
1805: AND (( D.ORIGINATION_TYPE = 4
1806: AND C.SEQ_NUM IS NOT NULL) OR
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
2029: -- IMPLEMENT_SHIP_DATE and PLANNED_SHIP_DATE resp.
2030: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2031: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
2041: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
2051: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2052: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2053: D.DEMAND_CLASS)), NULL),
2054: 30, decode(d.source_organization_id,
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,
2062: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
2072: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
2082: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
2092: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2093: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2094: D.DEMAND_CLASS))),
2095: -- rajjain end
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,
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(
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,
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(
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,
2122: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2123: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2124: p_level_id, NULL),
2125: NULL),
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,
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(
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,
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(
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,
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,
2157: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
2167: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2168: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2169: D.USING_ASSEMBLY_ITEM_ID,
2170: DECODE(D.SOURCE_ORGANIZATION_ID,
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,
2197: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
2207: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
2217: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2218: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2219: D.DEMAND_CLASS)),
2220: p_demand_class),
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,
2229: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
2239: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
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,
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,
2249: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2250: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2251: D.DEMAND_CLASS)),
2252: p_demand_class),
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,
2260: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2261: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), p_level_id, D.DEMAND_CLASS),
2262: D.DEMAND_CLASS))),
2263: -- rajjain end
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,
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(
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,
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(
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,
2290: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2291: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2292: p_level_id, NULL),
2293: p_demand_class),
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,
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(
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,
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(
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,
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,
2325: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2326: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),p_level_id, NULL)))),
2327: -- rajjain end 07/19/2002
2328: p_demand_class,
2332: -1* (D.USING_REQUIREMENT_QUANTITY - nvl(d.reserved_quantity,0)),--5027568
2333: -- C.PRIOR_DATE col25, -- 2859130
2334: GREATEST(TRUNC(DECODE(RECORD_SOURCE,
2335: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2336: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2337: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2338: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2339: p_sys_next_date) col25, --plan by request date --3099066
2340: l_null_num col26,
2392: -- IMPLEMENT_SHIP_DATE and PLANNED_SHIP_DATE resp.
2393: --bug3693892 added trunc
2394: AND TRUNC(DECODE(RECORD_SOURCE,
2395: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2396: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2397: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2398: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))))
2399: < TRUNC(NVL(p_itf,DECODE(RECORD_SOURCE,
2400: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2397: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2398: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))))
2399: < TRUNC(NVL(p_itf,DECODE(RECORD_SOURCE,
2400: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2401: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2402: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2403: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))) + 1))
2404: -- AND C.CALENDAR_DATE < NVL(p_itf, C.CALENDAR_DATE+1)
2405: UNION ALL
2898: -- Bug 3550296 and 3574164. IMPLEMENT_DATE AND DMD_SATISFIED_DATE are changed to
2899: -- IMPLEMENT_SHIP_DATE and PLANNED_SHIP_DATE resp.
2900: AND C.CALENDAR_DATE BETWEEN TRUNC(DECODE(RECORD_SOURCE,
2901: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2902: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2903: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2904: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))) AND
2905: TRUNC(NVL(D.ASSEMBLY_DEMAND_COMP_DATE,
2906: DECODE(RECORD_SOURCE,
2904: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))) AND
2905: TRUNC(NVL(D.ASSEMBLY_DEMAND_COMP_DATE,
2906: DECODE(RECORD_SOURCE,
2907: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2908: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2909: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2910: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))))
2911: AND (( D.ORIGINATION_TYPE = 4
2912: AND C.SEQ_NUM IS NOT NULL) OR
3608:
3609: -- time_phased_atp
3610: IF (p_inventory_item_id <> p_request_item_id and p_atf_date is not null) THEN
3611: l_time_phased_atp := 'Y';
3612: l_pf_item_id := MSC_ATP_PVT.G_ITEM_INFO_REC.product_family_id;
3613: END IF;
3614:
3615: -- rajjain 01/29/2003 begin Bug 2737596
3616: IF p_identifier = -1 THEN
3629: END IF;
3630: END;
3631: ELSE
3632: -- we need not select this in case of ATP QUERY as this information is available in G_ITEM_INFO_REC
3633: l_inv_item_id := MSC_ATP_PVT.G_ITEM_INFO_REC.inventory_item_id;
3634: l_uom_code := MSC_ATP_PVT.G_ITEM_INFO_REC.uom_code;
3635: END IF;
3636: -- rajjain 01/29/2003 end Bug 2737596
3637:
3630: END;
3631: ELSE
3632: -- we need not select this in case of ATP QUERY as this information is available in G_ITEM_INFO_REC
3633: l_inv_item_id := MSC_ATP_PVT.G_ITEM_INFO_REC.inventory_item_id;
3634: l_uom_code := MSC_ATP_PVT.G_ITEM_INFO_REC.uom_code;
3635: END IF;
3636: -- rajjain 01/29/2003 end Bug 2737596
3637:
3638: /* New allocation logic for time_phased_atp changes begin
3639: For time phased ATP scenarios if allocation rule at member item is not defined then within ATF use
3640: allocation rule defined at family */
3641: IF l_time_phased_atp = 'Y' THEN
3642: IF p_request_date <= p_atf_date THEN
3643: IF MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF = 'Y' THEN
3644: l_item_to_use := l_inv_item_id;
3645: ELSE
3646: l_item_to_use := l_pf_item_id;
3647: END IF;
3851: WHILE mm is not null LOOP
3852:
3853: msc_sch_wb.atp_debug('---------------------l_demand_class_tab'||l_demand_class_tab(mm));--6359986
3854: IF (l_demand_class_tab(mm) ='-1') then --6359986
3855: IF(MSC_ATP_PVT.G_ZERO_ALLOCATION_PERC = 'N') THEN --6359986
3856: IF l_allocation_percent_tab(mm) <> 0 THEN
3857: l_lowest_priority_demand_class := l_demand_class_tab(mm);
3858: l_lowest_priority := l_demand_class_priority_tab(mm);
3859: IF PG_DEBUG in ('Y', 'C') THEN
3891: END LOOP;
3892: ELSIF l_level_id in (2, 3) THEN
3893: WHILE mm is not null LOOP
3894: IF (REPLACE(l_demand_class_tab(mm),FND_GLOBAL.LOCAL_CHR(13),' ') in ('-1','-1 -1 -1','-1 -1')) then --6359986
3895: IF(MSC_ATP_PVT.G_ZERO_ALLOCATION_PERC = 'N') THEN ----6359986
3896: IF l_allocation_percent_tab(mm) <> 0 THEN
3897: -- this is the lowest demand class with non zero allocation percentage
3898: l_fw_consume_tab(mm) := 4;
3899: l_lowest_priority_demand_class := l_demand_class_tab(mm);
4047: -- krajan: 04/01/02 Added l_org_code to call.
4048: /* Modularize Item and Org Info */
4049: -- changed Call
4050: MSC_ATP_PROC.get_global_org_info(p_instance_id, p_organization_id);
4051: l_default_atp_rule_id := MSC_ATP_PVT.G_ORG_INFO_REC.default_atp_rule_id;
4052: l_calendar_code := MSC_ATP_PVT.G_ORG_INFO_REC.cal_code;
4053: l_calendar_exception_set_id := MSC_ATP_PVT.G_ORG_INFO_REC.cal_exception_set_id;
4054: l_default_demand_class := MSC_ATP_PVT.G_ORG_INFO_REC.default_demand_class;
4055: l_org_code := MSC_ATP_PVT.G_ORG_INFO_REC.org_code;
4048: /* Modularize Item and Org Info */
4049: -- changed Call
4050: MSC_ATP_PROC.get_global_org_info(p_instance_id, p_organization_id);
4051: l_default_atp_rule_id := MSC_ATP_PVT.G_ORG_INFO_REC.default_atp_rule_id;
4052: l_calendar_code := MSC_ATP_PVT.G_ORG_INFO_REC.cal_code;
4053: l_calendar_exception_set_id := MSC_ATP_PVT.G_ORG_INFO_REC.cal_exception_set_id;
4054: l_default_demand_class := MSC_ATP_PVT.G_ORG_INFO_REC.default_demand_class;
4055: l_org_code := MSC_ATP_PVT.G_ORG_INFO_REC.org_code;
4056: /* Modularize Item and Org Info */
4049: -- changed Call
4050: MSC_ATP_PROC.get_global_org_info(p_instance_id, p_organization_id);
4051: l_default_atp_rule_id := MSC_ATP_PVT.G_ORG_INFO_REC.default_atp_rule_id;
4052: l_calendar_code := MSC_ATP_PVT.G_ORG_INFO_REC.cal_code;
4053: l_calendar_exception_set_id := MSC_ATP_PVT.G_ORG_INFO_REC.cal_exception_set_id;
4054: l_default_demand_class := MSC_ATP_PVT.G_ORG_INFO_REC.default_demand_class;
4055: l_org_code := MSC_ATP_PVT.G_ORG_INFO_REC.org_code;
4056: /* Modularize Item and Org Info */
4057:
4050: MSC_ATP_PROC.get_global_org_info(p_instance_id, p_organization_id);
4051: l_default_atp_rule_id := MSC_ATP_PVT.G_ORG_INFO_REC.default_atp_rule_id;
4052: l_calendar_code := MSC_ATP_PVT.G_ORG_INFO_REC.cal_code;
4053: l_calendar_exception_set_id := MSC_ATP_PVT.G_ORG_INFO_REC.cal_exception_set_id;
4054: l_default_demand_class := MSC_ATP_PVT.G_ORG_INFO_REC.default_demand_class;
4055: l_org_code := MSC_ATP_PVT.G_ORG_INFO_REC.org_code;
4056: /* Modularize Item and Org Info */
4057:
4058: IF PG_DEBUG in ('Y', 'C') THEN
4051: l_default_atp_rule_id := MSC_ATP_PVT.G_ORG_INFO_REC.default_atp_rule_id;
4052: l_calendar_code := MSC_ATP_PVT.G_ORG_INFO_REC.cal_code;
4053: l_calendar_exception_set_id := MSC_ATP_PVT.G_ORG_INFO_REC.cal_exception_set_id;
4054: l_default_demand_class := MSC_ATP_PVT.G_ORG_INFO_REC.default_demand_class;
4055: l_org_code := MSC_ATP_PVT.G_ORG_INFO_REC.org_code;
4056: /* Modularize Item and Org Info */
4057:
4058: IF PG_DEBUG in ('Y', 'C') THEN
4059: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'l_default_atp_rule_id='|| l_default_atp_rule_id);
5425: x_atp_info.atp_period.EXTEND;
5426:
5427: i := x_atp_info.atp_qty.COUNT;
5428: x_atp_info.atp_period(i) := l_infinite_time_fence_date;
5429: x_atp_info.atp_qty(i) := MSC_ATP_PVT.INFINITE_NUMBER;
5430: --x_atp_info.limit_qty(i) := MSC_ATP_PVT.INFINITE_NUMBER;
5431:
5432:
5433: IF NVL(p_insert_flag, 0) <> 0 THEN
5426:
5427: i := x_atp_info.atp_qty.COUNT;
5428: x_atp_info.atp_period(i) := l_infinite_time_fence_date;
5429: x_atp_info.atp_qty(i) := MSC_ATP_PVT.INFINITE_NUMBER;
5430: --x_atp_info.limit_qty(i) := MSC_ATP_PVT.INFINITE_NUMBER;
5431:
5432:
5433: IF NVL(p_insert_flag, 0) <> 0 THEN
5434: -- add one more entry to indicate infinite time fence date and quantity.
5455: x_atp_period.Inventory_Item_Id(j) := p_inventory_item_id;
5456: x_atp_period.Request_Item_Id(j) := p_inventory_item_id;
5457: x_atp_period.Organization_id(j) := p_organization_id;
5458: x_atp_period.Period_Start_Date(j) := l_infinite_time_fence_date;
5459: x_atp_period.Total_Supply_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
5460: x_atp_period.Total_Demand_Quantity(j) := 0;
5461: -- time_phased_atp
5462: x_atp_period.Total_Bucketed_Demand_Quantity(j) := 0;
5463: x_atp_period.Period_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
5459: x_atp_period.Total_Supply_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
5460: x_atp_period.Total_Demand_Quantity(j) := 0;
5461: -- time_phased_atp
5462: x_atp_period.Total_Bucketed_Demand_Quantity(j) := 0;
5463: x_atp_period.Period_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
5464: x_atp_period.Cumulative_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
5465:
5466: END IF;
5467: END IF;
5460: x_atp_period.Total_Demand_Quantity(j) := 0;
5461: -- time_phased_atp
5462: x_atp_period.Total_Bucketed_Demand_Quantity(j) := 0;
5463: x_atp_period.Period_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
5464: x_atp_period.Cumulative_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
5465:
5466: END IF;
5467: END IF;
5468: --END IF;
5810:
5811: /* Modularize Item and Org Info */
5812: -- changed call
5813: MSC_ATP_PROC.get_global_org_info(p_instance_id, p_organization_id);
5814: l_default_atp_rule_id := MSC_ATP_PVT.G_ORG_INFO_REC.default_atp_rule_id;
5815: l_calendar_code := MSC_ATP_PVT.G_ORG_INFO_REC.cal_code;
5816: l_calendar_exception_set_id := MSC_ATP_PVT.G_ORG_INFO_REC.cal_exception_set_id;
5817: l_default_demand_class := MSC_ATP_PVT.G_ORG_INFO_REC.default_demand_class;
5818: l_org_code := MSC_ATP_PVT.G_ORG_INFO_REC.org_code;
5811: /* Modularize Item and Org Info */
5812: -- changed call
5813: MSC_ATP_PROC.get_global_org_info(p_instance_id, p_organization_id);
5814: l_default_atp_rule_id := MSC_ATP_PVT.G_ORG_INFO_REC.default_atp_rule_id;
5815: l_calendar_code := MSC_ATP_PVT.G_ORG_INFO_REC.cal_code;
5816: l_calendar_exception_set_id := MSC_ATP_PVT.G_ORG_INFO_REC.cal_exception_set_id;
5817: l_default_demand_class := MSC_ATP_PVT.G_ORG_INFO_REC.default_demand_class;
5818: l_org_code := MSC_ATP_PVT.G_ORG_INFO_REC.org_code;
5819: /* Modularize Item and Org Info */
5812: -- changed call
5813: MSC_ATP_PROC.get_global_org_info(p_instance_id, p_organization_id);
5814: l_default_atp_rule_id := MSC_ATP_PVT.G_ORG_INFO_REC.default_atp_rule_id;
5815: l_calendar_code := MSC_ATP_PVT.G_ORG_INFO_REC.cal_code;
5816: l_calendar_exception_set_id := MSC_ATP_PVT.G_ORG_INFO_REC.cal_exception_set_id;
5817: l_default_demand_class := MSC_ATP_PVT.G_ORG_INFO_REC.default_demand_class;
5818: l_org_code := MSC_ATP_PVT.G_ORG_INFO_REC.org_code;
5819: /* Modularize Item and Org Info */
5820: --bug3333114 start
5813: MSC_ATP_PROC.get_global_org_info(p_instance_id, p_organization_id);
5814: l_default_atp_rule_id := MSC_ATP_PVT.G_ORG_INFO_REC.default_atp_rule_id;
5815: l_calendar_code := MSC_ATP_PVT.G_ORG_INFO_REC.cal_code;
5816: l_calendar_exception_set_id := MSC_ATP_PVT.G_ORG_INFO_REC.cal_exception_set_id;
5817: l_default_demand_class := MSC_ATP_PVT.G_ORG_INFO_REC.default_demand_class;
5818: l_org_code := MSC_ATP_PVT.G_ORG_INFO_REC.org_code;
5819: /* Modularize Item and Org Info */
5820: --bug3333114 start
5821: l_sys_next_date := MSC_CALENDAR.NEXT_WORK_DAY (
5814: l_default_atp_rule_id := MSC_ATP_PVT.G_ORG_INFO_REC.default_atp_rule_id;
5815: l_calendar_code := MSC_ATP_PVT.G_ORG_INFO_REC.cal_code;
5816: l_calendar_exception_set_id := MSC_ATP_PVT.G_ORG_INFO_REC.cal_exception_set_id;
5817: l_default_demand_class := MSC_ATP_PVT.G_ORG_INFO_REC.default_demand_class;
5818: l_org_code := MSC_ATP_PVT.G_ORG_INFO_REC.org_code;
5819: /* Modularize Item and Org Info */
5820: --bug3333114 start
5821: l_sys_next_date := MSC_CALENDAR.NEXT_WORK_DAY (
5822: l_calendar_code,
5828: END IF;
5829:
5830: IF (l_sys_next_date is NULL) THEN
5831: msc_sch_wb.atp_debug('Sys Next Date is null');
5832: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.NO_MATCHING_CAL_DATE;
5833: RAISE FND_API.G_EXC_ERROR;
5834: END IF;
5835: --bug3333114 end
5836:
8341: --x_atp_info.limit_qty.EXTEND;
8342:
8343: i := x_atp_info.atp_qty.COUNT;
8344: x_atp_info.atp_period(i) := l_infinite_time_fence_date;
8345: x_atp_info.atp_qty(i) := MSC_ATP_PVT.INFINITE_NUMBER;
8346: --x_atp_info.limit_qty(i) := MSC_ATP_PVT.INFINITE_NUMBER;
8347:
8348: IF NVL(p_insert_flag, 0) <> 0 THEN
8349: -- add one more entry to indicate infinite time fence date
8342:
8343: i := x_atp_info.atp_qty.COUNT;
8344: x_atp_info.atp_period(i) := l_infinite_time_fence_date;
8345: x_atp_info.atp_qty(i) := MSC_ATP_PVT.INFINITE_NUMBER;
8346: --x_atp_info.limit_qty(i) := MSC_ATP_PVT.INFINITE_NUMBER;
8347:
8348: IF NVL(p_insert_flag, 0) <> 0 THEN
8349: -- add one more entry to indicate infinite time fence date
8350: -- and quantity.
8371: x_atp_period.Department_Id(j) := p_department_id;
8372: x_atp_period.Resource_Id(j) := p_resource_id;
8373: x_atp_period.Organization_id(j) := p_organization_id;
8374: x_atp_period.Period_Start_Date(j) := l_infinite_time_fence_date;
8375: x_atp_period.Total_Supply_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
8376: x_atp_period.Total_Demand_Quantity(j) := 0;
8377: x_atp_period.Period_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
8378: x_atp_period.Cumulative_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
8379:
8373: x_atp_period.Organization_id(j) := p_organization_id;
8374: x_atp_period.Period_Start_Date(j) := l_infinite_time_fence_date;
8375: x_atp_period.Total_Supply_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
8376: x_atp_period.Total_Demand_Quantity(j) := 0;
8377: x_atp_period.Period_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
8378: x_atp_period.Cumulative_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
8379:
8380: END IF;
8381: END IF;
8374: x_atp_period.Period_Start_Date(j) := l_infinite_time_fence_date;
8375: x_atp_period.Total_Supply_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
8376: x_atp_period.Total_Demand_Quantity(j) := 0;
8377: x_atp_period.Period_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
8378: x_atp_period.Cumulative_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
8379:
8380: END IF;
8381: END IF;
8382: -- END IF;
8497: -- FROM msc_plans
8498: -- WHERE plan_id = p_sup_atp_info_rec.plan_id;
8499:
8500: -- Instead re-assigned local values using global variable
8501: l_plan_start_date := MSC_ATP_PVT.G_PLAN_INFO_REC.plan_start_date;
8502: l_instance_id := MSC_ATP_PVT.G_PLAN_INFO_REC.sr_instance_id;
8503: l_org_id := MSC_ATP_PVT.G_PLAN_INFO_REC.organization_id;
8504: l_cutoff_date := MSC_ATP_PVT.G_PLAN_INFO_REC.plan_cutoff_date;
8505:
8498: -- WHERE plan_id = p_sup_atp_info_rec.plan_id;
8499:
8500: -- Instead re-assigned local values using global variable
8501: l_plan_start_date := MSC_ATP_PVT.G_PLAN_INFO_REC.plan_start_date;
8502: l_instance_id := MSC_ATP_PVT.G_PLAN_INFO_REC.sr_instance_id;
8503: l_org_id := MSC_ATP_PVT.G_PLAN_INFO_REC.organization_id;
8504: l_cutoff_date := MSC_ATP_PVT.G_PLAN_INFO_REC.plan_cutoff_date;
8505:
8506: IF PG_DEBUG in ('Y', 'C') THEN
8499:
8500: -- Instead re-assigned local values using global variable
8501: l_plan_start_date := MSC_ATP_PVT.G_PLAN_INFO_REC.plan_start_date;
8502: l_instance_id := MSC_ATP_PVT.G_PLAN_INFO_REC.sr_instance_id;
8503: l_org_id := MSC_ATP_PVT.G_PLAN_INFO_REC.organization_id;
8504: l_cutoff_date := MSC_ATP_PVT.G_PLAN_INFO_REC.plan_cutoff_date;
8505:
8506: IF PG_DEBUG in ('Y', 'C') THEN
8507: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'l_plan_start_date = '||l_plan_start_date);
8500: -- Instead re-assigned local values using global variable
8501: l_plan_start_date := MSC_ATP_PVT.G_PLAN_INFO_REC.plan_start_date;
8502: l_instance_id := MSC_ATP_PVT.G_PLAN_INFO_REC.sr_instance_id;
8503: l_org_id := MSC_ATP_PVT.G_PLAN_INFO_REC.organization_id;
8504: l_cutoff_date := MSC_ATP_PVT.G_PLAN_INFO_REC.plan_cutoff_date;
8505:
8506: IF PG_DEBUG in ('Y', 'C') THEN
8507: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'l_plan_start_date = '||l_plan_start_date);
8508: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'l_instance_id = '||l_instance_id);
8713: END IF;
8714:
8715: IF (l_sys_next_date is NULL) THEN
8716: msc_sch_wb.atp_debug('Sys Next Date is null');
8717: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.NO_MATCHING_CAL_DATE;
8718: RAISE FND_API.G_EXC_ERROR;
8719: END IF;
8720: --bug3333114 end
8721:
10092: x_atp_info.limit_qty.EXTEND;
10093:
10094: i := x_atp_info.atp_qty.COUNT;
10095: x_atp_info.atp_period(i) := l_last_cap_next_date;
10096: x_atp_info.atp_qty(i) := MSC_ATP_PVT.INFINITE_NUMBER;
10097: ---x_atp_info.limit_qty(i) := MSC_ATP_PVT.INFINITE_NUMBER;
10098:
10099:
10100: IF NVL(p_sup_atp_info_rec.insert_flag, 0) <> 0 THEN
10093:
10094: i := x_atp_info.atp_qty.COUNT;
10095: x_atp_info.atp_period(i) := l_last_cap_next_date;
10096: x_atp_info.atp_qty(i) := MSC_ATP_PVT.INFINITE_NUMBER;
10097: ---x_atp_info.limit_qty(i) := MSC_ATP_PVT.INFINITE_NUMBER;
10098:
10099:
10100: IF NVL(p_sup_atp_info_rec.insert_flag, 0) <> 0 THEN
10101: -- add one more entry to indicate infinite time fence date
10120: x_atp_period.Supplier_Id(j) := p_sup_atp_info_rec.supplier_id;
10121: x_atp_period.Supplier_site_id(j) := p_sup_atp_info_rec.supplier_site_id;
10122: x_atp_period.Organization_id(j) := p_sup_atp_info_rec.organization_id;
10123: x_atp_period.Period_Start_Date(j) := l_infinite_time_fence_date;
10124: x_atp_period.Total_Supply_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
10125: x_atp_period.Total_Demand_Quantity(j) := 0;
10126: x_atp_period.Period_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
10127: x_atp_period.Cumulative_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
10128:
10122: x_atp_period.Organization_id(j) := p_sup_atp_info_rec.organization_id;
10123: x_atp_period.Period_Start_Date(j) := l_infinite_time_fence_date;
10124: x_atp_period.Total_Supply_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
10125: x_atp_period.Total_Demand_Quantity(j) := 0;
10126: x_atp_period.Period_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
10127: x_atp_period.Cumulative_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
10128:
10129: END IF;
10130: END IF; */
10123: x_atp_period.Period_Start_Date(j) := l_infinite_time_fence_date;
10124: x_atp_period.Total_Supply_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
10125: x_atp_period.Total_Demand_Quantity(j) := 0;
10126: x_atp_period.Period_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
10127: x_atp_period.Cumulative_Quantity(j) := MSC_ATP_PVT.INFINITE_NUMBER;
10128:
10129: END IF;
10130: END IF; */
10131: -- END IF;
10348: l_max_capacity NUMBER;
10349: l_res_conversion_rate number :=1;
10350: l_res_uom varchar2(3);
10351: l_res_uom_type NUMBER;
10352: l_plan_info_rec MSC_ATP_PVT.plan_info_rec; -- added for bug 2392456
10353:
10354: --diag_atp
10355: l_get_mat_in_rec MSC_ATP_REQ.get_mat_in_rec;
10356:
10373:
10374: -- Bug 2396523 : krajan : Added debug messages
10375: IF PG_DEBUG in ('Y', 'C') THEN
10376: msc_sch_wb.atp_debug('View_Allocation: ' || 'P_DEMAND_CLASS ' || p_demand_class);
10377: msc_sch_wb.atp_debug('View_Allocation: ' || 'G_INV_CTP= ' || MSC_ATP_PVT.G_INV_CTP);
10378: msc_sch_wb.atp_debug('View_Allocation: ' || 'G_HIERARCHY_PROFILE = '|| MSC_ATP_PVT.G_HIERARCHY_PROFILE );
10379: msc_sch_wb.atp_debug('View_Allocation: ' || 'G_ALLOCATED_ATP = ' || MSC_ATP_PVT.G_ALLOCATED_ATP );
10380: msc_sch_wb.atp_debug('View_Allocation: ' || 'G_ALLOCATION_METHOD = '|| MSC_ATP_PVT.G_ALLOCATION_METHOD );
10381: END IF;
10374: -- Bug 2396523 : krajan : Added debug messages
10375: IF PG_DEBUG in ('Y', 'C') THEN
10376: msc_sch_wb.atp_debug('View_Allocation: ' || 'P_DEMAND_CLASS ' || p_demand_class);
10377: msc_sch_wb.atp_debug('View_Allocation: ' || 'G_INV_CTP= ' || MSC_ATP_PVT.G_INV_CTP);
10378: msc_sch_wb.atp_debug('View_Allocation: ' || 'G_HIERARCHY_PROFILE = '|| MSC_ATP_PVT.G_HIERARCHY_PROFILE );
10379: msc_sch_wb.atp_debug('View_Allocation: ' || 'G_ALLOCATED_ATP = ' || MSC_ATP_PVT.G_ALLOCATED_ATP );
10380: msc_sch_wb.atp_debug('View_Allocation: ' || 'G_ALLOCATION_METHOD = '|| MSC_ATP_PVT.G_ALLOCATION_METHOD );
10381: END IF;
10382:
10375: IF PG_DEBUG in ('Y', 'C') THEN
10376: msc_sch_wb.atp_debug('View_Allocation: ' || 'P_DEMAND_CLASS ' || p_demand_class);
10377: msc_sch_wb.atp_debug('View_Allocation: ' || 'G_INV_CTP= ' || MSC_ATP_PVT.G_INV_CTP);
10378: msc_sch_wb.atp_debug('View_Allocation: ' || 'G_HIERARCHY_PROFILE = '|| MSC_ATP_PVT.G_HIERARCHY_PROFILE );
10379: msc_sch_wb.atp_debug('View_Allocation: ' || 'G_ALLOCATED_ATP = ' || MSC_ATP_PVT.G_ALLOCATED_ATP );
10380: msc_sch_wb.atp_debug('View_Allocation: ' || 'G_ALLOCATION_METHOD = '|| MSC_ATP_PVT.G_ALLOCATION_METHOD );
10381: END IF;
10382:
10383: -- krajan : 2400676
10376: msc_sch_wb.atp_debug('View_Allocation: ' || 'P_DEMAND_CLASS ' || p_demand_class);
10377: msc_sch_wb.atp_debug('View_Allocation: ' || 'G_INV_CTP= ' || MSC_ATP_PVT.G_INV_CTP);
10378: msc_sch_wb.atp_debug('View_Allocation: ' || 'G_HIERARCHY_PROFILE = '|| MSC_ATP_PVT.G_HIERARCHY_PROFILE );
10379: msc_sch_wb.atp_debug('View_Allocation: ' || 'G_ALLOCATED_ATP = ' || MSC_ATP_PVT.G_ALLOCATED_ATP );
10380: msc_sch_wb.atp_debug('View_Allocation: ' || 'G_ALLOCATION_METHOD = '|| MSC_ATP_PVT.G_ALLOCATION_METHOD );
10381: END IF;
10382:
10383: -- krajan : 2400676
10384: IF PG_DEBUG in ('Y', 'C') THEN
10405: IF (l_request_date = NULL) THEN
10406: IF PG_DEBUG in ('Y', 'C') THEN
10407: msc_sch_wb.atp_debug('View_Allocation: ' || 'Request date is null');
10408: END IF;
10409: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.NO_MATCHING_CAL_DATE;
10410: RAISE FND_API.G_EXC_ERROR;
10411: END IF;
10412:
10413: --Check if the request is for Item or Department-Resource.
10425: -- New procedure for obtaining plan data : Supplier Capacity Lead Time (SCLT) proj.
10426: MSC_ATP_PROC.get_global_plan_info(p_instance_id, p_inventory_item_id,
10427: p_organization_id, p_demand_class);
10428:
10429: l_plan_info_rec := MSC_ATP_PVT.G_PLAN_INFO_REC;
10430: -- End New procedure for obtaining plan data : Supplier Capacity Lead Time proj.
10431:
10432: l_plan_id := l_plan_info_rec.plan_id;
10433: l_assign_set_id := l_plan_info_rec.assignment_set_id;
10442: IF (l_plan_id IS NULL) OR (l_plan_id = -1) THEN
10443: IF PG_DEBUG in ('Y', 'C') THEN
10444: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Plan_ID is null or -1');
10445: END IF;
10446: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.PLAN_NOT_FOUND;
10447: RAISE FND_API.G_EXC_ERROR;
10448: END IF;
10449:
10450: IF (l_plan_id = -100) THEN
10450: IF (l_plan_id = -100) THEN
10451: IF PG_DEBUG in ('Y', 'C') THEN
10452: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Plan_ID is -100 : Summary Running');
10453: END IF;
10454: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.SUMM_CONC_PROG_RUNNING;
10455: RAISE FND_API.G_EXC_ERROR;
10456: END IF;
10457:
10458: IF (l_plan_id = -200) THEN
10458: IF (l_plan_id = -200) THEN
10459: IF PG_DEBUG in ('Y', 'C') THEN
10460: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Plan_ID is -200 : Summary Running');
10461: END IF;
10462: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.RUN_POST_PLAN_ALLOC;
10463: RAISE FND_API.G_EXC_ERROR;
10464: END IF;
10465:
10466:
10477: -- toatl ATP and demand class to be null
10478:
10479: -- Agilent Allocated ATP Based on Planning Details changes Begin
10480:
10481: IF ((MSC_ATP_PVT.G_HIERARCHY_PROFILE <> 1) OR
10482: ((MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10483: (MSC_ATP_PVT.G_ALLOCATION_METHOD <> 1))) THEN
10484:
10485: -- Original Code
10478:
10479: -- Agilent Allocated ATP Based on Planning Details changes Begin
10480:
10481: IF ((MSC_ATP_PVT.G_HIERARCHY_PROFILE <> 1) OR
10482: ((MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10483: (MSC_ATP_PVT.G_ALLOCATION_METHOD <> 1))) THEN
10484:
10485: -- Original Code
10486:
10479: -- Agilent Allocated ATP Based on Planning Details changes Begin
10480:
10481: IF ((MSC_ATP_PVT.G_HIERARCHY_PROFILE <> 1) OR
10482: ((MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10483: (MSC_ATP_PVT.G_ALLOCATION_METHOD <> 1))) THEN
10484:
10485: -- Original Code
10486:
10487: MSC_AATP_PVT.Item_Alloc_Cum_Atp(
10501: --diag_atp
10502: l_get_mat_in_rec,
10503: p_inventory_item_id, -- time_phased_atp passing p_inventory_item_id for compilation
10504: NULL); -- time_phased_atp passing null for compilation
10505: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
10506: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
10507: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10508: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
10509:
10502: l_get_mat_in_rec,
10503: p_inventory_item_id, -- time_phased_atp passing p_inventory_item_id for compilation
10504: NULL); -- time_phased_atp passing null for compilation
10505: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
10506: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
10507: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10508: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
10509:
10510: IF PG_DEBUG in ('Y', 'C') THEN
10503: p_inventory_item_id, -- time_phased_atp passing p_inventory_item_id for compilation
10504: NULL); -- time_phased_atp passing null for compilation
10505: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
10506: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
10507: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10508: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
10509:
10510: IF PG_DEBUG in ('Y', 'C') THEN
10511: msc_sch_wb.atp_debug('View_Allocation: before '||
10504: NULL); -- time_phased_atp passing null for compilation
10505: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
10506: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
10507: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10508: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
10509:
10510: IF PG_DEBUG in ('Y', 'C') THEN
10511: msc_sch_wb.atp_debug('View_Allocation: before '||
10512: 'calling Item_Pre_Allocated_Atp for Totals');
10544: ELSE
10545:
10546: -- Agilent Allocated ATP Based on Planning Details changes Begin
10547:
10548: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
10549: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
10550: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10551: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
10552:
10545:
10546: -- Agilent Allocated ATP Based on Planning Details changes Begin
10547:
10548: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
10549: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
10550: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10551: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
10552:
10553: IF PG_DEBUG in ('Y', 'C') THEN
10546: -- Agilent Allocated ATP Based on Planning Details changes Begin
10547:
10548: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
10549: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
10550: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10551: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
10552:
10553: IF PG_DEBUG in ('Y', 'C') THEN
10554: msc_sch_wb.atp_debug('View_Allocation: before calling '||
10547:
10548: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
10549: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
10550: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10551: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
10552:
10553: IF PG_DEBUG in ('Y', 'C') THEN
10554: msc_sch_wb.atp_debug('View_Allocation: before calling '||
10555: 'Get_Hierarchy_Demand_Class for Demand Class');
10594: NULL); -- time_phased_atp - Added for compilation
10595:
10596: -- Bug 2396523 : krajan. Commented out and added ELSIF
10597: --ELSE -- Original Code
10598: ELSIF ((MSC_ATP_PVT.G_HIERARCHY_PROFILE <> 1) OR
10599: ((MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10600: (MSC_ATP_PVT.G_ALLOCATION_METHOD <> 1))) THEN
10601:
10602: MSC_AATP_PVT.Item_Alloc_Cum_Atp(
10595:
10596: -- Bug 2396523 : krajan. Commented out and added ELSIF
10597: --ELSE -- Original Code
10598: ELSIF ((MSC_ATP_PVT.G_HIERARCHY_PROFILE <> 1) OR
10599: ((MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10600: (MSC_ATP_PVT.G_ALLOCATION_METHOD <> 1))) THEN
10601:
10602: MSC_AATP_PVT.Item_Alloc_Cum_Atp(
10603: l_plan_id,
10596: -- Bug 2396523 : krajan. Commented out and added ELSIF
10597: --ELSE -- Original Code
10598: ELSIF ((MSC_ATP_PVT.G_HIERARCHY_PROFILE <> 1) OR
10599: ((MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10600: (MSC_ATP_PVT.G_ALLOCATION_METHOD <> 1))) THEN
10601:
10602: MSC_AATP_PVT.Item_Alloc_Cum_Atp(
10603: l_plan_id,
10604: 0, --p_level(for top level item)
10661: WHEN NO_DATA_FOUND THEN
10662: IF PG_DEBUG in ('Y', 'C') THEN
10663: msc_sch_wb.atp_debug('View_Allocation: ' || 'Plan not found ');
10664: END IF;
10665: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.PLAN_NOT_FOUND;
10666: RAISE FND_API.G_EXC_ERROR;
10667: WHEN others THEN
10668: IF PG_DEBUG in ('Y', 'C') THEN
10669: msc_sch_wb.atp_debug('View_Allocation: ' || 'Error getting plan id :'||sqlcode);
10667: WHEN others THEN
10668: IF PG_DEBUG in ('Y', 'C') THEN
10669: msc_sch_wb.atp_debug('View_Allocation: ' || 'Error getting plan id :'||sqlcode);
10670: END IF;
10671: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
10672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10673: END;
10674:
10675: IF PG_DEBUG in ('Y', 'C') THEN
10717: END IF;
10718:
10719: -- Agilent Allocated ATP Based on Planning Details changes Begin
10720:
10721: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
10722: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
10723: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10724: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
10725:
10718:
10719: -- Agilent Allocated ATP Based on Planning Details changes Begin
10720:
10721: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
10722: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
10723: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10724: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
10725:
10726: l_demand_class := NULL;
10719: -- Agilent Allocated ATP Based on Planning Details changes Begin
10720:
10721: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
10722: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
10723: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10724: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
10725:
10726: l_demand_class := NULL;
10727:
10720:
10721: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
10722: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
10723: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10724: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
10725:
10726: l_demand_class := NULL;
10727:
10728: ELSE -- original_code
10798:
10799: -- krajan : 2400676
10800: IF (l_atp_period.period_quantity.COUNT = 0) THEN
10801: -- rajjain bug 2951786 05/13/2003
10802: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.NO_SUPPLY_DEMAND;
10803: -- MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
10804: IF PG_DEBUG in ('Y', 'C') THEN
10805: msc_sch_wb.atp_debug ('View_Allocation: ' || 'l_atp_period is NULL');
10806: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Error Code: ' || MSC_SCH_WB.G_ATP_ERROR_CODE);
10799: -- krajan : 2400676
10800: IF (l_atp_period.period_quantity.COUNT = 0) THEN
10801: -- rajjain bug 2951786 05/13/2003
10802: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.NO_SUPPLY_DEMAND;
10803: -- MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
10804: IF PG_DEBUG in ('Y', 'C') THEN
10805: msc_sch_wb.atp_debug ('View_Allocation: ' || 'l_atp_period is NULL');
10806: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Error Code: ' || MSC_SCH_WB.G_ATP_ERROR_CODE);
10807: END IF;
10840: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10841: IF PG_DEBUG in ('Y', 'C') THEN
10842: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Something wrong in call to PUT_INTO_TEMP_TABLE');
10843: END IF;
10844: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
10845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10846: END IF;*/
10847:
10848: -- rajjain 01/29/2003 begin Bug 2737596
10876: msc_sch_wb.atp_debug ('Error in View_Allocation: Expected Error Raised');
10877: END IF;
10878: x_return_status := FND_API.G_RET_STS_ERROR;
10879: IF (MSC_SCH_WB.G_ATP_ERROR_CODE = 0) THEN
10880: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
10881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10882: END IF;
10883:
10884: WHEN MSC_ATP_PUB.ATP_INVALID_OBJECTS_FOUND THEN
10884: WHEN MSC_ATP_PUB.ATP_INVALID_OBJECTS_FOUND THEN
10885: IF PG_DEBUG in ('Y', 'C') THEN
10886: msc_sch_wb.atp_debug ('Error in View_Allocation: Invalid Objects Found');
10887: END IF;
10888: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_INVALID_OBJECTS;
10889: x_return_status := FND_API.G_RET_STS_ERROR;
10890:
10891: WHEN OTHERS THEN
10892: IF PG_DEBUG in ('Y', 'C') THEN
10893: msc_sch_wb.atp_debug ('Error in View_Allocation');
10894: END IF;
10895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10896: IF (MSC_SCH_WB.G_ATP_ERROR_CODE = 0) THEN
10897: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
10898: END IF;
10899:
10900: END View_allocation;
10901:
10952: --diag_atp
10953: L_GET_MAT_IN_REC MSC_ATP_REQ.GET_MAT_IN_REC;
10954: l_get_mat_out_rec MSC_ATP_REQ.get_mat_out_rec;
10955:
10956: l_item_info_rec MSC_ATP_PVT.item_attribute_rec;
10957:
10958: -- time_phased_atp
10959: l_time_phased_atp VARCHAR2(1) := 'N';
10960: l_mem_stealing_qty NUMBER := 0;
10985: IF (p_atp_record.inventory_item_id <> p_atp_record.request_item_id) and
10986: p_atp_record.atf_date is not null THEN
10987: l_time_phased_atp := 'Y';
10988: l_process_item_id := p_atp_record.request_item_id;
10989: l_pf_item_id := MSC_ATP_PVT.G_ITEM_INFO_REC.product_family_id;
10990: IF PG_DEBUG in ('Y', 'C') THEN
10991: msc_sch_wb.atp_debug('Stealing: ' || 'Time Phased ATP = ' || l_time_phased_atp);
10992: msc_sch_wb.atp_debug('Stealing: ' || 'ATF Date = ' || p_atp_record.atf_date);
10993: msc_sch_wb.atp_debug('Stealing: ' || 'l_pf_item_id = ' || l_pf_item_id);
11004: p_plan_id,
11005: l_process_item_id,
11006: p_atp_record.organization_id,
11007: l_item_info_rec );
11008: l_inv_item_id := MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id;
11009: /*l_inv_item_id := MSC_ATP_FUNC.get_inv_item_id (p_atp_record.instance_id,
11010: p_atp_record.request_item_id,
11011: null,
11012: p_atp_record.organization_id);
11014:
11015: /* New allocation logic for time_phased_atp changes begin */
11016: IF l_time_phased_atp = 'Y' THEN
11017: IF p_atp_record.requested_ship_date <= p_atp_record.atf_date THEN
11018: IF MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF = 'Y' THEN
11019: l_item_to_use := l_inv_item_id;
11020: ELSE
11021: l_item_to_use := l_pf_item_id;
11022: END IF;
11020: ELSE
11021: l_item_to_use := l_pf_item_id;
11022: END IF;
11023: ELSE
11024: IF MSC_ATP_PVT.G_PF_RULE_OUTSIDE_ATF = 'Y' THEN
11025: l_item_to_use := l_pf_item_id;
11026: ELSE
11027: l_item_to_use := l_inv_item_id;
11028: END IF;
11172: IF PG_DEBUG in ('Y', 'C') THEN
11173: msc_sch_wb.atp_debug('Stealing: ' || 'l_demand_class_tab_new.count = '||l_demand_class_tab_new.count);--6359986
11174: END IF;
11175: --diag_atp
11176: l_get_mat_in_rec.rounding_control_flag := MSC_ATP_PVT.G_ITEM_INFO_REC.rounding_control_type;
11177: l_get_mat_in_rec.dest_inv_item_id := l_inv_item_id;
11178: --6359986 start
11179: --bug5974491:Others with allocation 0% will be considered valid or invalid demand class
11180:
11183:
11184: IF (REPLACE(l_demand_class_tab_new(i),FND_GLOBAL.LOCAL_CHR(13),' ') in ('-1','-1 -1 -1','-1 -1') ) then
11185:
11186:
11187: IF(MSC_ATP_PVT.G_ZERO_ALLOCATION_PERC = 'N') then
11188: IF l_allocation_percent_tab(i) <> 0 THEN
11189: l_demand_class_tab.EXTEND;
11190: l_demand_class_priority_tab.EXTEND;
11191: l_demand_class_tab(i) := l_demand_class_tab_new(i);
11275:
11276: IF p_atp_record.requested_date_quantity > 0 THEN
11277:
11278: -- time_phased_atp changes begin
11279: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
11280: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
11281: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
11282: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1) ) THEN
11283:
11276: IF p_atp_record.requested_date_quantity > 0 THEN
11277:
11278: -- time_phased_atp changes begin
11279: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
11280: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
11281: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
11282: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1) ) THEN
11283:
11284: IF l_time_phased_atp = 'N' THEN
11277:
11278: -- time_phased_atp changes begin
11279: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
11280: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
11281: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
11282: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1) ) THEN
11283:
11284: IF l_time_phased_atp = 'N' THEN
11285: l_stealing_quantity := LEAST(
11278: -- time_phased_atp changes begin
11279: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
11280: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
11281: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
11282: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1) ) THEN
11283:
11284: IF l_time_phased_atp = 'N' THEN
11285: l_stealing_quantity := LEAST(
11286: p_atp_record.requested_date_quantity,
11394: -- for performance reason, we call these function here and
11395: -- then populate the pegging tree with the values
11396:
11397: /* Modularize Item and Org Info */
11398: l_inv_item_name := MSC_ATP_PVT.G_ITEM_INFO_REC.item_name;
11399: /*l_inv_item_name := MSC_ATP_FUNC.get_inv_item_name(p_atp_record.instance_id,
11400: p_atp_record.inventory_item_id,
11401: p_atp_record.organization_id);
11402: Modularize Item and Org Info */
11403:
11404: /* Modularize Item and Org Info */
11405: MSC_ATP_PROC.get_global_org_info (p_atp_record.instance_id,
11406: p_atp_record.organization_id );
11407: l_org_code := MSC_ATP_PVT.G_ORG_INFO_REC.org_code;
11408: IF PG_DEBUG in ('Y', 'C') THEN
11409: msc_sch_wb.atp_debug('Stealing: ' || 'Modular Use Org_code : '||l_org_code);
11410: END IF;
11411: /*l_org_code := MSC_ATP_FUNC.get_org_code(p_atp_record.instance_id,
11411: /*l_org_code := MSC_ATP_FUNC.get_org_code(p_atp_record.instance_id,
11412: p_atp_record.organization_id);
11413: Modularize Item and Org Info */
11414:
11415: l_pegging_rec.session_id:= MSC_ATP_PVT.G_SESSION_ID;
11416: l_pegging_rec.order_line_id:= MSC_ATP_PVT.G_ORDER_LINE_ID;
11417: -- l_pegging_rec.parent_pegging_id:= l_pegging_id;
11418: l_pegging_rec.parent_pegging_id:= p_parent_pegging_id;
11419: l_pegging_rec.atp_level:= p_level + 1;
11412: p_atp_record.organization_id);
11413: Modularize Item and Org Info */
11414:
11415: l_pegging_rec.session_id:= MSC_ATP_PVT.G_SESSION_ID;
11416: l_pegging_rec.order_line_id:= MSC_ATP_PVT.G_ORDER_LINE_ID;
11417: -- l_pegging_rec.parent_pegging_id:= l_pegging_id;
11418: l_pegging_rec.parent_pegging_id:= p_parent_pegging_id;
11419: l_pegging_rec.atp_level:= p_level + 1;
11420: l_pegging_rec.organization_id:= p_atp_record.organization_id;
11451: l_pegging_rec.supplier_name := NULL;
11452: l_pegging_rec.supplier_site_id := NULL;
11453: l_pegging_rec.supplier_site_name := NULL;
11454: l_pegging_rec.scenario_id:= p_scenario_id;
11455: l_pegging_rec.supply_demand_source_type:= MSC_ATP_PVT.ATP;
11456: l_pegging_rec.supply_demand_quantity:=
11457: p_atp_record.requested_date_quantity;
11458: l_pegging_rec.supply_demand_date:= p_atp_record.requested_ship_date;
11459: l_pegging_rec.supply_demand_type:= 2;
11479: IF PG_DEBUG in ('Y', 'C') THEN
11480: msc_sch_wb.atp_debug('Stealing: l_pegging_rec.allocated_quantity = ' ||l_pegging_rec.allocated_quantity);
11481: END IF;
11482: l_pegging_rec.component_identifier :=
11483: NVL(p_atp_record.component_identifier, MSC_ATP_PVT.G_COMP_LINE_ID);
11484:
11485: -- for demo:1153192
11486: IF ((p_search = 1)
11487: AND ( p_atp_record.quantity_ordered >=
11497: l_pegging_rec.required_quantity:= p_net_demand;
11498: l_pegging_rec.required_date := p_atp_record.requested_ship_date;
11499: l_pegging_rec.infinite_time_fence := l_get_mat_out_rec.infinite_time_fence_date;
11500: l_pegging_rec.atp_rule_name := l_get_mat_out_rec.atp_rule_name;
11501: l_pegging_rec.rounding_control := MSC_ATP_PVT.G_ITEM_INFO_REC.rounding_control_type;
11502: l_pegging_rec.atp_flag := MSC_ATP_PVT.G_ITEM_INFO_REC.atp_flag;
11503: l_pegging_rec.atp_component_flag := MSC_ATP_PVT.G_ITEM_INFO_REC.atp_comp_flag;
11504: l_pegging_rec.pegging_type := 3; ---atp supply node
11505: l_pegging_rec.postprocessing_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.post_pro_lt;
11498: l_pegging_rec.required_date := p_atp_record.requested_ship_date;
11499: l_pegging_rec.infinite_time_fence := l_get_mat_out_rec.infinite_time_fence_date;
11500: l_pegging_rec.atp_rule_name := l_get_mat_out_rec.atp_rule_name;
11501: l_pegging_rec.rounding_control := MSC_ATP_PVT.G_ITEM_INFO_REC.rounding_control_type;
11502: l_pegging_rec.atp_flag := MSC_ATP_PVT.G_ITEM_INFO_REC.atp_flag;
11503: l_pegging_rec.atp_component_flag := MSC_ATP_PVT.G_ITEM_INFO_REC.atp_comp_flag;
11504: l_pegging_rec.pegging_type := 3; ---atp supply node
11505: l_pegging_rec.postprocessing_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.post_pro_lt;
11506: l_pegging_rec.preprocessing_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.pre_pro_lt;
11499: l_pegging_rec.infinite_time_fence := l_get_mat_out_rec.infinite_time_fence_date;
11500: l_pegging_rec.atp_rule_name := l_get_mat_out_rec.atp_rule_name;
11501: l_pegging_rec.rounding_control := MSC_ATP_PVT.G_ITEM_INFO_REC.rounding_control_type;
11502: l_pegging_rec.atp_flag := MSC_ATP_PVT.G_ITEM_INFO_REC.atp_flag;
11503: l_pegging_rec.atp_component_flag := MSC_ATP_PVT.G_ITEM_INFO_REC.atp_comp_flag;
11504: l_pegging_rec.pegging_type := 3; ---atp supply node
11505: l_pegging_rec.postprocessing_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.post_pro_lt;
11506: l_pegging_rec.preprocessing_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.pre_pro_lt;
11507: l_pegging_rec.fixed_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.fixed_lt;
11501: l_pegging_rec.rounding_control := MSC_ATP_PVT.G_ITEM_INFO_REC.rounding_control_type;
11502: l_pegging_rec.atp_flag := MSC_ATP_PVT.G_ITEM_INFO_REC.atp_flag;
11503: l_pegging_rec.atp_component_flag := MSC_ATP_PVT.G_ITEM_INFO_REC.atp_comp_flag;
11504: l_pegging_rec.pegging_type := 3; ---atp supply node
11505: l_pegging_rec.postprocessing_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.post_pro_lt;
11506: l_pegging_rec.preprocessing_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.pre_pro_lt;
11507: l_pegging_rec.fixed_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.fixed_lt;
11508: l_pegging_rec.variable_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.variable_lt;
11509: l_pegging_rec.weight_capacity := MSC_ATP_PVT.G_ITEM_INFO_REC.unit_weight;
11502: l_pegging_rec.atp_flag := MSC_ATP_PVT.G_ITEM_INFO_REC.atp_flag;
11503: l_pegging_rec.atp_component_flag := MSC_ATP_PVT.G_ITEM_INFO_REC.atp_comp_flag;
11504: l_pegging_rec.pegging_type := 3; ---atp supply node
11505: l_pegging_rec.postprocessing_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.post_pro_lt;
11506: l_pegging_rec.preprocessing_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.pre_pro_lt;
11507: l_pegging_rec.fixed_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.fixed_lt;
11508: l_pegging_rec.variable_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.variable_lt;
11509: l_pegging_rec.weight_capacity := MSC_ATP_PVT.G_ITEM_INFO_REC.unit_weight;
11510: l_pegging_rec.volume_capacity := MSC_ATP_PVT.G_ITEM_INFO_REC.unit_volume;
11503: l_pegging_rec.atp_component_flag := MSC_ATP_PVT.G_ITEM_INFO_REC.atp_comp_flag;
11504: l_pegging_rec.pegging_type := 3; ---atp supply node
11505: l_pegging_rec.postprocessing_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.post_pro_lt;
11506: l_pegging_rec.preprocessing_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.pre_pro_lt;
11507: l_pegging_rec.fixed_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.fixed_lt;
11508: l_pegging_rec.variable_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.variable_lt;
11509: l_pegging_rec.weight_capacity := MSC_ATP_PVT.G_ITEM_INFO_REC.unit_weight;
11510: l_pegging_rec.volume_capacity := MSC_ATP_PVT.G_ITEM_INFO_REC.unit_volume;
11511: l_pegging_rec.weight_uom := MSC_ATP_PVT.G_ITEM_INFO_REC.weight_uom;
11504: l_pegging_rec.pegging_type := 3; ---atp supply node
11505: l_pegging_rec.postprocessing_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.post_pro_lt;
11506: l_pegging_rec.preprocessing_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.pre_pro_lt;
11507: l_pegging_rec.fixed_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.fixed_lt;
11508: l_pegging_rec.variable_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.variable_lt;
11509: l_pegging_rec.weight_capacity := MSC_ATP_PVT.G_ITEM_INFO_REC.unit_weight;
11510: l_pegging_rec.volume_capacity := MSC_ATP_PVT.G_ITEM_INFO_REC.unit_volume;
11511: l_pegging_rec.weight_uom := MSC_ATP_PVT.G_ITEM_INFO_REC.weight_uom;
11512: l_pegging_rec.volume_uom := MSC_ATP_PVT.G_ITEM_INFO_REC.volume_uom;
11505: l_pegging_rec.postprocessing_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.post_pro_lt;
11506: l_pegging_rec.preprocessing_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.pre_pro_lt;
11507: l_pegging_rec.fixed_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.fixed_lt;
11508: l_pegging_rec.variable_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.variable_lt;
11509: l_pegging_rec.weight_capacity := MSC_ATP_PVT.G_ITEM_INFO_REC.unit_weight;
11510: l_pegging_rec.volume_capacity := MSC_ATP_PVT.G_ITEM_INFO_REC.unit_volume;
11511: l_pegging_rec.weight_uom := MSC_ATP_PVT.G_ITEM_INFO_REC.weight_uom;
11512: l_pegging_rec.volume_uom := MSC_ATP_PVT.G_ITEM_INFO_REC.volume_uom;
11513: l_pegging_rec.allocation_rule := MSC_ATP_PVT.G_ALLOCATION_RULE_NAME;
11506: l_pegging_rec.preprocessing_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.pre_pro_lt;
11507: l_pegging_rec.fixed_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.fixed_lt;
11508: l_pegging_rec.variable_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.variable_lt;
11509: l_pegging_rec.weight_capacity := MSC_ATP_PVT.G_ITEM_INFO_REC.unit_weight;
11510: l_pegging_rec.volume_capacity := MSC_ATP_PVT.G_ITEM_INFO_REC.unit_volume;
11511: l_pegging_rec.weight_uom := MSC_ATP_PVT.G_ITEM_INFO_REC.weight_uom;
11512: l_pegging_rec.volume_uom := MSC_ATP_PVT.G_ITEM_INFO_REC.volume_uom;
11513: l_pegging_rec.allocation_rule := MSC_ATP_PVT.G_ALLOCATION_RULE_NAME;
11514:
11507: l_pegging_rec.fixed_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.fixed_lt;
11508: l_pegging_rec.variable_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.variable_lt;
11509: l_pegging_rec.weight_capacity := MSC_ATP_PVT.G_ITEM_INFO_REC.unit_weight;
11510: l_pegging_rec.volume_capacity := MSC_ATP_PVT.G_ITEM_INFO_REC.unit_volume;
11511: l_pegging_rec.weight_uom := MSC_ATP_PVT.G_ITEM_INFO_REC.weight_uom;
11512: l_pegging_rec.volume_uom := MSC_ATP_PVT.G_ITEM_INFO_REC.volume_uom;
11513: l_pegging_rec.allocation_rule := MSC_ATP_PVT.G_ALLOCATION_RULE_NAME;
11514:
11515: l_pegging_rec.summary_flag := MSC_ATP_PVT.G_SUMMARY_FLAG; -- for summary enhancement
11508: l_pegging_rec.variable_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.variable_lt;
11509: l_pegging_rec.weight_capacity := MSC_ATP_PVT.G_ITEM_INFO_REC.unit_weight;
11510: l_pegging_rec.volume_capacity := MSC_ATP_PVT.G_ITEM_INFO_REC.unit_volume;
11511: l_pegging_rec.weight_uom := MSC_ATP_PVT.G_ITEM_INFO_REC.weight_uom;
11512: l_pegging_rec.volume_uom := MSC_ATP_PVT.G_ITEM_INFO_REC.volume_uom;
11513: l_pegging_rec.allocation_rule := MSC_ATP_PVT.G_ALLOCATION_RULE_NAME;
11514:
11515: l_pegging_rec.summary_flag := MSC_ATP_PVT.G_SUMMARY_FLAG; -- for summary enhancement
11516: l_pegging_rec.demand_class := l_demand_class;
11509: l_pegging_rec.weight_capacity := MSC_ATP_PVT.G_ITEM_INFO_REC.unit_weight;
11510: l_pegging_rec.volume_capacity := MSC_ATP_PVT.G_ITEM_INFO_REC.unit_volume;
11511: l_pegging_rec.weight_uom := MSC_ATP_PVT.G_ITEM_INFO_REC.weight_uom;
11512: l_pegging_rec.volume_uom := MSC_ATP_PVT.G_ITEM_INFO_REC.volume_uom;
11513: l_pegging_rec.allocation_rule := MSC_ATP_PVT.G_ALLOCATION_RULE_NAME;
11514:
11515: l_pegging_rec.summary_flag := MSC_ATP_PVT.G_SUMMARY_FLAG; -- for summary enhancement
11516: l_pegging_rec.demand_class := l_demand_class;
11517: -- Bug 3826234 start
11511: l_pegging_rec.weight_uom := MSC_ATP_PVT.G_ITEM_INFO_REC.weight_uom;
11512: l_pegging_rec.volume_uom := MSC_ATP_PVT.G_ITEM_INFO_REC.volume_uom;
11513: l_pegging_rec.allocation_rule := MSC_ATP_PVT.G_ALLOCATION_RULE_NAME;
11514:
11515: l_pegging_rec.summary_flag := MSC_ATP_PVT.G_SUMMARY_FLAG; -- for summary enhancement
11516: l_pegging_rec.demand_class := l_demand_class;
11517: -- Bug 3826234 start
11518: IF PG_DEBUG in ('Y', 'C') THEN
11519: msc_sch_wb.atp_debug('ATP_Check: ' || '----------- Calendars passed to Pegging -----------------');
11522: msc_sch_wb.atp_debug('ATP_Check: ' || 'intransit_cal_code = ' ||p_atp_record.intransit_cal_code);
11523: msc_sch_wb.atp_debug('ATP_Check: ' || 'manufacturing_cal_code = ' ||p_atp_record.manufacturing_cal_code);
11524: msc_sch_wb.atp_debug('ATP_Check: ' || 'to_organization_id = ' ||p_atp_record.to_organization_id);
11525: END IF;
11526: IF p_parent_pegging_id = MSC_ATP_PVT.G_DEMAND_PEGGING_ID THEN
11527: l_pegging_rec.shipping_cal_code := p_atp_record.shipping_cal_code;
11528: l_pegging_rec.receiving_cal_code := p_atp_record.receiving_cal_code;
11529: l_pegging_rec.intransit_cal_code := p_atp_record.intransit_cal_code;
11530: l_pegging_rec.manufacturing_cal_code := p_atp_record.manufacturing_cal_code;
11555: -- Add pegging_id to the l_atp_period and l_atp_supply_demand
11556:
11557: FOR i in 1..l_atp_period.Level.COUNT LOOP
11558: l_atp_period.Pegging_Id(i) := l_atp_pegging_id;
11559: l_atp_period.End_Pegging_Id(i) := MSC_ATP_PVT.G_DEMAND_PEGGING_ID;
11560: END LOOP;
11561:
11562: -- dsting: supply/demand details pl/sql table no longer used
11563: /* FOR i in 1..l_atp_supply_demand.Level.COUNT LOOP
11561:
11562: -- dsting: supply/demand details pl/sql table no longer used
11563: /* FOR i in 1..l_atp_supply_demand.Level.COUNT LOOP
11564: l_atp_supply_demand.Pegging_Id(i) := l_atp_pegging_id;
11565: l_atp_supply_demand.End_Pegging_Id(i) := MSC_ATP_PVT.G_DEMAND_PEGGING_ID;
11566: END LOOP;
11567: */
11568:
11569: IF p_atp_record.insert_flag <> 0 THEN
11567: */
11568:
11569: IF p_atp_record.insert_flag <> 0 THEN
11570: MSC_ATP_DB_UTILS.move_SD_temp_into_mrp_details(l_atp_pegging_id,
11571: MSC_ATP_PVT.G_DEMAND_PEGGING_ID);
11572: END IF;
11573:
11574: MSC_ATP_PROC.Details_Output(l_atp_period,
11575: l_atp_supply_demand,