VIEW: APPS.JTF_PERZ_DATA_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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