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

VIEW: APPS.JTF_PERZ_QUERY_PARAM_V

Object Details
Object Name: JTF_PERZ_QUERY_PARAM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_PERZ_QUERY_PARAM_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)
Personalization profile name.
QUERY_ID NUMBER
Yes Personalized query identifier.
APPLICATION_ID NUMBER

Application identifier.
QUERY_NAME VARCHAR2 (60)
Personalized query name.
QUERY_TYPE VARCHAR2 (100)
Personalized query type.
QUERY_PARAM_ID NUMBER
Yes Personalized query parameter identifier.
PARAMETER_NAME VARCHAR2 (60)
Personalized query parameter name.
PARAMETER_TYPE VARCHAR2 (30)
Personalized query parameter data type.
PARAMETER_VALUE VARCHAR2 (300)
Personalized query parameter value.
Query Text

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


SELECT PROFILE_ID
,      PROFILE_NAME
,      QUERY_ID
,      APPLICATION_ID
,      QUERY_NAME
,      QUERY_TYPE
,      QUERY_PARAM_ID
,      PARAMETER_NAME
,      PARAMETER_TYPE
,      PARAMETER_VALUE
FROM APPS.JTF_PERZ_QUERY_PARAM_V;

Dependencies

[top of page]

APPS.JTF_PERZ_QUERY_PARAM_V references the following:

SchemaAPPS
SynonymJTF_PERZ_PROFILE
SynonymJTF_PERZ_QUERY
SynonymJTF_PERZ_QUERY_PARAM
APPS.JTF_PERZ_QUERY_PARAM_V is referenced by following:

SchemaAPPS
Package BodyHZ_PURGE_GEN - show dependent code