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 1289: FROM wms_dispatched_tasks wdt

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