APPS.WIP_REPETITIVE_UTILITIES dependencies on WIP_OPERATIONS

Line 83: FROM WIP_OPERATIONS

79: AND CD4.CALENDAR_DATE = TRUNC(WRS.LAST_UNIT_COMPLETION_DATE);
80:
81: CURSOR first_op IS
82: SELECT NVL(MIN(OPERATION_SEQ_NUM), -1)
83: FROM WIP_OPERATIONS
84: WHERE ORGANIZATION_ID = p_org_id
85: AND WIP_ENTITY_ID = x_wip_id
86: AND REPETITIVE_SCHEDULE_ID = p_sched_id;
87:

Line 90: FROM WIP_OPERATIONS

86: AND REPETITIVE_SCHEDULE_ID = p_sched_id;
87:
88: CURSOR qty_completed IS
89: SELECT QUANTITY_RUNNING + QUANTITY_COMPLETED
90: FROM WIP_OPERATIONS
91: WHERE ORGANIZATION_ID = p_org_id
92: AND WIP_ENTITY_ID = x_wip_id
93: AND OPERATION_SEQ_NUM = x_first_op
94: AND REPETITIVE_SCHEDULE_ID = p_sched_id;

Line 294: INSERT INTO WIP_OPERATIONS

290: AND REPETITIVE_SCHEDULE_ID = p_sched_id;
291:
292: -- copy ops from old schedule for new schedule
293:
294: INSERT INTO WIP_OPERATIONS
295: (WIP_ENTITY_ID, OPERATION_SEQ_NUM,
296: ORGANIZATION_ID, REPETITIVE_SCHEDULE_ID,
297: LAST_UPDATE_DATE, LAST_UPDATED_BY,
298: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,

Line 357: WIP_OPERATIONS OPS

353: OPS.ATTRIBUTE12, OPS.ATTRIBUTE13,
354: OPS.ATTRIBUTE14, OPS.ATTRIBUTE15
355: FROM BOM_CALENDAR_DATES CD1,
356: BOM_CALENDAR_DATES CD2,
357: WIP_OPERATIONS OPS
358: WHERE OPS.ORGANIZATION_ID = p_org_id
359: AND OPS.WIP_ENTITY_ID = x_wip_id
360: AND OPS.REPETITIVE_SCHEDULE_ID = p_sched_id
361: AND CD1.CALENDAR_CODE = x_cal_code

Line 381: -- and update lusd, lucd for the wip_operations table

377: AND CALENDAR_DATE =
378: TRUNC(OPS.FIRST_UNIT_COMPLETION_DATE));
379:
380: -- set the quantity in the queue to quantity not complete
381: -- and update lusd, lucd for the wip_operations table
382:
383: UPDATE WIP_OPERATIONS OPS
384: SET QUANTITY_IN_QUEUE =
385: DECODE(OPERATION_SEQ_NUM,

Line 383: UPDATE WIP_OPERATIONS OPS

379:
380: -- set the quantity in the queue to quantity not complete
381: -- and update lusd, lucd for the wip_operations table
382:
383: UPDATE WIP_OPERATIONS OPS
384: SET QUANTITY_IN_QUEUE =
385: DECODE(OPERATION_SEQ_NUM,
386: x_first_op,
387: QUANTITY_IN_QUEUE - x_act_days_left * x_rate,

Line 478: WIP_OPERATIONS O

474: R.ATTRIBUTE10, R.ATTRIBUTE11,
475: R.ATTRIBUTE12, R.ATTRIBUTE13,
476: R.ATTRIBUTE14, R.ATTRIBUTE15
477: FROM WIP_OPERATION_RESOURCES R,
478: WIP_OPERATIONS O
479: WHERE R.WIP_ENTITY_ID = x_wip_id
480: AND R.ORGANIZATION_ID = p_org_id
481: AND R.REPETITIVE_SCHEDULE_ID = p_sched_id
482: AND O.WIP_ENTITY_ID = x_wip_id

Line 586: UPDATE WIP_OPERATIONS

582:
583: -- x_rnd_days_ran = 0
584: ELSE
585:
586: UPDATE WIP_OPERATIONS
587: SET QUANTITY_IN_QUEUE =
588: DECODE(OPERATION_SEQ_NUM,
589: x_first_op, x_rate * x_act_days_left,
590: QUANTITY_IN_QUEUE),

Line 697: FROM wip_operations wo

693: AND wrs.repetitive_schedule_id = p_rollfwd_sched_id;
694:
695: CURSOR nxt_fstop IS
696: SELECT nvl(min(wo.operation_seq_num), 1)
697: FROM wip_operations wo
698: WHERE wo.organization_id = p_org_id
699: AND wo.wip_entity_id = x_wip_id
700: AND wo.repetitive_schedule_id = p_rollfwd_sched_id;
701:

Line 867: wip_operations wo

863: wro.attribute9, wro.attribute10, wro.attribute11,
864: wro.attribute12, wro.attribute13, wro.attribute14,
865: wro.attribute15
866: FROM wip_requirement_operations wro,
867: wip_operations wo
868: WHERE wro.organization_id = p_org_id
869: AND wo.organization_id (+) = p_org_id
870: AND wro.wip_entity_id = x_wip_id
871: AND wo.wip_entity_id (+) = x_wip_id

Line 976: UPDATE wip_operations wo

972: end if;
973:
974: -- set quantity in the queue
975:
976: UPDATE wip_operations wo
977: SET wo.quantity_in_queue = x_rollfwd_qty,
978: wo.last_update_date = SYSDATE,
979: wo.last_updated_by = x_user_id,
980: wo.request_id = decode(x_request_id, 0, wo.request_id,