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

VIEW: APPS.EAM_PRIOR_OPERATIONS_V

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


View provides a list of prior operations for a specific operation in a work order. This depends upon the dependency definition in WIP_OPERATION_NETWORKS


[View Source]

Columns
Name Datatype Length Mandatory Comments
OPERATION_SEQ_NUM NUMBER
Yes Prior 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 Schedule start date
SCHEDULE_END_DATE DATE
Yes Schedule end date
SCHEDULE_DURATION NUMBER

Schedule duration
ACTUAL_START_DATE DATE

Actual start date
ACTUAL_END_DATE DATE

Actual end date
WIP_ENTITY_ID NUMBER
Yes Work order identifier
NEXT_OPERATION NUMBER
Yes Current operation
Query Text

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
,      NEXT_OPERATION
FROM APPS.EAM_PRIOR_OPERATIONS_V;

Dependencies

[top of page]

APPS.EAM_PRIOR_OPERATIONS_V references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
SynonymEAM_OP_COMPLETION_TXNS
SynonymFND_LOOKUP_VALUES
SynonymWIP_OPERATIONS
SynonymWIP_OPERATION_NETWORKS
APPS.EAM_PRIOR_OPERATIONS_V is referenced by following:

SchemaAPPS
Package BodyEAM_OPERATIONS_JSP - show dependent code