[Home] [Help]
52: , pt.start_date task_start_date
53: , pt.completion_date task_end_date
54: , wdj.project_id project_id
55: , wdj.task_id task_id
56: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(wdj.scheduled_start_date
57: ,'BETWEEN'
58: ,0
59: ,pp.start_date,pp.completion_date
60: ,pt.start_date,pt.completion_date
58: ,0
59: ,pp.start_date,pp.completion_date
60: ,pt.start_date,pt.completion_date
61: ) exception_days1
62: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(wdj.scheduled_completion_date
63: ,'BETWEEN'
64: ,0
65: ,pp.start_date,pp.completion_date
66: ,pt.start_date,pt.completion_date
87: and pp.project_id = wdj.project_id
88: and ( c_project_from is null or pp.project_id >= c_project_from )
89: and ( c_project_to is null or pp.project_id <= c_project_to )
90: and ((
91: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(wdj.scheduled_start_date
92: ,'BETWEEN'
93: ,n_tolerance_days
94: ,pp.start_date
95: ,pp.completion_date
99: and wdj.scheduled_start_date
100: between nvl( fnd_date.canonical_to_date(d_date_from), wdj.scheduled_start_date - 1)
101: and nvl( fnd_date.canonical_to_date(d_date_to) , wdj.scheduled_start_date + 1)
102: ) or (
103: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(wdj.scheduled_completion_date
104: ,'BETWEEN'
105: ,n_tolerance_days
106: ,pp.start_date
107: ,pp.completion_date
141: , pt.task_number task_number
142: , pt.task_name task_name
143: , pt.start_date task_start_date
144: , pt.completion_date task_end_date
145: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(ool.request_date
146: ,'BETWEEN'
147: ,0
148: ,pp.start_date
149: ,pp.completion_date
149: ,pp.completion_date
150: ,pt.start_date
151: ,pt.completion_date
152: ) exception_days1
153: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(ool.promise_date
154: ,'BETWEEN'
155: ,0
156: ,pp.start_date
157: ,pp.completion_date
180: and pp.project_id = ool.project_id
181: and ( c_project_from is null or pp.project_id >= c_project_from )
182: and ( c_project_to is null or pp.project_id <= c_project_to )
183: and ((
184: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(ool.request_date
185: ,'BETWEEN'
186: ,n_tolerance_days
187: ,pp.start_date
188: ,pp.completion_date
192: and ool.request_date
193: between nvl( fnd_date.canonical_to_date(d_date_from), ool.request_date - 1)
194: and nvl( fnd_date.canonical_to_date(d_date_to) , ool.request_date + 1)
195: ) or (
196: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(ool.promise_date
197: ,'BETWEEN'
198: ,n_tolerance_days
199: ,pp.start_date
200: ,pp.completion_date
228: , pt.task_name task_name
229: , pt.start_date task_start_date
230: , pt.completion_date task_end_date
231: , mfd.transaction_id transaction_id
232: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(mfd.forecast_date
233: ,'BETWEEN'
234: ,0
235: ,pp.start_date
236: ,pp.completion_date
236: ,pp.completion_date
237: ,pt.start_date
238: ,pt.completion_date
239: ) exception_days1
240: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(mfd.rate_end_date
241: ,'BETWEEN'
242: ,0
243: ,pp.start_date
244: ,pp.completion_date
262: and pp.project_id = mfd.project_id
263: and ( c_project_from is null or pp.project_id >= c_project_from )
264: and ( c_project_to is null or pp.project_id <= c_project_to )
265: and ((
266: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(mfd.forecast_date
267: ,'BETWEEN'
268: ,n_tolerance_days
269: ,pp.start_date
270: ,pp.completion_date
274: and mfd.forecast_date
275: between nvl( fnd_date.canonical_to_date(d_date_from), mfd.forecast_date - 1)
276: and nvl( fnd_date.canonical_to_date(d_date_to) , mfd.forecast_date + 1)
277: ) or (
278: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(mfd.rate_end_date
279: ,'BETWEEN'
280: ,n_tolerance_days
281: ,pp.start_date
282: ,pp.completion_date
313: , pt.task_number task_number
314: , pt.task_name task_name
315: , pt.start_date task_start_date
316: , pt.completion_date task_end_date
317: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(prl.need_by_date
318: ,'BETWEEN'
319: ,0
320: ,pp.start_date
321: ,pp.completion_date
343: and ( c_item_to is null or mif.item_number <= c_item_to )
344: and pp.project_id = prd.project_id
345: and ( c_project_from is null or pp.project_id >= c_project_from )
346: and ( c_project_to is null or pp.project_id <= c_project_to )
347: and PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(prl.need_by_date
348: ,'BETWEEN'
349: ,n_tolerance_days
350: ,pp.start_date
351: ,pp.completion_date
380: , pt.task_number task_number
381: , pt.task_name task_name
382: , pt.start_date task_start_date
383: , pt.completion_date task_end_date
384: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(ph.reply_date
385: ,'BEFORE_END'
386: ,0
387: ,pp.start_date
388: ,pp.completion_date
412: and ( c_item_to is null or mif.item_number <= c_item_to )
413: and pp.project_id = pl.project_id
414: and ( c_project_from is null or pp.project_id >= c_project_from )
415: and ( c_project_to is null or pp.project_id <= c_project_to )
416: and PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(ph.reply_date
417: ,'BEFORE_END'
418: ,n_tolerance_days
419: ,pp.start_date
420: ,pp.completion_date
449: , pt.task_number task_number
450: , pt.task_name task_name
451: , pt.start_date task_start_date
452: , pt.completion_date task_end_date
453: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(ph.start_date
454: ,'BEFORE_END'
455: ,0
456: ,pp.start_date
457: ,pp.completion_date
457: ,pp.completion_date
458: ,pt.start_date
459: ,pt.completion_date
460: ) exception_days1
461: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(ph.end_date
462: ,'AFTER_END'
463: ,0
464: ,pp.start_date
465: ,pp.completion_date
490: and pp.project_id = pl.project_id
491: and ( c_project_from is null or pp.project_id >= c_project_from )
492: and ( c_project_to is null or pp.project_id <= c_project_to )
493: and ((
494: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(ph.start_date
495: ,'BEFORE_END'
496: ,n_tolerance_days
497: ,pp.start_date
498: ,pp.completion_date
502: and ph.start_date
503: between nvl( fnd_date.canonical_to_date(d_date_from), ph.start_date - 1)
504: and nvl( fnd_date.canonical_to_date(d_date_to) , ph.start_date + 1)
505: ) or (
506: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(ph.end_date
507: ,'AFTER_END'
508: ,n_tolerance_days
509: ,pp.start_date
510: ,pp.completion_date
541: , pt.task_name task_name
542: , pt.start_date task_start_date
543: , pt.completion_date task_end_date
544: , hou.name organization_name
545: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(msd.schedule_date
546: ,'BETWEEN'
547: ,0
548: ,pp.start_date
549: ,pp.completion_date
549: ,pp.completion_date
550: ,pt.start_date
551: ,pt.completion_date
552: ) exception_days1
553: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(msd.rate_end_date
554: ,'BETWEEN'
555: ,0
556: ,pp.start_date
557: ,pp.completion_date
580: and pp.project_id = msd.project_id
581: and ( c_project_from is null or pp.project_id >= c_project_from )
582: and ( c_project_to is null or pp.project_id <= c_project_to )
583: and ((
584: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(msd.schedule_date
585: ,'BETWEEN'
586: ,n_tolerance_days
587: ,pp.start_date
588: ,pp.completion_date
592: and msd.schedule_date
593: between nvl( fnd_date.canonical_to_date(d_date_from), msd.schedule_date - 1)
594: and nvl( fnd_date.canonical_to_date(d_date_to) , msd.schedule_date + 1)
595: ) or (
596: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(msd.rate_end_date
597: ,'BETWEEN'
598: ,n_tolerance_days
599: ,pp.start_date
600: ,pp.completion_date
628: , pt.task_name task_name
629: , pt.start_date task_start_date
630: , pt.completion_date task_end_date
631: , hou.name organization_name
632: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(msd.schedule_date
633: ,'BETWEEN'
634: ,0
635: ,pp.start_date
636: ,pp.completion_date
636: ,pp.completion_date
637: ,pt.start_date
638: ,pt.completion_date
639: ) exception_days1
640: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(msd.rate_end_date
641: ,'BETWEEN'
642: ,0
643: ,pp.start_date
644: ,pp.completion_date
667: and pp.project_id = msd.project_id
668: and ( c_project_from is null or pp.project_id >= c_project_from )
669: and ( c_project_to is null or pp.project_id <= c_project_to )
670: and ((
671: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(msd.schedule_date
672: ,'BETWEEN'
673: ,n_tolerance_days
674: ,pp.start_date
675: ,pp.completion_date
679: and msd.schedule_date
680: between nvl( fnd_date.canonical_to_date(d_date_from), msd.schedule_date - 1)
681: and nvl( fnd_date.canonical_to_date(d_date_to) , msd.schedule_date + 1)
682: ) or (
683: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(msd.rate_end_date
684: ,'BETWEEN'
685: ,n_tolerance_days
686: ,pp.start_date
687: ,pp.completion_date
716: , pt.task_number task_number
717: , pt.task_name task_name
718: , pt.start_date task_start_date
719: , pt.completion_date task_end_date
720: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(pll.promised_date
721: ,'BETWEEN'
722: ,0
723: ,pp.start_date
724: ,pp.completion_date
724: ,pp.completion_date
725: ,pt.start_date
726: ,pt.completion_date
727: ) exception_days1
728: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(pll.need_by_date
729: ,'BETWEEN'
730: ,0
731: ,pp.start_date
732: ,pp.completion_date
759: and pp.project_id = pd.project_id
760: and ( c_project_from is null or pp.project_id >= c_project_from )
761: and ( c_project_to is null or pp.project_id <= c_project_to )
762: and ((
763: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(pll.promised_date
764: ,'BETWEEN'
765: ,n_tolerance_days
766: ,pp.start_date
767: ,pp.completion_date
771: and pll.promised_date
772: between nvl( fnd_date.canonical_to_date(d_date_from), pll.promised_date - 1)
773: and nvl( fnd_date.canonical_to_date(d_date_to) , pll.promised_date + 1)
774: ) or (
775: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(pll.need_by_date
776: ,'BETWEEN'
777: ,n_tolerance_days
778: ,pp.start_date
779: ,pp.completion_date
815: , pt.task_number task_number
816: , pt.task_name task_name
817: , pt.start_date task_start_date
818: , pt.completion_date task_end_date
819: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(pll.promised_date
820: ,'BETWEEN'
821: ,0
822: ,pp.start_date
823: ,pp.completion_date
823: ,pp.completion_date
824: ,pt.start_date
825: ,pt.completion_date
826: ) exception_days1
827: , PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(pll.need_by_date
828: ,'BETWEEN'
829: ,0
830: ,pp.start_date
831: ,pp.completion_date
862: and pp.project_id = pd.project_id
863: and ( c_project_from is null or pp.project_id >= c_project_from )
864: and ( c_project_to is null or pp.project_id <= c_project_to )
865: and ((
866: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(pll.promised_date
867: ,'BETWEEN'
868: ,n_tolerance_days
869: ,pp.start_date
870: ,pp.completion_date
874: and pll.promised_date
875: between nvl( fnd_date.canonical_to_date(d_date_from), pll.promised_date - 1)
876: and nvl( fnd_date.canonical_to_date(d_date_to) , pll.promised_date + 1)
877: ) or (
878: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(pll.need_by_date
879: ,'BETWEEN'
880: ,n_tolerance_days
881: ,pp.start_date
882: ,pp.completion_date