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

VIEW: APPS.HRI_MB_CMPTNC_RQRMNT_V

Object Details
Object Name: HRI_MB_CMPTNC_RQRMNT_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Base Metric for Competence Requirements for Business Groups, Organization, Job (with grade) and Position (with Grade) with Security Flags.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_INDICATOR NUMBER

CORE_CMPTNC_INDICATOR NUMBER

ESSNTL_CMPTNC_INDICATOR NUMBER

ORGANIZATION_RQRMNT_INDICATOR NUMBER

JOB_RQRMNT_INDICATOR NUMBER

GRADE_RQRMNT_INDICATOR NUMBER

POSITION_RQRMNT_INDICATOR NUMBER

EFFECTIVE_START_DATE DATE

EFFECTIVE_END_DATE DATE

BUSINESS_GROUP_ID NUMBER (15)
ORGANIZATION_ID NUMBER

JOB_ID NUMBER

GRADE_ID NUMBER

POSITION_ID NUMBER

ENTERPRISE_ID NUMBER

COMPETENCE_ID NUMBER (15)
COMPETENCE_ELEMENT_ID NUMBER (15) Yes
LOW_LEVEL_ID NUMBER

HIGH_LEVEL_ID NUMBER

ESSNTL_CMPTNC_FLAG_CODE VARCHAR2 (30)
LAST_CHANGE_DATE DATE

BG_SECURITY_FLAG_CODE CHAR (1)
Query Text

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


SELECT ROW_INDICATOR
,      CORE_CMPTNC_INDICATOR
,      ESSNTL_CMPTNC_INDICATOR
,      ORGANIZATION_RQRMNT_INDICATOR
,      JOB_RQRMNT_INDICATOR
,      GRADE_RQRMNT_INDICATOR
,      POSITION_RQRMNT_INDICATOR
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      JOB_ID
,      GRADE_ID
,      POSITION_ID
,      ENTERPRISE_ID
,      COMPETENCE_ID
,      COMPETENCE_ELEMENT_ID
,      LOW_LEVEL_ID
,      HIGH_LEVEL_ID
,      ESSNTL_CMPTNC_FLAG_CODE
,      LAST_CHANGE_DATE
,      BG_SECURITY_FLAG_CODE
FROM APPS.HRI_MB_CMPTNC_RQRMNT_V;

Dependencies

[top of page]

APPS.HRI_MB_CMPTNC_RQRMNT_V references the following:

SchemaAPPS
PL/SQL PackageHR_BIS - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymPER_COMPETENCE_ELEMENTS
SynonymPER_VALID_GRADES

APPS.HRI_MB_CMPTNC_RQRMNT_V is not referenced by any database object