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