APPS.WMS_PUTAWAY_SUGGESTIONS dependencies on MTL_RESERVATIONS

Line 201: FROM mtl_reservations

197: WHERE organization_id = p_org_id;
198:
199: IF (l_crossdock_flag = 2 AND l_pregen_putaway_tasks_flag = 2) THEN -- 2 disabled
200: SELECT 'Y' INTO l_plan_xdock_flag
201: FROM mtl_reservations
202: WHERE lpn_id=p_lpn_id
203: AND organization_id=p_org_id
204: AND external_source_code='XDOCK'
205: AND EXISTS (SELECT 1 FROM mtl_txn_request_lines