[Home] [Help] [Dependency Information]
Object Name: | EAM_WORKORDER_DOWNTIME_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EAM.EAM_WORKORDER_DOWNTIME_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
|
|
|