[Home] [Help] [Dependency Information]
Object Name: | EAM_NEXT_OPERATIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EAM.EAM_NEXT_OPERATIONS_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
View provides a list of Next operations for a specific operation in a work order depends upon the Dependency Definition defined in WIP_OPERATION_NETWORKS
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OPERATION_SEQ_NUM | NUMBER | Yes | Next operation | |
DESCRIPTION | VARCHAR2 | (240) | Description | |
DEPARTMENT_CODE | VARCHAR2 | (10) | Yes | Assigned department |
OPERATION_COMPLETED | VARCHAR2 | (80) | Yes | Completion status(yes/No) |
SCHEDULE_START_DATE | DATE | Yes | Scheduled start date | |
SCHEDULE_END_DATE | DATE | Yes | Scheduled end date | |
SCHEDULE_DURATION | NUMBER | Scheduled duration | ||
ACTUAL_START_DATE | DATE | Actual start date | ||
ACTUAL_END_DATE | DATE | Actual end date | ||
WIP_ENTITY_ID | NUMBER | Yes | Work order identifier | |
PRIOR_OPERATION | NUMBER | Yes | Current operation |
Cut, paste (and edit) the following text to query this object:
SELECT OPERATION_SEQ_NUM
, DESCRIPTION
, DEPARTMENT_CODE
, OPERATION_COMPLETED
, SCHEDULE_START_DATE
, SCHEDULE_END_DATE
, SCHEDULE_DURATION
, ACTUAL_START_DATE
, ACTUAL_END_DATE
, WIP_ENTITY_ID
, PRIOR_OPERATION
FROM APPS.EAM_NEXT_OPERATIONS_V;
|
|
|