APPS.WMS_PUTAWAY_UTILS dependencies on WMS_OP_OPERATION_INSTANCES

Line 5849: FROM wms_op_operation_instances wooi

5845: CONNECT BY PRIOR lpn_id = parent_lpn_id
5846: )
5847: AND ((mmtt.operation_plan_id IS NOT NULL
5848: AND exists (SELECT 1
5849: FROM wms_op_operation_instances wooi
5850: WHERE wooi.source_task_id = mmtt.transaction_temp_id
5851: AND wooi.operation_status = 2
5852: AND wooi.operation_type_id = 2))
5853: OR

Line 5878: FROM wms_op_operation_instances wooi

5874: AND wdt.STATUS = 4
5875: AND wdt.person_id = p_emp_id
5876: AND ((mmtt.operation_plan_id IS NOT NULL
5877: AND exists (SELECT 1
5878: FROM wms_op_operation_instances wooi
5879: WHERE wooi.source_task_id = mmtt.transaction_temp_id
5880: AND wooi.operation_status = 2
5881: AND wooi.operation_type_id = 2))
5882: OR

Line 6566: wms_op_operation_instances wooi ,

6562: INTO l_drop_active
6563: , l_userid
6564: FROM mtl_txn_request_lines mtrl,
6565: mtl_material_transactions_temp mmtt,
6566: wms_op_operation_instances wooi ,
6567: (SELECT wlpn.lpn_id /*5723418*/
6568: FROM wms_license_plate_numbers wlpn
6569: START WITH wlpn.lpn_id = p_lpn_id
6570: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id) wlpn

Line 13793: wms_op_operation_instances

13789: ) ;
13790: --delete WOOI
13791: DELETE
13792: FROM
13793: wms_op_operation_instances
13794: WHERE
13795: source_task_id IN
13796: (
13797: SELECT

Line 14882: FROM wms_op_operation_instances

14878:
14879: l_progress := 80;
14880:
14881: FOR wooi IN (SELECT operation_instance_id
14882: FROM wms_op_operation_instances
14883: WHERE source_task_id = l_mmtt_rec.transaction_temp_id
14884: ) LOOP
14885:
14886: wms_op_runtime_pvt_apis.delete_operation_instance