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


VIEW: APPS.HRFV_REQUIRED_COMPETENCES

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

View Type

A Business Intelligence System view


This view shows the two types of competencies defined: (1) core, or generic, applying throughout your enterprise; (2) competencies that are organization, job or position specific.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240)

ORGANIZATION_NAME VARCHAR2 (240)

POSITION_NAME VARCHAR2 (240)

JOB_NAME VARCHAR2 (700)

GRADE_NAME VARCHAR2 (240)

COMPETENCE_NAME VARCHAR2 (700)

MANDATORY VARCHAR2 (4000)

DATE_FROM DATE


DATE_TO DATE


COMMENTS VARCHAR2 (2000)

MIN_PROFICIENCY VARCHAR2 (123)

MAX_PROFICIENCY VARCHAR2 (123)

CORE_COMPETENCE_FLAG VARCHAR2 (4000)
_DF CHAR (36)

_KF:CMP CHAR (16)
BUSINESS_GROUP_ID NUMBER (15)

COMPETENCE_ID NUMBER (15)

COMPETENCE_ELEMENT_ID NUMBER (15)

ENTERPRISE_ID NUMBER (15)

HIGH_PROFICIENCY_LEVEL_ID NUMBER (15)

JOB_ID NUMBER (15)

ORGANIZATION_ID NUMBER (15)

POSITION_ID NUMBER (15)

PROFICIENCY_LEVEL_ID NUMBER (15)

GRADE_ID NUMBER (15)
Query Text

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


SELECT BUSINESS_GROUP_NAME
,      ORGANIZATION_NAME
,      POSITION_NAME
,      JOB_NAME
,      GRADE_NAME
,      COMPETENCE_NAME
,      MANDATORY
,      DATE_FROM
,      DATE_TO
,      COMMENTS
,      MIN_PROFICIENCY
,      MAX_PROFICIENCY
,      CORE_COMPETENCE_FLAG
,      _DF
,      _KF:CMP
,      BUSINESS_GROUP_ID
,      COMPETENCE_ID
,      COMPETENCE_ELEMENT_ID
,      ENTERPRISE_ID
,      HIGH_PROFICIENCY_LEVEL_ID
,      JOB_ID
,      ORGANIZATION_ID
,      POSITION_ID
,      PROFICIENCY_LEVEL_ID
,      GRADE_ID
FROM APPS.HRFV_REQUIRED_COMPETENCES;

Dependencies

[top of page]

APPS.HRFV_REQUIRED_COMPETENCES references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_ALL_POSITIONS_F_TL
PL/SQL PackageHR_BIS - show dependent code
SynonymPER_ALL_POSITIONS
SynonymPER_COMPETENCES
SynonymPER_COMPETENCES_TL
SynonymPER_COMPETENCE_DEFINITIONS
SynonymPER_COMPETENCE_ELEMENTS
SynonymPER_GRADES_TL
SynonymPER_JOBS_TL
SynonymPER_RATING_LEVELS
SynonymPER_RATING_LEVELS_TL
SynonymPER_VALID_GRADES

APPS.HRFV_REQUIRED_COMPETENCES is not referenced by any database object