[Home] [Help] [Dependency Information]
Object Name: | WIP_EAM_WO_SRV_ASSOC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WIP.WIP_EAM_WO_SRV_ASSOC_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORK_ORDER_NAME | VARCHAR2 | (240) | WIP job or repetitive assembly name or flow schedule reference code | |
STATUS | VARCHAR2 | (80) | Lookup meaning | |
DEPARTMENT_CODE | VARCHAR2 | (10) | Department code | |
ASSET_GROUP | VARCHAR2 | (40) | ||
ASSET_NUMBER | VARCHAR2 | (30) | ||
ACTIVITY | VARCHAR2 | (40) | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | ||
PRIORITY | VARCHAR2 | (80) | ||
FIRM_FLAG | VARCHAR2 | (1) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
SERVICE_REQUEST_ID | NUMBER | |||
REQUESTED_START_DATE | DATE | |||
DUE_DATE | DATE | |||
SCHEDULED_START_DATE | DATE | |||
SCHEDULED_COMPLETION_DATE | DATE | |||
DURATION | NUMBER | |||
ACTUAL_START_DATE | DATE | |||
ACTUAL_END_DATE | DATE | |||
DATE_COMPLETED | DATE | |||
DEPARTMENT_ID | NUMBER | |||
WIP_ENTITY_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
PRIORITY_ID | NUMBER | |||
STATUS_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
ACTIVITY_ID | NUMBER | |||
DATE_CLOSED | DATE | |||
ASSET_TYPE | VARCHAR2 | (80) | ||
DATE_RELEASED | DATE | Released Date |
Cut, paste (and edit) the following text to query this object:
SELECT WORK_ORDER_NAME
, STATUS
, DEPARTMENT_CODE
, ASSET_GROUP
, ASSET_NUMBER
, ACTIVITY
, ORGANIZATION_CODE
, PRIORITY
, FIRM_FLAG
, DESCRIPTION
, SERVICE_REQUEST_ID
, REQUESTED_START_DATE
, DUE_DATE
, SCHEDULED_START_DATE
, SCHEDULED_COMPLETION_DATE
, DURATION
, ACTUAL_START_DATE
, ACTUAL_END_DATE
, DATE_COMPLETED
, DEPARTMENT_ID
, WIP_ENTITY_ID
, ORGANIZATION_ID
, PRIORITY_ID
, STATUS_ID
, INVENTORY_ITEM_ID
, ACTIVITY_ID
, DATE_CLOSED
, ASSET_TYPE
, DATE_RELEASED
FROM APPS.WIP_EAM_WO_SRV_ASSOC_V;
APPS.WIP_EAM_WO_SRV_ASSOC_V is not referenced by any database object
|
|
|