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


VIEW: APPS.HRI_OBI_CL_POS_POSITION_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
POS_POSITION_PK NUMBER

POS_POSITION_NAME VARCHAR2 (4000)
POS_POSITION_NAME_UNQ VARCHAR2 (4000)
POS_VALID_FROM DATE

POS_VALID_TO DATE

POS_ORDER_BY VARCHAR2 (240)
POS_ORG_ORGANZTN_FK NUMBER

POS_JOB_JOB_FK NUMBER

POS_POSITION_DEFINITION_ID NUMBER

Query Text

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


SELECT POS_POSITION_PK
,      POS_POSITION_NAME
,      POS_POSITION_NAME_UNQ
,      POS_VALID_FROM
,      POS_VALID_TO
,      POS_ORDER_BY
,      POS_ORG_ORGANZTN_FK
,      POS_JOB_JOB_FK
,      POS_POSITION_DEFINITION_ID
FROM APPS.HRI_OBI_CL_POS_POSITION_V;

Dependencies

[top of page]

APPS.HRI_OBI_CL_POS_POSITION_V references the following:

SchemaAPPS
PL/SQL PackageHRI_OLTP_VIEW_MESSAGE - show dependent code
SynonymHRI_UNASSIGNED
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_POSITIONS

APPS.HRI_OBI_CL_POS_POSITION_V is not referenced by any database object