[Home] [Help]
View: JTF_PERZ_DATA_V
Product: | JTF - CRM Foundation |
Description: | View for personalization data party merge |
Implementation/DBA Data: |
APPS.JTF_PERZ_DATA_V
|
View Text
SELECT A.PROFILE_ID
, A.PROFILE_NAME
, B.PERZ_DATA_ID
, B.APPLICATION_ID
, B.PERZ_DATA_NAME
, B.PERZ_DATA_TYPE
, C.PERZ_DATA_ATTRIB_ID
, C.ATTRIBUTE_NAME
, C.ATTRIBUTE_TYPE
, C.ATTRIBUTE_VALUE
FROM JTF_PERZ_PROFILE A
, JTF_PERZ_DATA B
, JTF_PERZ_DATA_ATTRIB C
WHERE A.PROFILE_ID = B.PROFILE_ID
AND B.PERZ_DATA_ID = C.PERZ_DATA_ID
Columns
Name |
PROFILE_ID |
PROFILE_NAME |
PERZ_DATA_ID |
APPLICATION_ID |
PERZ_DATA_NAME |
PERZ_DATA_TYPE |
PERZ_DATA_ATTRIB_ID |
ATTRIBUTE_NAME |
ATTRIBUTE_TYPE |
ATTRIBUTE_VALUE |