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.

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

VIEW: APPS.HRBV_POSITION

Object Details

Object Name:	HRBV_POSITION
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Positions (from per_position_definitions, hr_all_positions_f_tl, per_positions tables)

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
POSITION_NAME	VARCHAR2	(240)		Translated Position Name
_KF:POSITION_NAME	CHAR	(16)		Key flexfield column
DATE_FROM	DATE		Yes	From date
DATE_TO	DATE			To date
POSITION_STATUS	VARCHAR2	(4000)		Position ststus
WORKING_HOURS_AMOUNT	NUMBER	(22)		Working hours amount
WORKING_HOURS_FREQUENCY	VARCHAR2	(4000)		Working hours frequency
PROBATION_PERIOD	NUMBER	(22)		Probation period
PROBATION_UNITS	VARCHAR2	(4000)		Probation units
REPLACEMENT_REQUIRED_FLAG	VARCHAR2	(4000)		Replacement required flag
NORMAL_START_TIME	VARCHAR2	(5)		Normal start time
NORMAL_END_TIME	VARCHAR2	(5)		Normal End time
COMMENTS	CLOB	(4000)		Comments
_DF	CHAR	(25)
POSITION_STATUS_CODE	VARCHAR2	(30)		Position status code
WORKING_HOURS_FREQUENCY_CODE	VARCHAR2	(30)		Working Hours Frequency Code
PROBATION_PERIOD_UNITS_CODE	VARCHAR2	(30)		Probation period unitscode
REPLACEMENT_REQUIRED_FLAG_CODE	VARCHAR2	(30)		Replacement required flag code
LEGISLATION_CODE	VARCHAR2	(4000)		Legislation Code
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business group id
JOB_ID	NUMBER	(15)	Yes	Job id
LOCATION_ID	NUMBER	(15)		Location id
ORGANIZATION_ID	NUMBER	(15)	Yes	Organization id
POSITION_ID	NUMBER	(15)	Yes	Position Id
POSITION_DEFINITION_ID	NUMBER	(15)	Yes	Position definition Id
RELIEF_POSITION_ID	NUMBER	(15)		Relief position Id
SUCCESSOR_POSITION_ID	NUMBER	(15)		Successor position Id
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER	(15)		Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
CREATED_BY	NUMBER	(15)		Standard who column
CREATION_DATE	DATE			Standard who column
BG_SECURITY_FLAG_CODE	CHAR	(1)		BG Security Flag code

Query Text

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


SELECT POSITION_NAME
,      _KF:POSITION_NAME
,      DATE_FROM
,      DATE_TO
,      POSITION_STATUS
,      WORKING_HOURS_AMOUNT
,      WORKING_HOURS_FREQUENCY
,      PROBATION_PERIOD
,      PROBATION_UNITS
,      REPLACEMENT_REQUIRED_FLAG
,      NORMAL_START_TIME
,      NORMAL_END_TIME
,      COMMENTS
,      _DF
,      POSITION_STATUS_CODE
,      WORKING_HOURS_FREQUENCY_CODE
,      PROBATION_PERIOD_UNITS_CODE
,      REPLACEMENT_REQUIRED_FLAG_CODE
,      LEGISLATION_CODE
,      BUSINESS_GROUP_ID
,      JOB_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      POSITION_ID
,      POSITION_DEFINITION_ID
,      RELIEF_POSITION_ID
,      SUCCESSOR_POSITION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_POSITION;

Dependencies

[top of page]

APPS.HRBV_POSITION references the following:

APPS: HR_ALL_POSITIONS_F_TL; HR_API - show dependent code; HR_BIS - show dependent code; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; PER_POSITIONS; PER_POSITION_DEFINITIONS

APPS.HRBV_POSITION is not referenced by any database object