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.IRCFV_VACANCY_COMP_RQRMNTS

Object Details

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

View Type

A Business Intelligence System view

Shows the Skills (competencies) required by vacancies.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
VACANCY_NAME	VARCHAR2	(30)	Yes	Vacancy name.
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Yes	Translated name of the organization
COMPETENCE_NAME	VARCHAR2	(700)	Yes	The short name of the competence
MIN_RATING_LEVEL_NAME	VARCHAR2	(80)		A description of the rating level that the step indicates e.g. Poor, Average, Excellent
MIN_LEVEL_STEP_VALUE	NUMBER	(15)		The sequence number of the rating scale used for ordering the steps
MAX_RATING_LEVEL_NAME	VARCHAR2	(80)		A description of the rating level that the step indicates e.g. Poor, Average, Excellent
MAX_LEVEL_STEP_VALUE	NUMBER	(15)		The sequence number of the rating scale used for ordering the steps
ESSENTIAL	VARCHAR2	(4000)
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
ORGANIZATION_ID	NUMBER	(15)
JOB_ID	NUMBER	(15)
POSITION_ID	NUMBER	(15)
GRADE_ID	NUMBER	(15)
COMPETENCE_ELEMENT_ID	NUMBER	(15)	Yes
COMPETENCE_ID	NUMBER	(15)
ENTERPRISE_ID	NUMBER	(15)
VACANCY_ID	NUMBER	(15)
MIN_LEVEL_ID	NUMBER	(15)
MAX_LEVEL_ID	NUMBER	(15)

Query Text

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


SELECT VACANCY_NAME
,      BUSINESS_GROUP_NAME
,      COMPETENCE_NAME
,      MIN_RATING_LEVEL_NAME
,      MIN_LEVEL_STEP_VALUE
,      MAX_RATING_LEVEL_NAME
,      MAX_LEVEL_STEP_VALUE
,      ESSENTIAL
,      BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      JOB_ID
,      POSITION_ID
,      GRADE_ID
,      COMPETENCE_ELEMENT_ID
,      COMPETENCE_ID
,      ENTERPRISE_ID
,      VACANCY_ID
,      MIN_LEVEL_ID
,      MAX_LEVEL_ID
FROM APPS.IRCFV_VACANCY_COMP_RQRMNTS;

Dependencies

[top of page]

APPS.IRCFV_VACANCY_COMP_RQRMNTS references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; HR_BIS - show dependent code; PER_ALL_VACANCIES; PER_COMPETENCES; PER_COMPETENCE_ELEMENTS; PER_RATING_LEVELS

APPS.IRCFV_VACANCY_COMP_RQRMNTS is not referenced by any database object