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

VIEW: APPS.HRI_CS_POSHRO_X_V

Object Details
Object Name: HRI_CS_POSHRO_X_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
SUP_ABSOLUTE_LEVEL NUMBER
Yes
SUB_ABSOLUTE_LEVEL NUMBER (15) Yes
SUB_RELATIVE_LEVEL NUMBER
Yes
SUBRO_ABSOLUTE_LEVEL NUMBER (15) Yes
SUBRO_SUP_RELATIVE_LEVEL NUMBER
Yes
SUBRO_SUB_RELATIVE_LEVEL NUMBER

EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
PRIMARY_HIERARCHY_FLAG_CODE VARCHAR2 (30)
SUP_POSITION_ID NUMBER (15) Yes
SUB_POSITION_ID NUMBER (15) Yes
SUBRO_POSITION_ID NUMBER (15) Yes
SUP_BUSINESS_GROUP_ID NUMBER (15) Yes
SUB_BUSINESS_GROUP_ID NUMBER (15) Yes
POSITION_STRUCTURE_ID NUMBER

POS_STRUCTURE_VERSION_ID NUMBER

Query Text

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


SELECT SUP_ABSOLUTE_LEVEL
,      SUB_ABSOLUTE_LEVEL
,      SUB_RELATIVE_LEVEL
,      SUBRO_ABSOLUTE_LEVEL
,      SUBRO_SUP_RELATIVE_LEVEL
,      SUBRO_SUB_RELATIVE_LEVEL
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PRIMARY_HIERARCHY_FLAG_CODE
,      SUP_POSITION_ID
,      SUB_POSITION_ID
,      SUBRO_POSITION_ID
,      SUP_BUSINESS_GROUP_ID
,      SUB_BUSINESS_GROUP_ID
,      POSITION_STRUCTURE_ID
,      POS_STRUCTURE_VERSION_ID
FROM APPS.HRI_CS_POSHRO_X_V;

Dependencies

[top of page]

APPS.HRI_CS_POSHRO_X_V references the following:

SchemaAPPS
ViewHRI_CS_POSH_V

APPS.HRI_CS_POSHRO_X_V is not referenced by any database object