APPS.WIP_CHANGE_STATUS dependencies on WIP_OPERATIONS

Line 16: UPDATE WIP_OPERATIONS

12: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
13:
14: BEGIN
15: IF (P_repetitive_schedule_id IS NULL) THEN
16: UPDATE WIP_OPERATIONS
17: SET QUANTITY_IN_QUEUE =
18: SCHEDULED_QUANTITY -
19: (QUANTITY_IN_QUEUE + QUANTITY_RUNNING + QUANTITY_COMPLETED),
20: LAST_UPDATED_BY = X_user_id,

Line 28: UPDATE WIP_OPERATIONS

24: AND ORGANIZATION_ID = P_organization_id
25: AND REPETITIVE_SCHEDULE_ID IS NULL
26: AND PREVIOUS_OPERATION_SEQ_NUM IS NULL;
27: ELSE
28: UPDATE WIP_OPERATIONS
29: SET QUANTITY_IN_QUEUE =
30: SCHEDULED_QUANTITY -
31: (QUANTITY_IN_QUEUE + QUANTITY_RUNNING + QUANTITY_COMPLETED),
32: LAST_UPDATED_BY = X_user_id,

Line 204: FROM wip_operations wo1,

200: X_diff_routing BOOLEAN := FALSE;
201:
202: CURSOR check_routing IS
203: SELECT 'identical routing'
204: FROM wip_operations wo1,
205: wip_operations wo2,
206: wip_repetitive_schedules wrs
207: WHERE wrs.organization_id = P_organization_id
208: AND wo1.organization_id = P_organization_id

Line 205: wip_operations wo2,

201:
202: CURSOR check_routing IS
203: SELECT 'identical routing'
204: FROM wip_operations wo1,
205: wip_operations wo2,
206: wip_repetitive_schedules wrs
207: WHERE wrs.organization_id = P_organization_id
208: AND wo1.organization_id = P_organization_id
209: AND wo2.organization_id = P_organization_id

Line 224: FROM wip_operations O,

220: AND wo1.count_point_type = wo2.count_point_type
221: AND wo1.backflush_flag = wo2.backflush_flag
222: HAVING count(*) =
223: (SELECT count(*)
224: FROM wip_operations O,
225: wip_repetitive_schedules S
226: WHERE O.organization_id = P_organization_id
227: AND S.organization_id = P_organization_id
228: AND O.wip_entity_id = P_wip_entity_id

Line 236: FROM wip_operations O,

232: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
233: AND O.repetitive_schedule_id = P_repetitive_schedule_id)
234: AND count(*) =
235: (SELECT count(*)
236: FROM wip_operations O,
237: wip_repetitive_schedules S
238: WHERE O.organization_id = P_organization_id
239: AND S.organization_id = P_organization_id
240: AND O.wip_entity_id = P_wip_entity_id

Line 301: INTO x_tot_op_qty FROM WIP_OPERATIONS

297: /* For Bug 5859224: load_queue API would be called only if the sum of quantity_in_queue,quantity_running
298: and quantity_completed of first operation is zero */
299: BEGIN
300: SELECT (nvl(QUANTITY_IN_QUEUE,0) + nvl(QUANTITY_RUNNING,0) + nvl(QUANTITY_COMPLETED,0))
301: INTO x_tot_op_qty FROM WIP_OPERATIONS
302: WHERE WIP_ENTITY_ID = P_wip_entity_id
303: AND ORGANIZATION_ID = P_organization_id
304: AND REPETITIVE_SCHEDULE_ID IS NULL
305: AND ROWNUM = 1 --Bug 6052835: EAM Work orders can have multiple start (independant) operations