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

TABLE: ENG.ENG_REVISED_OPERATIONS

Object Details
Object Name: ENG_REVISED_OPERATIONS
Object Type: TABLE
Owner: ENG
FND Design Data: TableENG.ENG_REVISED_OPERATIONS
Subobject Name:
Status: VALID


ENG_REVISED_OPERATIONS stores revised operation information.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 5
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ENG_REVISED_OPERATIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnREVISED_ITEM_SEQUENCE_ID
ENG_REVISED_OPERATIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCHANGE_NOTICE
ENG_REVISED_OPERATIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnSTANDARD_OPERATION_ID
ENG_REVISED_OPERATIONS_U2 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnOPERATION_SEQUENCE_ID
ColumnROUTING_SEQUENCE_ID
ColumnDEPARTMENT_ID
ColumnOPERATION_TYPE
Columns
Name Datatype Length Mandatory Comments
OPERATION_SEQUENCE_ID NUMBER
Yes Operation Sequence Id
ROUTING_SEQUENCE_ID NUMBER
Yes Routing Sequence Id
OPERATION_SEQ_NUM NUMBER
Yes Operation Seq Num
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATED_BY NUMBER
Yes Last Updated By
CREATION_DATE DATE
Yes Creation Date
CREATED_BY NUMBER
Yes Created By
LAST_UPDATE_LOGIN NUMBER

Last Update Login
STANDARD_OPERATION_ID NUMBER

Standard Operation Id
DEPARTMENT_ID NUMBER
Yes Department Id
OPERATION_LEAD_TIME_PERCENT NUMBER

Operation Lead Time Percent
MINIMUM_TRANSFER_QUANTITY NUMBER

Minimum Transfer Quantity
COUNT_POINT_TYPE NUMBER
Yes Count Point Type
OPERATION_DESCRIPTION VARCHAR2 (240)
Operation Description
EFFECTIVITY_DATE DATE
Yes Effectivity Date
DISABLE_DATE DATE

Disable Date
BACKFLUSH_FLAG NUMBER
Yes Backflush Flag
OPTION_DEPENDENT_FLAG NUMBER
Yes Option Dependent Flag
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER

Request Id
PROGRAM_APPLICATION_ID NUMBER

Program Application Id
PROGRAM_ID NUMBER

Program Id
PROGRAM_UPDATE_DATE DATE

Program Update Date
OPERATION_TYPE NUMBER

Operation Type
REFERENCE_FLAG NUMBER

Reference Flag
PROCESS_OP_SEQ_ID NUMBER

Process Op Seq Id
LINE_OP_SEQ_ID NUMBER

Line Op Seq Id
YIELD NUMBER

Yield
CUMULATIVE_YIELD NUMBER

Cumulative Yield
REVERSE_CUMULATIVE_YIELD NUMBER

Reverse Cumulative Yield
LABOR_TIME_CALC NUMBER

Labor Time Calc
MACHINE_TIME_CALC NUMBER

Machine Time Calc
TOTAL_TIME_CALC NUMBER

Total Time Calc
LABOR_TIME_USER NUMBER

Labor Time User
MACHINE_TIME_USER NUMBER

Machine Time User
TOTAL_TIME_USER NUMBER

Total Time User
NET_PLANNING_PERCENT NUMBER

Net Palnning Percent
X_COORDINATE NUMBER

X Coordinate
Y_COORDINATE NUMBER

Y Coordinate
INCLUDE_IN_ROLLUP NUMBER

Include In Rollup
OPERATION_YIELD_ENABLED NUMBER

Operation Yield Enable
CHANGE_NOTICE VARCHAR2 (10) Yes Change Notice
IMPLEMENTATION_DATE DATE

Implementation Date
OLD_OPERATION_SEQUENCE_ID NUMBER

Old Operation Sequence Id
ACD_TYPE NUMBER

Acd Type
REVISED_ITEM_SEQUENCE_ID NUMBER

Revised Item Sequence Id
CANCELLATION_DATE DATE

Cancellation Date
CANCEL_COMMENTS VARCHAR2 (240)
Cancel Comments
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
Original System Reference
ECO_FOR_PRODUCTION NUMBER

WIP Only ECO
Query Text

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


SELECT OPERATION_SEQUENCE_ID
,      ROUTING_SEQUENCE_ID
,      OPERATION_SEQ_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      STANDARD_OPERATION_ID
,      DEPARTMENT_ID
,      OPERATION_LEAD_TIME_PERCENT
,      MINIMUM_TRANSFER_QUANTITY
,      COUNT_POINT_TYPE
,      OPERATION_DESCRIPTION
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      BACKFLUSH_FLAG
,      OPTION_DEPENDENT_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OPERATION_TYPE
,      REFERENCE_FLAG
,      PROCESS_OP_SEQ_ID
,      LINE_OP_SEQ_ID
,      YIELD
,      CUMULATIVE_YIELD
,      REVERSE_CUMULATIVE_YIELD
,      LABOR_TIME_CALC
,      MACHINE_TIME_CALC
,      TOTAL_TIME_CALC
,      LABOR_TIME_USER
,      MACHINE_TIME_USER
,      TOTAL_TIME_USER
,      NET_PLANNING_PERCENT
,      X_COORDINATE
,      Y_COORDINATE
,      INCLUDE_IN_ROLLUP
,      OPERATION_YIELD_ENABLED
,      CHANGE_NOTICE
,      IMPLEMENTATION_DATE
,      OLD_OPERATION_SEQUENCE_ID
,      ACD_TYPE
,      REVISED_ITEM_SEQUENCE_ID
,      CANCELLATION_DATE
,      CANCEL_COMMENTS
,      ORIGINAL_SYSTEM_REFERENCE
,      ECO_FOR_PRODUCTION
FROM ENG.ENG_REVISED_OPERATIONS;

Dependencies

[top of page]

ENG.ENG_REVISED_OPERATIONS does not reference any database object

ENG.ENG_REVISED_OPERATIONS is referenced by following:

SchemaENG
ViewENG_REVISED_OPERATIONS#