560: x_task_id,
561: DECODE(x_project_id,NULL,NULL,'Y')
562: FROM WIP_REPETITIVE_SCHEDULES wrs,
563: HR_ORGANIZATION_INFORMATION hoi,
564: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2,-- Bug 4398047 removed bcd1 and bcd2
565: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
566: FND_USER fu, BOM_DEPARTMENTS bd,
567: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
568: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
561: DECODE(x_project_id,NULL,NULL,'Y')
562: FROM WIP_REPETITIVE_SCHEDULES wrs,
563: HR_ORGANIZATION_INFORMATION hoi,
564: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2,-- Bug 4398047 removed bcd1 and bcd2
565: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
566: FND_USER fu, BOM_DEPARTMENTS bd,
567: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
568: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
569: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
744: x_task_id,
745: DECODE(x_project_id,NULL,NULL,'Y')
746: FROM WIP_REPETITIVE_SCHEDULES wrs, /*MTL_ITEM_REVISIONS mir, */
747: HR_ORGANIZATION_INFORMATION hoi,
748: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2, -- Bug 4398047 Commented out bcd1 and bcd2
749: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
750: FND_USER fu, BOM_DEPARTMENTS bd,
751: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
752: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
745: DECODE(x_project_id,NULL,NULL,'Y')
746: FROM WIP_REPETITIVE_SCHEDULES wrs, /*MTL_ITEM_REVISIONS mir, */
747: HR_ORGANIZATION_INFORMATION hoi,
748: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2, -- Bug 4398047 Commented out bcd1 and bcd2
749: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
750: FND_USER fu, BOM_DEPARTMENTS bd,
751: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
752: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
753: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
1448: WIP_CONSTANTS.EAM, wo1.last_unit_completion_date,
1449: DECODE(wo1.next_operation_seq_num,
1450: NULL, wo1.last_unit_completion_date,
1451: wo2.first_unit_start_date))))) new_need_by_date
1452: FROM bom_calendar_dates bcd1,
1453: bom_calendar_dates bcd2,
1454: mtl_system_items msi,
1455: mtl_parameters mp,
1456: wip_operations wo1,
1449: DECODE(wo1.next_operation_seq_num,
1450: NULL, wo1.last_unit_completion_date,
1451: wo2.first_unit_start_date))))) new_need_by_date
1452: FROM bom_calendar_dates bcd1,
1453: bom_calendar_dates bcd2,
1454: mtl_system_items msi,
1455: mtl_parameters mp,
1456: wip_operations wo1,
1457: wip_operations wo2