[Home] [Help]
View: JTF_PERZ_QUERY_PARAM_V
Product: | JTF - CRM Foundation |
Description: | View for personalization data party merge |
Implementation/DBA Data: |
APPS.JTF_PERZ_QUERY_PARAM_V
|
View Text
SELECT A.PROFILE_ID
, A.PROFILE_NAME
, B.QUERY_ID
, B.APPLICATION_ID
, B.QUERY_NAME
, B.QUERY_TYPE
, C.QUERY_PARAM_ID
, C.PARAMETER_NAME
, C.PARAMETER_TYPE
, C.PARAMETER_VALUE
FROM JTF_PERZ_PROFILE A
, JTF_PERZ_QUERY B
, JTF_PERZ_QUERY_PARAM C
WHERE A.PROFILE_ID = B.PROFILE_ID
AND B.QUERY_ID = C.QUERY_ID
Columns
Name |
PROFILE_ID |
PROFILE_NAME |
QUERY_ID |
APPLICATION_ID |
QUERY_NAME |
QUERY_TYPE |
QUERY_PARAM_ID |
PARAMETER_NAME |
PARAMETER_TYPE |
PARAMETER_VALUE |