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_PROGRAMS_V

Object Details

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

View Type

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

View for preventive maintenance programs.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ID1	NUMBER		Yes	Primary Key for AHL_MR_HEADERS_B, unique identifier of a MR
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

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
FROM APPS.OKX_PM_PROGRAMS_V;

Dependencies

[top of page]

APPS.OKX_PM_PROGRAMS_V references the following:

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

APPS.OKX_PM_PROGRAMS_V is referenced by following:

APPS: OKS_PM_PROGRAMS_PVT - show dependent code