VIEW: APPS.CCT_ROUTE_PARAMS0_VL

Source

View Text - Preformatted

SELECT a.ROUTE_PARAM_ID ,a.ROUTE_ID ,a.PARAM ,a.DATATYPE ,c.meaning ,a.DIRECTION ,d.meaning ,a.SEQUENCE ,a.VALUE ,nvl(b.meaning,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, fnd_lookups c, fnd_lookups d WHERE sequence is not null and B.LOOKUP_TYPE(+) = 'CCT_INTERACTION_KEYS' AND lower(A.VALUE) = lower(B.LOOKUP_CODE(+)) and c.LOOKUP_TYPE(+) = 'CCT_ROUTE_PARAM_DATATYPE' AND lower(A.DATATYPE) = lower(C.LOOKUP_CODE(+)) and D.LOOKUP_TYPE(+) = 'CCT_ROUTE_PARAM_DIRECTIONS' AND lower(A.DIRECTION) = lower(D.LOOKUP_CODE(+))

View Text - HTML Formatted

SELECT A.ROUTE_PARAM_ID
, A.ROUTE_ID
, A.PARAM
, A.DATATYPE
, C.MEANING
, A.DIRECTION
, D.MEANING
, A.SEQUENCE
, A.VALUE
, NVL(B.MEANING
, 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
, FND_LOOKUPS C
, FND_LOOKUPS D
WHERE SEQUENCE IS NOT NULL
AND B.LOOKUP_TYPE(+) = 'CCT_INTERACTION_KEYS'
AND LOWER(A.VALUE) = LOWER(B.LOOKUP_CODE(+))
AND C.LOOKUP_TYPE(+) = 'CCT_ROUTE_PARAM_DATATYPE'
AND LOWER(A.DATATYPE) = LOWER(C.LOOKUP_CODE(+))
AND D.LOOKUP_TYPE(+) = 'CCT_ROUTE_PARAM_DIRECTIONS'
AND LOWER(A.DIRECTION) = LOWER(D.LOOKUP_CODE(+))