DBA Data[Home] [Help]

APPS.INV_MO_BACKORDER_PVT dependencies on WMS_DISPATCHED_TASKS

Line 169: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt

165:
166: CURSOR c_allow_backordering IS
167: SELECT 'N' FROM DUAL
168: WHERE EXISTS( SELECT 1
169: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt
170: WHERE mmtt.move_order_line_id = l_mo_line_rec.line_id
171: AND wdt.transaction_temp_id = nvl(mmtt.parent_line_id, mmtt.transaction_temp_id)
172: AND wdt.status IN (4,9));
173: