VIEW: APPS.JTF_RS_RESOURCE_VLAUES_VL

Source

View Text - Preformatted

SELECT a.RESOURCE_PARAM_VALUE_ID , a.RESOURCE_ID , a.RESOURCE_PARAM_ID , a.VALUE , a.VALUE_TYPE , a.OBJECT_VERSION_NUMBER , a.CREATED_BY , a.CREATION_DATE , a.LAST_UPDATED_BY , a.LAST_UPDATE_DATE , a.LAST_UPDATE_LOGIN , a.ATTRIBUTE1 , a.ATTRIBUTE2 , a.ATTRIBUTE3 , a.ATTRIBUTE4 , a.ATTRIBUTE5 , a.ATTRIBUTE6 , a.ATTRIBUTE7 , a.ATTRIBUTE8 , a.ATTRIBUTE9 , a.ATTRIBUTE10 , a.ATTRIBUTE11 , a.ATTRIBUTE12 , a.ATTRIBUTE13 , a.ATTRIBUTE14 , a.ATTRIBUTE15 , a.ATTRIBUTE_CATEGORY , b.config_name , d.type value_datetype ,c.meaning param_name from jtf_rs_resource_values a ,cct_middlewares_v b ,fnd_lookups c ,jtf_rs_resource_params d WHERE a.value_type = b.value_type and a.resource_param_id = d.resource_param_id and c.lookup_code = d.name and c.lookup_type = d.domain_lookup_type

View Text - HTML Formatted

SELECT A.RESOURCE_PARAM_VALUE_ID
, A.RESOURCE_ID
, A.RESOURCE_PARAM_ID
, A.VALUE
, A.VALUE_TYPE
, A.OBJECT_VERSION_NUMBER
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.ATTRIBUTE_CATEGORY
, B.CONFIG_NAME
, D.TYPE VALUE_DATETYPE
, C.MEANING PARAM_NAME
FROM JTF_RS_RESOURCE_VALUES A
, CCT_MIDDLEWARES_V B
, FND_LOOKUPS C
, JTF_RS_RESOURCE_PARAMS D
WHERE A.VALUE_TYPE = B.VALUE_TYPE
AND A.RESOURCE_PARAM_ID = D.RESOURCE_PARAM_ID
AND C.LOOKUP_CODE = D.NAME
AND C.LOOKUP_TYPE = D.DOMAIN_LOOKUP_TYPE