eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: HR_POSITIONS_LOV_V

Product:	PER - Human Resources
Description:	Used to get list of value on Mass Move form.
Implementation/DBA Data:	APPS.HR_POSITIONS_LOV_V

View Text

SELECT P.NAME
, P.POSITION_ID
, P.LOCATION_ID
, P.WORKING_HOURS
, P.FREQUENCY
, P.TIME_NORMAL_FINISH
, P.TIME_NORMAL_START
, P.PROBATION_PERIOD
, P.PROBATION_PERIOD_UNIT_CD
, P.BUSINESS_GROUP_ID
, P.ORGANIZATION_ID
, P.JOB_ID
, P.DATE_EFFECTIVE
, P.DATE_END
, P.STATUS
, P.POSITION_DEFINITION_ID
FROM HR_POSITIONS P

Columns

Name
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