[Home] [Help] [Dependency Information]

VIEW: APPS.HR_ALL_POSITIONS_D

Object Details

Object Name:	HR_ALL_POSITIONS_D
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_ALL_POSITIONS_D
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

Query Text

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

SELECT POSITION_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      AVAILABILITY_STATUS_DESC
,      ENTRY_STEP_DESC
,      JOB_DESC
,      LOCATION_DESC
,      ORGANIZATION_DESC
,      PAY_FREQ_PAYROLL_DESC
,      RELIEF_POSITION_DESC
,      ENTRY_GRADE_DESC
,      SUCCESSOR_POSITION_DESC
,      SUPERVISOR_POSITION_DESC
,      BARGAINING_UNIT_DESC
,      DATE_EFFECTIVE
,      DATE_END
,      FREQUENCY_DESC
,      FTE
,      MAX_PERSONS
,      NAME
,      OVERLAP_PERIOD
,      OVERLAP_UNIT_DESC
,      PERMANENT_TEMPORARY_FLAG
,      POSITION_TYPE_DESC
,      POSTING_DESCRIPTION
,      PROBATION_PERIOD
,      PROBATION_UNIT_DESC
,      REPLACEMENT_REQUIRED_DESC
,      SEASONAL_FLAG
,      TERM_START_DAY_DESC
,      TERM_START_MONTH_DESC
,      TIME_NORMAL_FINISH
,      WORKING_HOURS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.HR_ALL_POSITIONS_D;

Dependencies

[top of page]

APPS

FND_FLEX_EXT - show dependent code

FND_USER

HR_ALL_POSITIONS_F

HR_GENERAL - show dependent code

PAY_GRADE_RULES

PER_POSITION_DEFINITIONS

APPS.HR_ALL_POSITIONS_D is not referenced by any database object