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

TABLE: BOM.BOM_OP_ROUTINGS_INTERFACE

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


BOM_OP_ROUTINGS_INTERFACE temporarily stores information about
manufacturing and engineering routings. This table contains user
friendly columns which allow you to easily enter your data as well as
their corresponding foreign keys. Oracle Bills of Material will
derive column values you do not enter, after performing the proper
validation. For example, you enter the ORGANIZATION_CODE and Oracle
Bills of Material will fill in the corresponding ORGANIZATION_ID for
you.
.
Also, if you enter PROCESS_REVISION, Oracle Bills of Material will
insert a record into MTL_RTG_ITEM_REVISIONS for your routing item.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BOM_OP_ROUTINGS_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnTRANSACTION_ID
BOM_OP_ROUTINGS_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnROUTING_SEQUENCE_ID
BOM_OP_ROUTINGS_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCOMMON_ROUTING_SEQUENCE_ID
BOM_OP_ROUTINGS_INTERFACE_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnASSEMBLY_ITEM_ID
ColumnORGANIZATION_ID
ColumnALTERNATE_ROUTING_DESIGNATOR
BOM_OP_ROUTINGS_INTERFACE_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnSET_ID
BOM_OP_ROUTINGS_INTERFACE_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnASSEMBLY_ITEM_NUMBER
ColumnORGANIZATION_CODE
ColumnALTERNATE_ROUTING_DESIGNATOR
BOM_OP_ROUTINGS_INTERFACE_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPROCESS_FLAG
ColumnORGANIZATION_ID
ColumnTRANSACTION_ID
BOM_OP_ROUTINGS_INTERFACE_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
Columns
Name Datatype Length Mandatory Comments
ROUTING_SEQUENCE_ID NUMBER

Routing unique identifier
ASSEMBLY_ITEM_ID NUMBER

Inventory item identifier for manufactured assembly
ORGANIZATION_ID NUMBER

Organization identifier
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate designator code
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ROUTING_TYPE NUMBER

Routing type: 2=Engineering routing 1=Manufacturing routing
COMMON_ASSEMBLY_ITEM_ID NUMBER

Inventory item identifier for common assembly
COMMON_ROUTING_SEQUENCE_ID NUMBER

Routing unique identifier of common routing
ROUTING_COMMENT VARCHAR2 (240)
Specific comment about routing
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Destination subinventory for assembly
COMPLETION_LOCATOR_ID NUMBER

Destination location for assembly
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
DEMAND_SOURCE_LINE VARCHAR2 (30)
Demand source line - used for ATO
SET_ID VARCHAR2 (10)
Set identifier - used for ATO
PROCESS_REVISION VARCHAR2 (3)
Routing revision
DEMAND_SOURCE_TYPE NUMBER

Demand source type - used for ATO
DEMAND_SOURCE_HEADER_ID NUMBER

Demand source header identifier - used for ATO
ORGANIZATION_CODE VARCHAR2 (3)
Abbreviation of organization name
ASSEMBLY_ITEM_NUMBER VARCHAR2 (240)
Concatenated item segments
COMMON_ITEM_NUMBER VARCHAR2 (240)
Concatenated item segments of the common routing
LOCATION_NAME VARCHAR2 (81)
Concatenated location segments
TRANSACTION_ID NUMBER

Row identifier
PROCESS_FLAG NUMBER

Row status
TRANSACTION_TYPE VARCHAR2 (10)
Insert, Update or Delete Routing
LINE_ID NUMBER

Unique identifier from WIP Lines used in Flow Manufacturing
LINE_CODE VARCHAR2 (10)
Name of WIP Line
MIXED_MODEL_MAP_FLAG NUMBER

Use this routing in mixed model map calculation
PRIORITY NUMBER

For information only
CFM_ROUTING_FLAG NUMBER

Continous flow or traditional routing
TOTAL_PRODUCT_CYCLE_TIME NUMBER

Total time that an assembly takes along the primary path in the operation network calculated by Flow Manufacturing
CTP_FLAG NUMBER

Flag indicating capacity must be checked when item is ordered
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
Original system reference
SERIALIZATION_START_OP NUMBER

Serialization Starting Operation Sequence Number for standard routings
DELETE_GROUP_NAME VARCHAR2 (10)
Delete group name
DG_DESCRIPTION VARCHAR2 (240)
Delete group description
BATCH_ID NUMBER

BATCH_ID
Query Text

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


SELECT ROUTING_SEQUENCE_ID
,      ASSEMBLY_ITEM_ID
,      ORGANIZATION_ID
,      ALTERNATE_ROUTING_DESIGNATOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ROUTING_TYPE
,      COMMON_ASSEMBLY_ITEM_ID
,      COMMON_ROUTING_SEQUENCE_ID
,      ROUTING_COMMENT
,      COMPLETION_SUBINVENTORY
,      COMPLETION_LOCATOR_ID
,      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
,      DEMAND_SOURCE_LINE
,      SET_ID
,      PROCESS_REVISION
,      DEMAND_SOURCE_TYPE
,      DEMAND_SOURCE_HEADER_ID
,      ORGANIZATION_CODE
,      ASSEMBLY_ITEM_NUMBER
,      COMMON_ITEM_NUMBER
,      LOCATION_NAME
,      TRANSACTION_ID
,      PROCESS_FLAG
,      TRANSACTION_TYPE
,      LINE_ID
,      LINE_CODE
,      MIXED_MODEL_MAP_FLAG
,      PRIORITY
,      CFM_ROUTING_FLAG
,      TOTAL_PRODUCT_CYCLE_TIME
,      CTP_FLAG
,      ORIGINAL_SYSTEM_REFERENCE
,      SERIALIZATION_START_OP
,      DELETE_GROUP_NAME
,      DG_DESCRIPTION
,      BATCH_ID
FROM BOM.BOM_OP_ROUTINGS_INTERFACE;

Dependencies

[top of page]

BOM.BOM_OP_ROUTINGS_INTERFACE does not reference any database object

BOM.BOM_OP_ROUTINGS_INTERFACE is referenced by following:

SchemaAPPS
SynonymBOM_OP_ROUTINGS_INTERFACE