[Home] [Help]
402:
403: -- If this cursor returns a row, we have an error condition.
404: CURSOR Cops IS
405: select 'X'
406: from wip_operations wo,bom_departments bd
407: where wo.department_id = bd.department_id
408: and wo.organization_id = bd.organization_id
409: and bd.location_id IS NULL
410: and level < 3
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,
570: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
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,
754: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
1201:
1202: -- you cannot move into a queue of operation unless that department
1203: -- has a location set up
1204: SELECT 'WIP_PO_MOVE_LOCATION' error_message
1205: FROM bom_departments bd,
1206: wip_operation_resources wor,
1207: wip_operations wo1,
1208: wip_operations wo2
1209: WHERE wor.organization_id = c_org_id