APPS.WIP_OVERCOMPLETION dependencies on WIP_REQUIREMENT_OPERATIONS

Line 31: update wip_requirement_operations wro

27: P_PROG_ID IN NUMBER default -1
28: ) is
29: BEGIN
30:
31: update wip_requirement_operations wro
32: set (wro.required_quantity
33: ,last_updated_by,
34: last_update_date,
35: last_update_login, request_id, program_application_id,

Line 50: from wip_requirement_operations wro1,

46: DECODE(p_req_id,-1,NULL,p_req_id),
47: DECODE(p_appl_id,-1,NULL,p_appl_id),
48: DECODE(p_prog_id,-1,NULL,p_prog_id),
49: DECODE(p_req_id,-1,NULL,SYSDATE)
50: from wip_requirement_operations wro1,
51: wip_move_txn_interface wti1,
52: WIP_MOVE_TXN_ALLOCATIONS wma1
53: where
54: wro1.rowid = wro.rowid

Line 74: wip_requirement_operations wro2,

70: )
71: where wro.rowid in
72: (
73: select wro2.rowid from
74: wip_requirement_operations wro2,
75: wip_move_txn_interface wti2,
76: WIP_MOVE_TXN_ALLOCATIONS wma2
77: where
78: wti2.group_id = p_group_id

Line 125: UPDATE wip_requirement_operations wro

121: P_PROG_ID IN NUMBER default -1
122: ) is
123: BEGIN
124:
125: UPDATE wip_requirement_operations wro
126: SET (wro.required_quantity
127: ,last_updated_by,
128: last_update_date,
129: last_update_login, request_id, program_application_id,

Line 144: FROM wip_requirement_operations wro1,

140: Decode(p_req_id,-1,NULL,p_req_id),
141: Decode(p_appl_id,-1,NULL,p_appl_id),
142: Decode(p_prog_id,-1,NULL,p_prog_id),
143: Decode(p_req_id,-1,NULL,Sysdate)
144: FROM wip_requirement_operations wro1,
145: mtl_material_transactions_temp mmtt1,
146: mtl_material_txn_allocations mmta1
147: WHERE
148: wro1.ROWID = wro.ROWID

Line 164: wip_requirement_operations wro2,

160: )
161: WHERE wro.ROWID IN
162: (
163: SELECT wro2.ROWID FROM
164: wip_requirement_operations wro2,
165: mtl_material_transactions_temp mmtt2,
166: mtl_material_txn_allocations mmta2
167: WHERE
168: mmtt2.transaction_action_id = wip_constants.cplassy_action

Line 287: | Resets the "Required quantity" field of wip_requirement_operations

283: | PROCEDURE
284: | undo_overcompletion
285: |
286: | PURPOSE
287: | Resets the "Required quantity" field of wip_requirement_operations
288: | during Unrelease of a Job since Overcompletions would have updated it
289: | if there were any overcompletions.
290: |
291: |

Line 308: update wip_requirement_operations wro

304: ) is
305: BEGIN
306:
307: IF( nvl(p_rep_id, -1) = -1 ) THEN
308: update wip_requirement_operations wro
309: set wro.required_quantity =
310: ( select
311: ( wro1.quantity_per_assembly * wdj.start_quantity)
312: from

Line 313: wip_requirement_operations wro1,

309: set wro.required_quantity =
310: ( select
311: ( wro1.quantity_per_assembly * wdj.start_quantity)
312: from
313: wip_requirement_operations wro1,
314: wip_discrete_jobs wdj
315: WHERE
316: wro1.rowid = wro.rowid
317: and wro1.wip_entity_id = wdj.wip_entity_id

Line 322: update wip_requirement_operations wro

318: AND wro1.organization_id = wdj.organization_id)
319: where wro.wip_entity_id = p_wip_entity_id
320: and wro.organization_id = p_org_id;
321: ELSIF ( p_rep_id > 0 ) then
322: update wip_requirement_operations wro
323: set wro.required_quantity =
324: ( select
325: ( wro1.quantity_per_assembly *
326: round(wrs.processing_work_days * wrs.daily_production_rate, 6))

Line 328: wip_requirement_operations wro1,

324: ( select
325: ( wro1.quantity_per_assembly *
326: round(wrs.processing_work_days * wrs.daily_production_rate, 6))
327: from
328: wip_requirement_operations wro1,
329: wip_repetitive_schedules wrs
330: where
331: wro1.rowid = wro.rowid
332: and wro1.repetitive_schedule_id =wrs.repetitive_schedule_id