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_ACTIVITY_CATEGORIES

Object Details

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

View Type

A Business Intelligence System view

This view shows the Category type for an Activity.

[View Source]

Columns

Name	Datatype	Length	Mandatory
CATEGORY_NAME	VARCHAR2	(240)
ACT_CAT_INCLUSION_FROM	DATE
ACT_CAT_INCLUSION_TO	DATE
PRIMARY_FLAG	VARCHAR2	(4000)
CATEGORY_TYPE	VARCHAR2	(4000)
ACTIVITY_TYPE	VARCHAR2	(240)	Yes
ACTIVITY_NAME	VARCHAR2	(80)	Yes
ACTIVITY_DESCRIPTION	VARCHAR2	(4000)
EVENT_TITLE	VARCHAR2	(80)
TIME_ZONE	VARCHAR2	(30)
_DF	CHAR	(34)
CATEGORY_USAGE_ID	NUMBER	(9)
ACTIVITY_ID	NUMBER	(9)	Yes
ACTIVITY_VERSION_ID	NUMBER	(9)	Yes
EVENT_ID	NUMBER	(9)
RCO_ID	NUMBER
OFFERING_ID	NUMBER	(9)

Query Text

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


SELECT CATEGORY_NAME
,      ACT_CAT_INCLUSION_FROM
,      ACT_CAT_INCLUSION_TO
,      PRIMARY_FLAG
,      CATEGORY_TYPE
,      ACTIVITY_TYPE
,      ACTIVITY_NAME
,      ACTIVITY_DESCRIPTION
,      EVENT_TITLE
,      TIME_ZONE
,      _DF
,      CATEGORY_USAGE_ID
,      ACTIVITY_ID
,      ACTIVITY_VERSION_ID
,      EVENT_ID
,      RCO_ID
,      OFFERING_ID
FROM APPS.OTFV_ACTIVITY_CATEGORIES;

Dependencies

[top of page]

APPS.OTFV_ACTIVITY_CATEGORIES references the following:

APPS: HR_BIS - show dependent code; 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_EVENTS; OTA_EVENTS_TL; OTA_OFFERINGS

APPS.OTFV_ACTIVITY_CATEGORIES is not referenced by any database object