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

VIEW: APPS.PER_POSITIONS_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
POSITION_ID NUMBER (15) Yes
ROW_ID ROWID (10)

BUSINESS_GROUP_ID NUMBER (15) Yes
JOB_ID NUMBER (15) Yes
JOB_NAME VARCHAR2 (700)

ORGANIZATION_ID NUMBER (15) Yes
ORG_NAME VARCHAR2 (240) Yes
SUCCESSOR_POSITION_ID NUMBER (15)

SUCC_NAME VARCHAR2 (240)

RELIEF_POSITION_ID NUMBER (15)

REL_NAME VARCHAR2 (240)

LOCATION_ID NUMBER (15)

LOCATION_CODE VARCHAR2 (60)

POSITION_DEFINITION_ID NUMBER (15) Yes
DATE_EFFECTIVE DATE
Yes
COMMENTS LONG (0)

DATE_END DATE


FREQUENCY VARCHAR2 (30)

FREQUENCY_DESC VARCHAR2 (80)

NAME VARCHAR2 (240)

PROBATION_PERIOD NUMBER (22)

PROBATION_PERIOD_UNITS VARCHAR2 (30)

PROB_UNITS_DESC VARCHAR2 (80)

REPLACEMENT_REQUIRED_FLAG VARCHAR2 (30)

REP_REQ_DESC VARCHAR2 (80)

STATUS VARCHAR2 (30)
STATUS_DESC VARCHAR2 (80)
TIME_NORMAL_FINISH VARCHAR2 (5)

TIME_NORMAL_START VARCHAR2 (5)

WORKING_HOURS NUMBER (22)

REQUEST_ID NUMBER (15)

PROGRAM_APPLICATION_ID NUMBER (15)

PROGRAM_ID NUMBER (15)

PROGRAM_UPDATE_DATE DATE


ATTRIBUTE_CATEGORY VARCHAR2 (30)

ATTRIBUTE1 VARCHAR2 (150)

ATTRIBUTE2 VARCHAR2 (150)

ATTRIBUTE3 VARCHAR2 (150)

ATTRIBUTE4 VARCHAR2 (150)

ATTRIBUTE5 VARCHAR2 (150)

ATTRIBUTE6 VARCHAR2 (150)

ATTRIBUTE7 VARCHAR2 (150)

ATTRIBUTE8 VARCHAR2 (150)

ATTRIBUTE9 VARCHAR2 (150)

ATTRIBUTE10 VARCHAR2 (150)

ATTRIBUTE11 VARCHAR2 (150)

ATTRIBUTE12 VARCHAR2 (150)

ATTRIBUTE13 VARCHAR2 (150)

ATTRIBUTE14 VARCHAR2 (150)

ATTRIBUTE15 VARCHAR2 (150)

ATTRIBUTE16 VARCHAR2 (150)

ATTRIBUTE17 VARCHAR2 (150)

ATTRIBUTE18 VARCHAR2 (150)

ATTRIBUTE19 VARCHAR2 (150)

ATTRIBUTE20 VARCHAR2 (150)

LAST_UPDATE_DATE DATE


LAST_UPDATED_BY NUMBER (15)

LAST_UPDATE_LOGIN NUMBER (15)

CREATED_BY NUMBER (15)

CREATION_DATE DATE


Query Text

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


SELECT POSITION_ID
,      ROW_ID
,      BUSINESS_GROUP_ID
,      JOB_ID
,      JOB_NAME
,      ORGANIZATION_ID
,      ORG_NAME
,      SUCCESSOR_POSITION_ID
,      SUCC_NAME
,      RELIEF_POSITION_ID
,      REL_NAME
,      LOCATION_ID
,      LOCATION_CODE
,      POSITION_DEFINITION_ID
,      DATE_EFFECTIVE
,      COMMENTS
,      DATE_END
,      FREQUENCY
,      FREQUENCY_DESC
,      NAME
,      PROBATION_PERIOD
,      PROBATION_PERIOD_UNITS
,      PROB_UNITS_DESC
,      REPLACEMENT_REQUIRED_FLAG
,      REP_REQ_DESC
,      STATUS
,      STATUS_DESC
,      TIME_NORMAL_FINISH
,      TIME_NORMAL_START
,      WORKING_HOURS
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PER_POSITIONS_V;

Dependencies

[top of page]

APPS.PER_POSITIONS_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_ALL_POSITIONS_F_TL
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
ViewHR_LOOKUPS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPER_ALL_POSITIONS
SynonymPER_JOBS_TL
ViewPER_POSITIONS
APPS.PER_POSITIONS_V is referenced by following:

SchemaPUBLIC
SynonymPER_POSITIONS_V