VIEW: APPS.BIV_DBI_RO_ORG_V

Source

View Text - Preformatted

SELECT a.group_id id, b.group_name value from JTF_RS_GROUP_USAGES_VL a, JTF_RS_GROUPS_VL b WHERE a.USAGE = 'REPAIR_ORGANIZATION' and b.group_id = a.group_id order by 2

View Text - HTML Formatted

SELECT A.GROUP_ID ID
, B.GROUP_NAME VALUE
FROM JTF_RS_GROUP_USAGES_VL A
, JTF_RS_GROUPS_VL B
WHERE A.USAGE = 'REPAIR_ORGANIZATION'
AND B.GROUP_ID = A.GROUP_ID ORDER BY 2