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: ViewOKX.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:

SchemaAPPS
SynonymAHL_MR_HEADERS_B
SynonymAHL_MR_HEADERS_TL
SynonymFND_LOOKUP_VALUES
PL/SQL PackageFND_PROFILE - show dependent code
APPS.OKX_PM_PROGRAMS_V is referenced by following:

SchemaAPPS
Package BodyOKS_PM_PROGRAMS_PVT - show dependent code