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


VIEW: APPS.HRFV_POSITIONS

Object Details
Object Name: HRFV_POSITIONS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HRFV_POSITIONS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This view shows the positions defined for your enterprise.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Yes
POSITION_NAME VARCHAR2 (240)
_KF:POSITION_NAME CHAR (16)

DATE_FROM DATE
Yes
DATE_TO DATE


WORKING_HOURS_AMOUNT NUMBER (22)

WORKING_HOURS_FREQUENCY VARCHAR2 (4000)

PROBATION_PERIOD NUMBER (22)

PROBATION_UNITS VARCHAR2 (4000)

NORMAL_START_TIME VARCHAR2 (5)

NORMAL_END_TIME VARCHAR2 (5)

COMMENTS CLOB (4000)

REPLACEMENT_POSITION_NAME VARCHAR2 (240)

ORGANIZATION_NAME VARCHAR2 (240) Yes
JOB_NAME VARCHAR2 (700)

LOCATION_NAME VARCHAR2 (60)

_DF CHAR (25)

BUSINESS_GROUP_ID NUMBER (15) Yes
JOB_ID NUMBER (15) Yes
LOCATION_ID NUMBER (15)

ORGANIZATION_ID NUMBER (15) Yes
POSITION_ID NUMBER (15) Yes
POSITION_DEFINITION_ID NUMBER (15) Yes
RELIEF_POSITION_ID NUMBER (15)

Query Text

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


SELECT BUSINESS_GROUP_NAME
,      POSITION_NAME
,      _KF:POSITION_NAME
,      DATE_FROM
,      DATE_TO
,      WORKING_HOURS_AMOUNT
,      WORKING_HOURS_FREQUENCY
,      PROBATION_PERIOD
,      PROBATION_UNITS
,      NORMAL_START_TIME
,      NORMAL_END_TIME
,      COMMENTS
,      REPLACEMENT_POSITION_NAME
,      ORGANIZATION_NAME
,      JOB_NAME
,      LOCATION_NAME
,      _DF
,      BUSINESS_GROUP_ID
,      JOB_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      POSITION_ID
,      POSITION_DEFINITION_ID
,      RELIEF_POSITION_ID
FROM APPS.HRFV_POSITIONS;

Dependencies

[top of page]

APPS.HRFV_POSITIONS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_ALL_POSITIONS_F_TL
PL/SQL PackageHR_BIS - show dependent code
SynonymHR_LOCATIONS_ALL_TL
SynonymPER_ALL_POSITIONS
SynonymPER_JOBS_TL
SynonymPER_POSITION_DEFINITIONS

APPS.HRFV_POSITIONS is not referenced by any database object