[Home] [Help]
437:
438: -- If this cursor returns a row, we have an error condition.
439: CURSOR Cops IS
440: select 'X'
441: from wip_operations wo,bom_departments bd
442: where wo.department_id = bd.department_id
443: and wo.organization_id = bd.organization_id
444: and bd.location_id IS NULL
445: and level < 3
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,
618: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
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,
811: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
1287:
1288: -- you cannot move into a queue of operation unless that department
1289: -- has a location set up
1290: SELECT 'WIP_PO_MOVE_LOCATION' error_message
1291: FROM bom_departments bd,
1292: wip_operation_resources wor,
1293: wip_operations wo1,
1294: wip_operations wo2
1295: WHERE wor.organization_id = c_org_id
2791: into l_count
2792: from
2793: wip_operation_resources wor,
2794: wip_operations wo,
2795: bom_departments bd
2796: where
2797: wor.wip_entity_id = wo.wip_entity_id
2798: and wor.organization_id = wo.organization_id
2799: and wor.operation_seq_num = wo.operation_seq_num