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

VIEW: HR.PER_QUERY_CRITERIA#

Object Details
Object Name: PER_QUERY_CRITERIA#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER (15) Yes
FIELD VARCHAR2 (80) Yes
FIELD_TYPE VARCHAR2 (10) Yes
VARCHAR2_VALUE VARCHAR2 (240)
DATE_VALUE DATE

NUMBER_VALUE NUMBER

OBJECT_VERSION_NUMBER NUMBER (10)
Query Text

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


SELECT QUERY_ID
,      FIELD
,      FIELD_TYPE
,      VARCHAR2_VALUE
,      DATE_VALUE
,      NUMBER_VALUE
,      OBJECT_VERSION_NUMBER
FROM HR.PER_QUERY_CRITERIA#;

Dependencies

[top of page]

HR.PER_QUERY_CRITERIA# references the following:

SchemaHR
TablePER_QUERY_CRITERIA
HR.PER_QUERY_CRITERIA# is referenced by following:

SchemaAPPS
SynonymPER_QUERY_CRITERIA
TriggerPER_QUERY_CRITERIA_OVN