APPS.WIP_OSP dependencies on BOM_CALENDAR_DATES

Line 612: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2,-- Bug 4398047 removed bcd1 and bcd2

608: x_task_id,
609: DECODE(x_project_id,NULL,NULL,'Y')
610: FROM WIP_REPETITIVE_SCHEDULES wrs,
611: HR_ORGANIZATION_INFORMATION hoi,
612: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2,-- Bug 4398047 removed bcd1 and bcd2
613: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
614: FND_USER fu, BOM_DEPARTMENTS bd,
615: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
616: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,

Line 613: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,

609: DECODE(x_project_id,NULL,NULL,'Y')
610: FROM WIP_REPETITIVE_SCHEDULES wrs,
611: HR_ORGANIZATION_INFORMATION hoi,
612: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2,-- Bug 4398047 removed bcd1 and bcd2
613: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
614: FND_USER fu, BOM_DEPARTMENTS bd,
615: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
616: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
617: WIP_OPERATIONS op2, WIP_OPERATIONS op1,

Line 805: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2, -- Bug 4398047 Commented out bcd1 and bcd2

801: x_task_id,
802: DECODE(x_project_id,NULL,NULL,'Y')
803: FROM WIP_REPETITIVE_SCHEDULES wrs, /*MTL_ITEM_REVISIONS mir, */
804: HR_ORGANIZATION_INFORMATION hoi,
805: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2, -- Bug 4398047 Commented out bcd1 and bcd2
806: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
807: FND_USER fu, BOM_DEPARTMENTS bd,
808: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
809: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,

Line 806: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,

802: DECODE(x_project_id,NULL,NULL,'Y')
803: FROM WIP_REPETITIVE_SCHEDULES wrs, /*MTL_ITEM_REVISIONS mir, */
804: HR_ORGANIZATION_INFORMATION hoi,
805: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2, -- Bug 4398047 Commented out bcd1 and bcd2
806: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
807: FND_USER fu, BOM_DEPARTMENTS bd,
808: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
809: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
810: WIP_OPERATIONS op2, WIP_OPERATIONS op1,

Line 1545: FROM bom_calendar_dates bcd1,

1541: WIP_CONSTANTS.EAM, wo1.last_unit_completion_date,
1542: DECODE(wo1.next_operation_seq_num,
1543: NULL, wo1.last_unit_completion_date,
1544: wo2.first_unit_start_date)))))) new_need_by_date
1545: FROM bom_calendar_dates bcd1,
1546: bom_calendar_dates bcd2,
1547: mtl_system_items msi,
1548: mtl_parameters mp,
1549: wip_operations wo1,

Line 1546: bom_calendar_dates bcd2,

1542: DECODE(wo1.next_operation_seq_num,
1543: NULL, wo1.last_unit_completion_date,
1544: wo2.first_unit_start_date)))))) new_need_by_date
1545: FROM bom_calendar_dates bcd1,
1546: bom_calendar_dates bcd2,
1547: mtl_system_items msi,
1548: mtl_parameters mp,
1549: wip_operations wo1,
1550: wip_operations wo2