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

Object Details

Object Name:	OTFV_SKILL_PROVISIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OTA.OTFV_SKILL_PROVISIONS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view shows the information about qualifications, competencies and experience an activity version can provide.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SKILL_PROVISION_TYPE	VARCHAR2	(4000)		The type of development output.
SKILL_PROVISION_COMMENTS	VARCHAR2	(2000)
_KF:ANALYSIS_CRITERIA	CHAR	(15)
ACTIVITY_NAME	VARCHAR2	(80)	Yes	The name of the training activity
ACTIVITY_TYPE	VARCHAR2	(240)	Yes
_DF	CHAR	(32)
ANALYSIS_CRITERIA_ID	NUMBER	(15)	Yes
ACTIVITY_VERSION_ID	NUMBER	(9)	Yes
ACTIVITY_ID	NUMBER	(9)	Yes
SKILL_PROVISION_ID	NUMBER	(9)	Yes
RCO_ID	NUMBER

Query Text

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


SELECT SKILL_PROVISION_TYPE
,      SKILL_PROVISION_COMMENTS
,      _KF:ANALYSIS_CRITERIA
,      ACTIVITY_NAME
,      ACTIVITY_TYPE
,      _DF
,      ANALYSIS_CRITERIA_ID
,      ACTIVITY_VERSION_ID
,      ACTIVITY_ID
,      SKILL_PROVISION_ID
,      RCO_ID
FROM APPS.OTFV_SKILL_PROVISIONS;

Dependencies

[top of page]

APPS.OTFV_SKILL_PROVISIONS references the following:

APPS: HR_BIS - show dependent code; OTA_ACTIVITY_DEFINITIONS; OTA_ACTIVITY_DEFINITIONS_TL; OTA_ACTIVITY_VERSIONS; OTA_ACTIVITY_VERSIONS_TL; OTA_SKILL_PROVISIONS; PER_ANALYSIS_CRITERIA

APPS.OTFV_SKILL_PROVISIONS is not referenced by any database object