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

VIEW: APPS.ENG_REVISED_OPERATIONS_V

Object Details
Object Name: ENG_REVISED_OPERATIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewENG.ENG_REVISED_OPERATIONS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Id
OPERATION_SEQUENCE_ID NUMBER

Operation Sequence Id
ROUTING_SEQUENCE_ID NUMBER

Routing Sequence Id
OPERATION_SEQ_NUM NUMBER

Operation Seq Num
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATED_BY NUMBER

Last Updated By
CREATION_DATE DATE

Creation Date
CREATED_BY NUMBER

Created By
LAST_UPDATE_LOGIN NUMBER

Last Update Login
STANDARD_OPERATION_CODE VARCHAR2 (4)
Standard Operation Code
STANDARD_OPERATION_ID NUMBER

Standard Operation Id
DEPARTMENT_CODE VARCHAR2 (10)
Department Code
DEPARTMENT_ID NUMBER

Department Id
LOCATION_ID NUMBER

Location Id
OPERATION_LEAD_TIME_PERCENT NUMBER

Operation Lead Time Percent
MINIMUM_TRANSFER_QUANTITY NUMBER

Minimum Transfer Quantity
COUNT_POINT_TYPE NUMBER

Count Point Type
OPERATION_DESCRIPTION VARCHAR2 (240)
Operation Description
EFFECTIVITY_DATE DATE

Effectivity Date
DISABLE_DATE DATE

Disable Date
BACKFLUSH_FLAG NUMBER

Backflush Flag
OPTION_DEPENDENT_FLAG NUMBER

Option Dependent Flag
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category
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
COUNT_POINT_FLAG NUMBER

Count Point Flag
AUTOCHARGE_FLAG NUMBER

Autocharge Flag
OPERATION_TYPE NUMBER

Operation Type
REFERENCE_FLAG NUMBER

Reference Flag
PROCESS_OP_SEQ_ID NUMBER

Process Op Seq Id
PROCESS_SEQ_NUM NUMBER

Process Seq Num
PROCESS_CODE VARCHAR2 (4)
Process Code
LINE_OP_SEQ_ID NUMBER

Line Op Seq Id
LINE_OP_SEQ_NUM NUMBER

Line Op Seq Num
LINE_OP_CODE VARCHAR2 (4)
Line Op Code
YIELD NUMBER

Yield
CUMULATIVE_YIELD NUMBER

Cumulative Field
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 Planning 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)
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 ROW_ID
,      OPERATION_SEQUENCE_ID
,      ROUTING_SEQUENCE_ID
,      OPERATION_SEQ_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      STANDARD_OPERATION_CODE
,      STANDARD_OPERATION_ID
,      DEPARTMENT_CODE
,      DEPARTMENT_ID
,      LOCATION_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
,      COUNT_POINT_FLAG
,      AUTOCHARGE_FLAG
,      OPERATION_TYPE
,      REFERENCE_FLAG
,      PROCESS_OP_SEQ_ID
,      PROCESS_SEQ_NUM
,      PROCESS_CODE
,      LINE_OP_SEQ_ID
,      LINE_OP_SEQ_NUM
,      LINE_OP_CODE
,      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 APPS.ENG_REVISED_OPERATIONS_V;

Dependencies

[top of page]

APPS.ENG_REVISED_OPERATIONS_V references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
SynonymBOM_OPERATIONAL_ROUTINGS
SynonymBOM_OPERATION_SEQUENCES
SynonymBOM_STANDARD_OPERATIONS
SynonymENG_REVISED_ITEMS
SynonymENG_REVISED_OPERATIONS

APPS.ENG_REVISED_OPERATIONS_V is not referenced by any database object