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_RESOURCE_CHECKLIST

Object Details

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

View Type

A Business Intelligence System view

This view shows the infomation about minimum resources required to conduct an activity.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Yes
RESOURCE_TYPE	VARCHAR2	(4000)
RESOURCE_NAME	VARCHAR2	(400)
RESOURCE_QUANTITY	NUMBER
RESOURCE_REQUIRED	VARCHAR2	(4000)
RESOURCE_USAGE	VARCHAR2	(4000)
RESOURCE_ROLE	VARCHAR2	(4000)
RESOURCE_START_DATE	DATE		Yes
RESOURCE_END_DATE	DATE
RESOURCE_USAGE_COMMENTS	VARCHAR2	(2000)		Free text comments
INVENTORY_ORGANIZATION	VARCHAR2	(240)
_KF:INVENTORY_ITEM	CHAR	(16)
ACTIVITY_NAME	VARCHAR2	(80)	Yes
ACTIVITY_DESCRIPTION	VARCHAR2	(4000)
ACTIVITY_AUDIENCE	VARCHAR2	(4000)
ACTIVITY_OBJECTIVES	VARCHAR2	(4000)
ACTIVITY_LANGUAGE	VARCHAR2	(255)
NEXT_ACTIVITY	VARCHAR2	(80)
ACTIVITY_FROM	DATE
ACTIVITY_TO	DATE
SPONSOR_BY	VARCHAR2	(240)
MANAGED_BY	VARCHAR2	(240)
ACTIVITY_STATUS	VARCHAR2	(4000)
SUCCESS_CRITERIA	VARCHAR2	(4000)
ALLOW_EXPENSES	VARCHAR2	(4000)
MINIMUM_STUDENTS	NUMBER	(9)
MAXIMUM_STUDENTS	NUMBER	(9)
MAXIMUM_INTERNAL_STUDENTS	NUMBER	(9)
CURRENCY	VARCHAR2	(4000)
DURATION	NUMBER	(9)
DURATION_UNITS	VARCHAR2	(4000)
PROFESSIONAL_CREDITS_TYPE	VARCHAR2	(4000)
PROFESSIONAL_CREDIT_AMOUNT	NUMBER
SUPPLIER_NAME	VARCHAR2	(240)
ACTIVITY_TYPE	VARCHAR2	(240)	Yes
ACTIVITY_TYPE_DESCRIPTION	VARCHAR2	(4000)
CATEGORY_NAME	VARCHAR2	(240)
_DF	CHAR	(31)
BUSINESS_GROUP_ID	NUMBER	(9)	Yes
RESOURCE_CHECK_LIST_ID	NUMBER	(9)	Yes
SUPPLIED_RESOURCE_ID	NUMBER	(9)
ACTIVITY_VERSION_ID	NUMBER	(9)	Yes
INVENTORY_ORGANIZATION_ID	NUMBER	(15)
INVENTORY_ITEM_ID	NUMBER	(10)
SPONSOR_ORGANIZATION_ID	NUMBER	(9)	Yes
MANAGED_BY_PERSON_ID	NUMBER	(10)
LANGUAGE_ID	NUMBER	(9)
SUPERSESED_ACT_VERSION_ID	NUMBER	(9)
ACTIVITY_ID	NUMBER	(9)	Yes
RCO_ID	NUMBER

Query Text

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


SELECT BUSINESS_GROUP_NAME
,      RESOURCE_TYPE
,      RESOURCE_NAME
,      RESOURCE_QUANTITY
,      RESOURCE_REQUIRED
,      RESOURCE_USAGE
,      RESOURCE_ROLE
,      RESOURCE_START_DATE
,      RESOURCE_END_DATE
,      RESOURCE_USAGE_COMMENTS
,      INVENTORY_ORGANIZATION
,      _KF:INVENTORY_ITEM
,      ACTIVITY_NAME
,      ACTIVITY_DESCRIPTION
,      ACTIVITY_AUDIENCE
,      ACTIVITY_OBJECTIVES
,      ACTIVITY_LANGUAGE
,      NEXT_ACTIVITY
,      ACTIVITY_FROM
,      ACTIVITY_TO
,      SPONSOR_BY
,      MANAGED_BY
,      ACTIVITY_STATUS
,      SUCCESS_CRITERIA
,      ALLOW_EXPENSES
,      MINIMUM_STUDENTS
,      MAXIMUM_STUDENTS
,      MAXIMUM_INTERNAL_STUDENTS
,      CURRENCY
,      DURATION
,      DURATION_UNITS
,      PROFESSIONAL_CREDITS_TYPE
,      PROFESSIONAL_CREDIT_AMOUNT
,      SUPPLIER_NAME
,      ACTIVITY_TYPE
,      ACTIVITY_TYPE_DESCRIPTION
,      CATEGORY_NAME
,      _DF
,      BUSINESS_GROUP_ID
,      RESOURCE_CHECK_LIST_ID
,      SUPPLIED_RESOURCE_ID
,      ACTIVITY_VERSION_ID
,      INVENTORY_ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SPONSOR_ORGANIZATION_ID
,      MANAGED_BY_PERSON_ID
,      LANGUAGE_ID
,      SUPERSESED_ACT_VERSION_ID
,      ACTIVITY_ID
,      RCO_ID
FROM APPS.OTFV_RESOURCE_CHECKLIST;

Dependencies

[top of page]

APPS.OTFV_RESOURCE_CHECKLIST references the following:

APPS: FND_LANGUAGES; FND_LANGUAGES_TL; HR_ALL_ORGANIZATION_UNITS_TL; HR_BIS - show dependent code; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; MTL_SYSTEM_ITEMS_B; ORG_ORGANIZATION_DEFINITIONS; OTA_ACTIVITY_DEFINITIONS; OTA_ACTIVITY_DEFINITIONS_TL; OTA_ACTIVITY_VERSIONS; OTA_ACTIVITY_VERSIONS_TL; OTA_ACT_CAT_INCLUSIONS; OTA_CATEGORY_USAGES; OTA_CATEGORY_USAGES_TL; OTA_GENERAL - show dependent code; OTA_OFFERINGS; OTA_RESOURCE_USAGES; OTA_SUPPLIABLE_RESOURCES; OTA_SUPPLIABLE_RESOURCES_TL; PER_ALL_PEOPLE_F; PO_VENDORS

APPS.OTFV_RESOURCE_CHECKLIST is not referenced by any database object