DBA Data[Home] [Help]

APPS.WMS_DOCK_APPOINTMENTS_PUB dependencies on MTL_ITEM_LOCATIONS

Line 947: FROM mtl_item_locations

943: AND organization_id = v_organization_id;
944:
945: CURSOR Check_Valid_Locator(v_locator_id NUMBER, v_organization_id NUMBER) IS
946: SELECT inventory_location_id, disable_date
947: FROM mtl_item_locations
948: WHERE inventory_location_id = v_locator_id
949: AND organization_id = v_organization_id
950: AND inventory_location_type = 1
951: AND NVL(disable_date, SYSDATE + 1) > SYSDATE;