APPS.INV_RCV_COMMON_APIS dependencies on WMS_DISPATCHED_TASKS

Line 3063: FROM wms_dispatched_tasks wdt, mtl_txn_request_lines mtrl

3059: INTO l_lpn_loaded
3060: FROM DUAL
3061: WHERE EXISTS(
3062: SELECT 1
3063: FROM wms_dispatched_tasks wdt, mtl_txn_request_lines mtrl
3064: WHERE wdt.move_order_line_id = mtrl.line_id
3065: AND wdt.organization_id = p_organization_id
3066: AND wdt.status = 4
3067: AND mtrl.lpn_id IN