DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.EAM_WORKORDER_DOWNTIME_V

Object Details
Object Name: EAM_WORKORDER_DOWNTIME_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEAM.EAM_WORKORDER_DOWNTIME_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
MAINT_ORG_ID NUMBER

Organization Identifier
PROD_ORG_ID NUMBER

Prod Organization Identifier - Used by EAM only
WIP_ENTITY_ID NUMBER

Work Order Identifier
WORKORDER_NUMBER VARCHAR2 (240)
Work Order Name
ASSET_GROUP_ID NUMBER

Asset Group Identifer
ASSET_NUMBER VARCHAR2 (30)
Asset Number
OP_SEQ NUMBER

Operation sequence number within a routing
FROM_DATE DATE

From Date
TO_DATE DATE

To date
EQUIPMENT_ITEM_ID NUMBER

Equipment Item Identifier - Used by EAM only
EQP_SERIAL_NUMBER VARCHAR2 (30)
Equipment serial number -- Used by EAM
SHUTDOWN_TYPE VARCHAR2 (30)
Shutdown Type
STATUS_TYPE NUMBER

Status of Work Order
FIRM_FLAG NUMBER

Control for MRP rescheduling
Query Text

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


SELECT MAINT_ORG_ID
,      PROD_ORG_ID
,      WIP_ENTITY_ID
,      WORKORDER_NUMBER
,      ASSET_GROUP_ID
,      ASSET_NUMBER
,      OP_SEQ
,      FROM_DATE
,      TO_DATE
,      EQUIPMENT_ITEM_ID
,      EQP_SERIAL_NUMBER
,      SHUTDOWN_TYPE
,      STATUS_TYPE
,      FIRM_FLAG
FROM APPS.EAM_WORKORDER_DOWNTIME_V;

Dependencies

[top of page]

APPS.EAM_WORKORDER_DOWNTIME_V references the following:

SchemaAPPS
SynonymCSI_ITEM_INSTANCES
SynonymMTL_SERIAL_NUMBERS
SynonymWIP_DISCRETE_JOBS
SynonymWIP_ENTITIES
SynonymWIP_OPERATIONS
APPS.EAM_WORKORDER_DOWNTIME_V is referenced by following:

SchemaAPPS
Package BodyGMP_EAM_DOWNTIME_PKG - show dependent code