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

VIEW: APPS.PER_POSITIONS_LOV_V

Object Details
Object Name: PER_POSITIONS_LOV_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_POSITIONS_LOV_V
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

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
POSITION VARCHAR2 (4000)
Position Name
POSITION_ID NUMBER (15)
Position Identifier
LOCATION_ID NUMBER (15)
Location Identifier
WORKING_HOURS NUMBER (22)
Working Hours
FREQUENCY VARCHAR2 (30)
Frequency
TIME_NORMAL_FINISH VARCHAR2 (5)
Normal Finish Time
TIME_NORMAL_START VARCHAR2 (5)
Normal Start Time
PROBATION_PERIOD NUMBER (22)
Probation Period
PROBATION_PERIOD_UNITS VARCHAR2 (30)
Probation Period Units
BUSINESS_GROUP_ID NUMBER (15)
Business Group Identifier
ORGANIZATION_ID NUMBER (15)
Organization Identifier
JOB_ID NUMBER (15)
Job Identifier
DATE_EFFECTIVE DATE

Date Effective
DATE_END DATE

Date End
STATUS VARCHAR2 (30)
Status
POSITION_DEFINITION_ID NUMBER

Position Definition Identifier
Query Text

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


SELECT POSITION
,      POSITION_ID
,      LOCATION_ID
,      WORKING_HOURS
,      FREQUENCY
,      TIME_NORMAL_FINISH
,      TIME_NORMAL_START
,      PROBATION_PERIOD
,      PROBATION_PERIOD_UNITS
,      BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      JOB_ID
,      DATE_EFFECTIVE
,      DATE_END
,      STATUS
,      POSITION_DEFINITION_ID
FROM APPS.PER_POSITIONS_LOV_V;

Dependencies

[top of page]

APPS.PER_POSITIONS_LOV_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_POSITIONS
PL/SQL PackageHR_PSF_SHD - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
APPS.PER_POSITIONS_LOV_V is referenced by following:

SchemaPUBLIC
SynonymPER_POSITIONS_LOV_V