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

TABLE: BOM.BOM_OPERATION_SEQUENCES

Object Details
Object Name: BOM_OPERATION_SEQUENCES
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.BOM_OPERATION_SEQUENCES
Subobject Name:
Status: VALID


BOM_OPERATION_SEQUENCES stores information about routing operations.
You may define multiple operations for a routing. You must specify
the department in which every operation will occur.
.
Oracle Bills of Material stores the STANDARD_OPERATION_ID if you use
a standard operation to define your operation.
.
You cannot have overlapping effective dates for the same operation.
The Define Routing window will prevent you from doing that. For
example, you cannot define operations as follows:
.
===
Op Effective Disable
Seq Date Date
--- --------- ---------
10 10-SEP-93 10-DEC-93
10 20-OCT-93
.
===


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BOM_OPERATION_SEQUENCES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOPERATION_SEQUENCE_ID
BOM_OPERATION_SEQUENCES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnROUTING_SEQUENCE_ID
ColumnOPERATION_TYPE
ColumnOPERATION_SEQ_NUM
ColumnEFFECTIVITY_DATE
BOM_OPERATION_SEQUENCES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESS_OP_SEQ_ID
BOM_OPERATION_SEQUENCES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_OP_SEQ_ID
BOM_OPERATION_SEQUENCES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHANGE_NOTICE
BOM_OPERATION_SEQUENCES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMODEL_OP_SEQ_ID
BOM_OPERATION_SEQUENCES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONFIG_ROUTING_ID
BOM_OPERATION_SEQUENCES_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTANDARD_OPERATION_ID
ColumnREFERENCE_FLAG
Columns
Name Datatype Length Mandatory Comments
OPERATION_SEQUENCE_ID NUMBER
Yes Routing operation unique identifier
ROUTING_SEQUENCE_ID NUMBER
Yes Routing unique identifier
OPERATION_SEQ_NUM NUMBER
Yes Operation sequence number
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
STANDARD_OPERATION_ID NUMBER

Standard operation unique identifier
DEPARTMENT_ID NUMBER
Yes Department unique identifier
OPERATION_LEAD_TIME_PERCENT NUMBER

Indicates the amount of overlap its lead time has with the parent's lead time
MINIMUM_TRANSFER_QUANTITY NUMBER

Minimum operation transfer quantity
COUNT_POINT_TYPE NUMBER
Yes Count point
OPERATION_DESCRIPTION VARCHAR2 (240)
Description of operation
EFFECTIVITY_DATE DATE
Yes Date operation is effective
DISABLE_DATE DATE

Date operation is no longer effective - effectivity lasts until the end of the disable date
BACKFLUSH_FLAG NUMBER
Yes Indicates whether operation requires backflushing
OPTION_DEPENDENT_FLAG NUMBER
Yes Indicates whether to use this operation in all configuration routings, even if no components of the configuration are used in this operation
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

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
OPERATION_TYPE NUMBER

Process, Line Operation or Event
REFERENCE_FLAG NUMBER

If the Standard Operation is referenced or copied then the operation can not be updated.
PROCESS_OP_SEQ_ID NUMBER

Operation sequence identifier of parent process (applies only to events)
LINE_OP_SEQ_ID NUMBER

Operation sequence identifier of the parent line operation - only applies to events
YIELD NUMBER

Process yield at this operation
CUMULATIVE_YIELD NUMBER

Cumulative process yield from begining of routing to this operation
REVERSE_CUMULATIVE_YIELD NUMBER

Cumulative process yield from end of routing to comparable operation
LABOR_TIME_CALC NUMBER

System calculated run time attributable to labor
MACHINE_TIME_CALC NUMBER

System calculated run time attributable to machines
TOTAL_TIME_CALC NUMBER

System calculated run time attributable to both labor and machines
LABOR_TIME_USER NUMBER

User calculated run time attributable to labor
MACHINE_TIME_USER NUMBER

User calculated run time attributable to machines
TOTAL_TIME_USER NUMBER

User calculated run time attributable to both labor and machines
NET_PLANNING_PERCENT NUMBER

Cumulative planning percents derived from the operation network
X_COORDINATE NUMBER

X coordinate of the operation
Y_COORDINATE NUMBER

