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

VIEW: HR.HR_PATTERN_PURPOSES#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
PATTERN_PURPOSE_ID NUMBER
Yes
PATTERN_PURPOSE VARCHAR2 (30) Yes
PATTERN_ID NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

LAST_UPDATE_DATE DATE

Query Text

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


SELECT PATTERN_PURPOSE_ID
,      PATTERN_PURPOSE
,      PATTERN_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM HR.HR_PATTERN_PURPOSES#;

Dependencies

[top of page]

HR.HR_PATTERN_PURPOSES# references the following:

SchemaHR
TableHR_PATTERN_PURPOSES
HR.HR_PATTERN_PURPOSES# is referenced by following:

SchemaAPPS
SynonymHR_PATTERN_PURPOSES
TriggerHR_PATTERN_PURPOSES_WHO