Product: | JTF - CRM Foundation |
---|---|
Description: | This view lists the configuration name,parameter name and value for a resource and parameter |
Implementation/DBA Data: | APPS.JTF_RS_RESOURCE_VALUES_VL |
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_DATATYPE
, 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