DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on WMS_OP_OPERATION_INSTANCES

Line 5142: FROM wms_op_operation_instances wooi

5138: CONNECT BY PRIOR lpn_id = parent_lpn_id
5139: )
5140: AND ((mmtt.operation_plan_id IS NOT NULL
5141: AND exists (SELECT 1
5142: FROM wms_op_operation_instances wooi
5143: WHERE wooi.source_task_id = mmtt.transaction_temp_id
5144: AND wooi.operation_status = 2
5145: AND wooi.operation_type_id = 2))
5146: OR

Line 5171: FROM wms_op_operation_instances wooi

5167: AND wdt.STATUS = 4
5168: AND wdt.person_id = p_emp_id
5169: AND ((mmtt.operation_plan_id IS NOT NULL
5170: AND exists (SELECT 1
5171: FROM wms_op_operation_instances wooi
5172: WHERE wooi.source_task_id = mmtt.transaction_temp_id
5173: AND wooi.operation_status = 2
5174: AND wooi.operation_type_id = 2))
5175: OR

Line 5834: wms_op_operation_instances wooi ,

5830: INTO l_drop_active
5831: , l_userid
5832: FROM mtl_txn_request_lines mtrl,
5833: mtl_material_transactions_temp mmtt,
5834: wms_op_operation_instances wooi ,
5835: (SELECT wlpn.lpn_id /*5723418*/
5836: FROM wms_license_plate_numbers wlpn
5837: START WITH wlpn.lpn_id = p_lpn_id
5838: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id) wlpn

Line 12749: FROM wms_op_operation_instances

12745:
12746: l_progress := 80;
12747:
12748: FOR wooi IN (SELECT operation_instance_id
12749: FROM wms_op_operation_instances
12750: WHERE source_task_id = l_mmtt_rec.transaction_temp_id
12751: ) LOOP
12752:
12753: wms_op_runtime_pvt_apis.delete_operation_instance