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

VIEW: ENG.ENG_REVISED_OPERATIONS#

Object Details
Object Name: ENG_REVISED_OPERATIONS#
Object Type: VIEW
Owner: ENG
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
OPERATION_SEQUENCE_ID NUMBER
Yes
ROUTING_SEQUENCE_ID NUMBER
Yes
OPERATION_SEQ_NUM NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

STANDARD_OPERATION_ID NUMBER

DEPARTMENT_ID NUMBER
Yes
OPERATION_LEAD_TIME_PERCENT NUMBER

MINIMUM_TRANSFER_QUANTITY NUMBER

COUNT_POINT_TYPE NUMBER
Yes
OPERATION_DESCRIPTION VARCHAR2 (240)
EFFECTIVITY_DATE DATE
Yes
DISABLE_DATE DATE

BACKFLUSH_FLAG NUMBER
Yes
OPTION_DEPENDENT_FLAG NUMBER
Yes
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

OPERATION_TYPE NUMBER

REFERENCE_FLAG NUMBER

PROCESS_OP_SEQ_ID NUMBER

LINE_OP_SEQ_ID NUMBER

YIELD NUMBER

CUMULATIVE_YIELD NUMBER

REVERSE_CUMULATIVE_YIELD NUMBER

LABOR_TIME_CALC NUMBER

MACHINE_TIME_CALC NUMBER

TOTAL_TIME_CALC NUMBER

LABOR_TIME_USER NUMBER

MACHINE_TIME_USER NUMBER

TOTAL_TIME_USER NUMBER

NET_PLANNING_PERCENT NUMBER

X_COORDINATE NUMBER

Y_COORDINATE NUMBER

INCLUDE_IN_ROLLUP NUMBER

OPERATION_YIELD_ENABLED NUMBER

CHANGE_NOTICE VARCHAR2 (10) Yes
IMPLEMENTATION_DATE DATE

OLD_OPERATION_SEQUENCE_ID NUMBER

ACD_TYPE NUMBER

REVISED_ITEM_SEQUENCE_ID NUMBER

CANCELLATION_DATE DATE

CANCEL_COMMENTS VARCHAR2 (240)
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
ECO_FOR_PRODUCTION NUMBER

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# references the following:

SchemaENG
TableENG_REVISED_OPERATIONS
ENG.ENG_REVISED_OPERATIONS# is referenced by following:

SchemaAPPS
SynonymENG_REVISED_OPERATIONS