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 310: update wip_requirement_operations wro

306:
307: IF( nvl(p_rep_id, -1) = -1 ) THEN
308: /*Bugfix:8838245.Changed below update to divide with component yield factor
309: as yield is separated from quantity per assembly as part of component yield factor project during R12 */
310: update wip_requirement_operations wro
311: set wro.required_quantity =
312: ( select
313: ( wro1.quantity_per_assembly * wdj.start_quantity)/wro1.component_yield_factor
314: from

Line 315: wip_requirement_operations wro1,

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

Line 327: update wip_requirement_operations wro

323: and wro.basis_type = wip_constants.ITEM_BASED_MTL; /* Bug fix 9337675 */
324: ELSIF ( p_rep_id > 0 ) then
325: /*Bugfix:8838245.Changed below update to divide with component yield factor
326: as yield is separated from quantity per assembly as part of component yield factor project during R12 */
327: update wip_requirement_operations wro
328: set wro.required_quantity =
329: ( select
330: ( wro1.quantity_per_assembly *
331: round(wrs.processing_work_days * wrs.daily_production_rate, 6))/wro1.component_yield_factor

Line 333: wip_requirement_operations wro1,

329: ( select
330: ( wro1.quantity_per_assembly *
331: round(wrs.processing_work_days * wrs.daily_production_rate, 6))/wro1.component_yield_factor
332: from
333: wip_requirement_operations wro1,
334: wip_repetitive_schedules wrs
335: where
336: wro1.rowid = wro.rowid
337: and wro1.repetitive_schedule_id =wrs.repetitive_schedule_id