VIEW: APPS.CCT_ROUTE_RULES0_VL

Source

View Text - Preformatted

SELECT a.ROUTE_PARAM_ID ,a.ROUTE_ID ,a.PARAM ,b.meaning ,a.operation ,null ,a.VALUE ,a.LAST_UPDATE_DATE ,a.LAST_UPDATED_BY ,a.LAST_UPDATE_LOGIN ,a.CREATED_BY ,a.CREATION_DATE ,a.OBJECT_VERSION_NUMBER ,a.F_DELETEDFLAG FROM cct_route_params a, fnd_lookups b WHERE sequence is null and B.LOOKUP_TYPE(+) = 'CCT_INTERACTION_KEYS' AND lower(A.PARAM) = lower(B.LOOKUP_CODE(+))

View Text - HTML Formatted

SELECT A.ROUTE_PARAM_ID
, A.ROUTE_ID
, A.PARAM
, B.MEANING
, A.OPERATION
, NULL
, A.VALUE
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.CREATED_BY
, A.CREATION_DATE
, A.OBJECT_VERSION_NUMBER
, A.F_DELETEDFLAG
FROM CCT_ROUTE_PARAMS A
, FND_LOOKUPS B
WHERE SEQUENCE IS NULL
AND B.LOOKUP_TYPE(+) = 'CCT_INTERACTION_KEYS'
AND LOWER(A.PARAM) = LOWER(B.LOOKUP_CODE(+))