VIEW: APPS.CCT_ROUTES0_VL

Source

View Text - Preformatted

SELECT a.route_id, a.name, a.description, b.meaning, a.route_type, c.group_name, a.default_route, a.priority, a.dburl, a.db_driver, a.time_out, a.last_update_date, a.last_updated_by, a.creation_date, a.created_by, a.last_update_login, a.object_version_number, f_deletedflag FROM cct_routes a, fnd_lookups b, cct_groups_vl c WHERE B.LOOKUP_TYPE(+) = 'CCT_ROUTE_TYPES' AND A.ROUTE_TYPE = B.LOOKUP_CODE(+) AND A.DEFAULT_ROUTE = c.GROUP_NUMBER union SELECT a.route_id, a.name, a.description, b.meaning, a.route_type, ' ', a.default_route, a.priority, a.dburl, a.db_driver, a.time_out, a.last_update_date, a.last_updated_by, a.creation_date, a.created_by, a.last_update_login, a.object_version_number, f_deletedflag FROM cct_routes a, fnd_lookups b WHERE B.LOOKUP_TYPE(+) = 'CCT_ROUTE_TYPES' AND A.ROUTE_TYPE = B.LOOKUP_CODE(+) and A.DEFAULT_ROUTE = ' '

View Text - HTML Formatted

SELECT A.ROUTE_ID
, A.NAME
, A.DESCRIPTION
, B.MEANING
, A.ROUTE_TYPE
, C.GROUP_NAME
, A.DEFAULT_ROUTE
, A.PRIORITY
, A.DBURL
, A.DB_DRIVER
, A.TIME_OUT
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.OBJECT_VERSION_NUMBER
, F_DELETEDFLAG
FROM CCT_ROUTES A
, FND_LOOKUPS B
, CCT_GROUPS_VL C
WHERE B.LOOKUP_TYPE(+) = 'CCT_ROUTE_TYPES'
AND A.ROUTE_TYPE = B.LOOKUP_CODE(+)
AND A.DEFAULT_ROUTE = C.GROUP_NUMBER UNION SELECT A.ROUTE_ID
, A.NAME
, A.DESCRIPTION
, B.MEANING
, A.ROUTE_TYPE
, ' '
, A.DEFAULT_ROUTE
, A.PRIORITY
, A.DBURL
, A.DB_DRIVER
, A.TIME_OUT
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.OBJECT_VERSION_NUMBER
, F_DELETEDFLAG
FROM CCT_ROUTES A
, FND_LOOKUPS B
WHERE B.LOOKUP_TYPE(+) = 'CCT_ROUTE_TYPES'
AND A.ROUTE_TYPE = B.LOOKUP_CODE(+)
AND A.DEFAULT_ROUTE = ' '