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

VIEW: HRI.HRI_PRIMARY_HRCHYS#

Object Details
Object Name: HRI_PRIMARY_HRCHYS#
Object Type: VIEW
Owner: HRI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_STRUCTURE_ID NUMBER
Yes
ORG_STRUCTURE_VERSION_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
PARENT_ORGANIZATION_ID NUMBER

ORGANIZATION_LEVEL NUMBER

BUSINESS_GROUP_ID NUMBER

ORG_LAST_UPDATED DATE

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

Query Text

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


SELECT ORGANIZATION_STRUCTURE_ID
,      ORG_STRUCTURE_VERSION_ID
,      ORGANIZATION_ID
,      PARENT_ORGANIZATION_ID
,      ORGANIZATION_LEVEL
,      BUSINESS_GROUP_ID
,      ORG_LAST_UPDATED
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HRI.HRI_PRIMARY_HRCHYS#;

Dependencies

[top of page]

HRI.HRI_PRIMARY_HRCHYS# references the following:

SchemaHRI
TableHRI_PRIMARY_HRCHYS
HRI.HRI_PRIMARY_HRCHYS# is referenced by following:

SchemaAPPS
SynonymHRI_PRIMARY_HRCHYS
TriggerHRI_PRIMARY_HRCHYS_WHO