DBA Data[Home] [Help]

APPS.INV_MO_CANCEL_PVT dependencies on WMS_DISPATCHED_TASKS

Line 130: FROM wms_dispatched_tasks

126: FOR UPDATE NOWAIT;
127:
128: CURSOR c_dispatched_task IS
129: SELECT status
130: FROM wms_dispatched_tasks
131: WHERE (l_parent_line_id IS NULL AND transaction_temp_id = l_transaction_temp_id)
132: OR (l_parent_line_id IS NOT NULL AND transaction_temp_id = l_parent_line_id);
133:
134: -- INVCONV - Added Qty2

Line 1291: FROM wms_dispatched_tasks wdt

1287: , mmtt.reservation_id
1288: FROM mtl_material_transactions_temp mmtt
1289: WHERE mmtt.move_order_line_id = p_line_id
1290: AND NOT EXISTS( SELECT 'Y'
1291: FROM wms_dispatched_tasks wdt
1292: WHERE wdt.transaction_temp_id
1293: = nvl( mmtt.parent_line_id
1294: , mmtt.transaction_temp_id
1295: )