Y coordinate of the operation
INCLUDE_IN_ROLLUP NUMBER

Indicates whether operation yield is to be considered in cost rollup
OPERATION_YIELD_ENABLED NUMBER

Indicates whether operation yield is to be considered during costing.
OLD_OPERATION_SEQUENCE_ID NUMBER

Old Operation Sequence Id
ACD_TYPE NUMBER

Acd Type
REVISED_ITEM_SEQUENCE_ID NUMBER

Revised Item Sequence Id
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
Original System Reference
CHANGE_NOTICE VARCHAR2 (10)
Engineering change notice code (not currently used)
IMPLEMENTATION_DATE DATE

Date on which engineering change will be implemented (no longer used)
ECO_FOR_PRODUCTION NUMBER

Indicates if this operation on an Engineering Change Order is only for WIP jobs
SHUTDOWN_TYPE VARCHAR2 (30)
Shutdown type
ACTUAL_IPK NUMBER

Actual In-Process Kanbans
CRITICAL_TO_QUALITY VARCHAR2 (1)
Critical to quality
VALUE_ADDED VARCHAR2 (1)
Value Added
MACHINE_PROCESS_EFFICIENCY NUMBER

Used by Flow manufacturing for Process Efficiency calculations
LABOR_PROCESS_EFFICIENCY NUMBER

Used by Flow manufacturing for Process Efficiency calculations
TOTAL_PROCESS_EFFICIENCY NUMBER

Used by Flow manufacturing for Process Efficiency calculations
LONG_DESCRIPTION VARCHAR2 (4000)
Used by EAM routings
CONFIG_ROUTING_ID NUMBER

this columns denotes the corresponding model routing that this configuration routing operation is derrived from
MODEL_OP_SEQ_ID NUMBER

this columns denotes the corresponding model routing operation that this configuration routing operation is derrived from
LOWEST_ACCEPTABLE_YIELD NUMBER

Lowest Acceptable Yield
USE_ORG_SETTINGS NUMBER

Use Organization Settings
QUEUE_MANDATORY_FLAG NUMBER

Flag to set Queue intra-operation step mandatory.
RUN_MANDATORY_FLAG NUMBER

Run mandatory flag
TO_MOVE_MANDATORY_FLAG NUMBER

Move mandatory flag
SHOW_NEXT_OP_BY_DEFAULT NUMBER

Show next operation by default.
SHOW_SCRAP_CODE NUMBER

Show Scrap Code
SHOW_LOT_ATTRIB NUMBER

Show lot attributes.
TRACK_MULTIPLE_RES_USAGE_DATES NUMBER

Track Multiple Resource Usage Dates
CHECK_SKILL NUMBER

CHECK SKILL
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
,      OLD_OPERATION_SEQUENCE_ID
,      ACD_TYPE
,      REVISED_ITEM_SEQUENCE_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      CHANGE_NOTICE
,      IMPLEMENTATION_DATE
,      ECO_FOR_PRODUCTION
,      SHUTDOWN_TYPE
,      ACTUAL_IPK
,      CRITICAL_TO_QUALITY
,      VALUE_ADDED
,      MACHINE_PROCESS_EFFICIENCY
,      LABOR_PROCESS_EFFICIENCY
,      TOTAL_PROCESS_EFFICIENCY
,      LONG_DESCRIPTION
,      CONFIG_ROUTING_ID
,      MODEL_OP_SEQ_ID
,      LOWEST_ACCEPTABLE_YIELD
,      USE_ORG_SETTINGS
,      QUEUE_MANDATORY_FLAG
,      RUN_MANDATORY_FLAG
,      TO_MOVE_MANDATORY_FLAG
,      SHOW_NEXT_OP_BY_DEFAULT
,      SHOW_SCRAP_CODE
,      SHOW_LOT_ATTRIB
,      TRACK_MULTIPLE_RES_USAGE_DATES
,      CHECK_SKILL
FROM BOM.BOM_OPERATION_SEQUENCES;

Dependencies

[top of page]

BOM.BOM_OPERATION_SEQUENCES does not reference any database object

BOM.BOM_OPERATION_SEQUENCES is referenced by following:

SchemaAPPS
SynonymBOM_OPERATION_SEQUENCES
Materialized ViewENI_DBI_MFG_STEPS_JOIN_MV