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

Object Details

Object Name:	BIL_DIMV_SKILLS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BIL.BIL_DIMV_SKILLS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
PERSON_ID	NUMBER		Salesrep person id
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Business group to which salesrep belongs
PERSON_NAME	VARCHAR2	(240)	Salesrep name
COMPETENCE_NAME	VARCHAR2	(700)	Competence name
DATE_FROM	DATE		Start date for which training for this competence was attended
DATE_TO	DATE		Start date for which training for this competence was attended
PROFICIENCY_RATING_SOURCE	VARCHAR2	(4000)	Proficiency rating source for this competence
CERTIFICATION_METHOD	VARCHAR2	(4000)	certification method for this competence
CERTIFICATION_DATE	DATE		Certification date for this competence
NEXT_REVIEW_DATE	DATE		Next review date
PROFICIENCY_LEVEL	VARCHAR2	(80)	Competence proficiency level
BUSINESS_GROUP_ID	NUMBER		Business group identifier
COMPETENCE_ID	NUMBER		Competence identifier

Query Text

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


SELECT PERSON_ID
,      BUSINESS_GROUP_NAME
,      PERSON_NAME
,      COMPETENCE_NAME
,      DATE_FROM
,      DATE_TO
,      PROFICIENCY_RATING_SOURCE
,      CERTIFICATION_METHOD
,      CERTIFICATION_DATE
,      NEXT_REVIEW_DATE
,      PROFICIENCY_LEVEL
,      BUSINESS_GROUP_ID
,      COMPETENCE_ID
FROM APPS.BIL_DIMV_SKILLS;

Dependencies

[top of page]

APPS.BIL_DIMV_SKILLS references the following:

APPS: BIL_DIMV_SALESFORCE; FND_GLOBAL - show dependent code; FND_LOOKUPS; HRFV_COMPETENCE_PROFILES; HRFV_REQUIRED_COMPETENCES; HR_BIS - show dependent code; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code

APPS.BIL_DIMV_SKILLS is not referenced by any database object