DBA Data[Home] [Help]

VIEW: APPS.PQH_ATTRIBUTE_RANGES_V1

Source

View Text - Preformatted

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