DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.JTF_PERZ_DATA_V

Object Details
Object Name: JTF_PERZ_DATA_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_PERZ_DATA_V
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


View for personalization data party merge


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROFILE_ID NUMBER
Yes Profile identifier.
PROFILE_NAME VARCHAR2 (60)
Profile name
PERZ_DATA_ID NUMBER
Yes Personalized data object identifier.
APPLICATION_ID NUMBER

Application identifier.
PERZ_DATA_NAME VARCHAR2 (360)
Personalized data object name.
PERZ_DATA_TYPE VARCHAR2 (30)
Personalized data object type.
PERZ_DATA_ATTRIB_ID NUMBER
Yes Personalized data attribute identifier.
ATTRIBUTE_NAME VARCHAR2 (60)
Personalized data attribute name.
ATTRIBUTE_TYPE VARCHAR2 (30)
Personalized data attribute type.
ATTRIBUTE_VALUE VARCHAR2 (300)
Personalized data attribute value.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.JTF_PERZ_DATA_V;

Dependencies

[top of page]

APPS.JTF_PERZ_DATA_V references the following:

SchemaAPPS
SynonymJTF_PERZ_DATA
SynonymJTF_PERZ_DATA_ATTRIB
SynonymJTF_PERZ_PROFILE
APPS.JTF_PERZ_DATA_V is referenced by following:

SchemaAPPS
Package BodyHZ_PURGE_GEN - show dependent code