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

TABLE: BOM.BOM_OP_NETWORKS_INTERFACE

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


BOM_OP_NETWORKS_INTERFACE temporarily stores information about
operation networks that you may require to complete operations on flow 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, you can enter ROUTING_SEQUENCE_ID, FROM_OP_SEQ_NUMBER, and
EFFECTIVITY_DATE instead of FROM_OP_SEQ_ID. Oracle Bills of
Material will fill in the corresponding FROM_OP_SEQ_ID.
.
In addition, you can enter ASSEMBLY_ITEM_ID, ORGANIZATION_ID and
ALTERNATE_ROUTING_DESIGNATOR instead of ROUTING_SEQUENCE_ID. Oracle
Bills of Material will fill in the corresponding ROUTING_SEQUENCE_ID.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BOM_OP_NETWORKS_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
Columns
Name Datatype Length Mandatory Comments
FROM_OP_SEQ_ID NUMBER

From operation network unique identifier
TO_OP_SEQ_ID NUMBER

To operation network unique identifier
TRANSITION_TYPE NUMBER

Primary, Alternate or Rework connection
PLANNING_PCT NUMBER

Planning percentage
OPERATION_TYPE NUMBER

Process, Line Operation or Event
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
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
FROM_X_COORDINATE NUMBER

From X coordinate of Operation
TO_X_COORDINATE NUMBER

To X coordinate of Operation
FROM_Y_COORDINATE NUMBER

From Y coordinate of Operation
TO_Y_COORDINATE NUMBER

To Y coordinate of Operation
FROM_OP_SEQ_NUMBER NUMBER

From Routing Operation Sequence Number
TO_OP_SEQ_NUMBER NUMBER

To Routing Operation Sequence Number
FROM_START_EFFECTIVE_DATE DATE

Effectivity Date for from operation
TO_START_EFFECTIVE_DATE DATE

Effectivity Date for to operation
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
NEW_FROM_OP_SEQ_NUMBER NUMBER

New From Operation Sequence Number
NEW_TO_OP_SEQ_NUMBER NUMBER

New To Operation Sequence Number
NEW_FROM_START_EFFECTIVE_DATE DATE

New Effectivity Date for from operation
NEW_TO_START_EFFECTIVE_DATE DATE

New Effectivity Date for from operation
ASSEMBLY_ITEM_ID NUMBER

Inventory item identifier of manufactured assembly
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate designator code
ORGANIZATION_ID NUMBER

Organization identifier
ROUTING_SEQUENCE_ID NUMBER

Routing unique identifier
ORGANIZATION_CODE VARCHAR2 (3)
Abbreviation of organization name
ASSEMBLY_ITEM_NUMBER VARCHAR2 (240)
Concatenated item segments
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
Original system reference
TRANSACTION_ID NUMBER

Row identifier
PROCESS_FLAG NUMBER

Row status
TRANSACTION_TYPE VARCHAR2 (10)
Create, Update, or Delete
REQUEST_ID NUMBER

Request id
BATCH_ID NUMBER

Batch Id
Query Text

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


SELECT FROM_OP_SEQ_ID
,      TO_OP_SEQ_ID
,      TRANSITION_TYPE
,      PLANNING_PCT
,      OPERATION_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      FROM_X_COORDINATE
,      TO_X_COORDINATE
,      FROM_Y_COORDINATE
,      TO_Y_COORDINATE
,      FROM_OP_SEQ_NUMBER
,      TO_OP_SEQ_NUMBER
,      FROM_START_EFFECTIVE_DATE
,      TO_START_EFFECTIVE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      NEW_FROM_OP_SEQ_NUMBER
,      NEW_TO_OP_SEQ_NUMBER
,      NEW_FROM_START_EFFECTIVE_DATE
,      NEW_TO_START_EFFECTIVE_DATE
,      ASSEMBLY_ITEM_ID
,      ALTERNATE_ROUTING_DESIGNATOR
,      ORGANIZATION_ID
,      ROUTING_SEQUENCE_ID
,      ORGANIZATION_CODE
,      ASSEMBLY_ITEM_NUMBER
,      ORIGINAL_SYSTEM_REFERENCE
,      TRANSACTION_ID
,      PROCESS_FLAG
,      TRANSACTION_TYPE
,      REQUEST_ID
,      BATCH_ID
FROM BOM.BOM_OP_NETWORKS_INTERFACE;

Dependencies

[top of page]

BOM.BOM_OP_NETWORKS_INTERFACE does not reference any database object

BOM.BOM_OP_NETWORKS_INTERFACE is referenced by following:

SchemaAPPS
SynonymBOM_OP_NETWORKS_INTERFACE