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

Object Details

Object Name:	OKX_PM_ACTIVITIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKX.OKX_PM_ACTIVITIES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view is the source for all the activities associated to a preventive maintenance program.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ID1	NUMBER		Yes	Id1
ID2	CHAR	(1)		Id2
NAME	VARCHAR2	(80)	Yes	Name
DESCRIPTION	VARCHAR2	(2000)		Description
TYPE_CODE	VARCHAR2	(30)		Type Code
TYPE	VARCHAR2	(80)		Type
EFFECTIVE_FROM	DATE		Yes	Effective From
EFFECTIVE_TO	DATE			Effective To
MR_STATUS_CODE	VARCHAR2	(30)	Yes	MR Status Code
STATUS	VARCHAR2	(80)	Yes	Status
DOWN_TIME	NUMBER			Down Time
UOM	VARCHAR2	(80)		Uom
PROGRAM_ID	NUMBER		Yes	Program Id

Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      TYPE_CODE
,      TYPE
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      MR_STATUS_CODE
,      STATUS
,      DOWN_TIME
,      UOM
,      PROGRAM_ID
FROM APPS.OKX_PM_ACTIVITIES_V;

Dependencies

[top of page]

APPS.OKX_PM_ACTIVITIES_V references the following:

APPS: AHL_MR_HEADERS_B; AHL_MR_HEADERS_TL; AHL_MR_RELATIONSHIPS; FND_LOOKUP_VALUES; FND_PROFILE - show dependent code

APPS.OKX_PM_ACTIVITIES_V is referenced by following:

APPS: OKS_PM_PROGRAMS_PVT - show dependent code; OKS_PM_PROGRAMS_PVT - show dependent code