APPS.WSMPVLDT dependencies on WIP_OPERATIONS

Line 2493: from wip_operations wo

2489: Begin
2490: l_stmt_num := 36;
2491:
2492: select null into l_dummy
2493: from wip_operations wo
2494: where wo.organization_id = l_cur_wsji_rec.organization_id
2495: and wo.wip_entity_id = l_cur_wsji_rec.wip_entity_id
2496: and wo.operation_seq_num = l_cur_wsji_rec.operation_seq_num
2497: and decode(wo.quantity_in_queue,0, wo.quantity_waiting_to_move,

Line 2933: wip_operations wo,

2929:
2930: SELECT bso.standard_operation_id
2931: INTO l_merge_std_op_id
2932: FROM wsm_starting_jobs_interface wsji,
2933: wip_operations wo,
2934: bom_standard_operations bso
2935: WHERE wsji.header_id = l_cur_wsji_rec.wsji_header_id
2936: --AND NVL(wsji.representative_flag, l_cur_wsji_rec.representative_flag) = 'Y'
2937: AND NVL(wsji.wip_entity_id, l_cur_wsji_rec.wip_entity_id) = wo.wip_entity_id

Line 5950: wip_operations wo

5946: l_rj_rout_seq_id --VJ: Added for NSLBJ--
5947: FROM bom_operation_sequences bos,
5948: wsm_resulting_jobs_interface rj,
5949: wsm_starting_jobs_interface sj,
5950: wip_operations wo
5951: WHERE sj.header_id = l_header_id
5952: AND rj.rowid = l_wrji_rowid --SpUA add
5953: AND sj.header_id = rj.header_id
5954: AND sj.operation_seq_num = wo.operation_seq_num