VIEW: APPS.CCT_GROUPS_VL

Source

View Text - Preformatted

SELECT a.group_name ,a.group_number group_number ,a.group_desc ,b.meaning type from jtf_rs_groups_vl a ,fnd_lookups b ,jtf_rs_group_usages_vl c WHERE b.lookup_type = 'CCT_ROUTE_TYPES' and b.lookup_code = 'STATIC' and c.usage = 'CALL' and a.group_id = c.group_id UNION SELECT lower(d.group_name) group_name ,d.group_number group_number ,d.group_desc ,e.meaning type from jtf_rs_dynamic_groups_vl d ,fnd_lookups e where e.lookup_type = 'CCT_ROUTE_TYPES' and e.lookup_code = 'DYNAMIC' and d.usage= 'CALL'

View Text - HTML Formatted

SELECT A.GROUP_NAME
, A.GROUP_NUMBER GROUP_NUMBER
, A.GROUP_DESC
, B.MEANING TYPE
FROM JTF_RS_GROUPS_VL A
, FND_LOOKUPS B
, JTF_RS_GROUP_USAGES_VL C
WHERE B.LOOKUP_TYPE = 'CCT_ROUTE_TYPES'
AND B.LOOKUP_CODE = 'STATIC'
AND C.USAGE = 'CALL'
AND A.GROUP_ID = C.GROUP_ID UNION SELECT LOWER(D.GROUP_NAME) GROUP_NAME
, D.GROUP_NUMBER GROUP_NUMBER
, D.GROUP_DESC
, E.MEANING TYPE
FROM JTF_RS_DYNAMIC_GROUPS_VL D
, FND_LOOKUPS E
WHERE E.LOOKUP_TYPE = 'CCT_ROUTE_TYPES'
AND E.LOOKUP_CODE = 'DYNAMIC'
AND D.USAGE= 'CALL'