SELECT distinct routing_category_id, range_name , enable_flag, nvl(delete_flag,'N') from pqh_attribute_ranges WHERE routing_list_member_id IS NULL and position_id IS NULL and assignment_id IS NULL
View Text - HTML Formatted
SELECT DISTINCT ROUTING_CATEGORY_ID , RANGE_NAME , ENABLE_FLAG , NVL(DELETE_FLAG , 'N') FROM PQH_ATTRIBUTE_RANGES WHERE ROUTING_LIST_MEMBER_ID IS NULL AND POSITION_ID IS NULL AND ASSIGNMENT_ID IS NULL