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

TABLE: MSC.MSC_OPERATION_NETWORKS

Object Details
Object Name: MSC_OPERATION_NETWORKS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_OPERATION_NETWORKS
Subobject Name:
Status: VALID


This table is a child table of msc_operations. Describes the network structure of operations of a network routing.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_OPERATION_NETWORKS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnROUTING_SEQUENCE_ID
ColumnFROM_OP_SEQ_ID
ColumnTO_OP_SEQ_ID
ColumnTO_ROUTING_SEQUENCE_ID
ColumnFROM_ITEM_ID
MSC_OPERATION_NETWORKS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnROUTING_SEQUENCE_ID
ColumnFROM_OP_SEQ_ID
ColumnFROM_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
FROM_OP_SEQ_ID NUMBER
Yes From routing operation identifier
TO_OP_SEQ_ID NUMBER

To routing operation identifier
TRANSITION_TYPE NUMBER

Primary, Alternate or Rework connection
REFRESH_NUMBER NUMBER

From routing operation identifier
PLANNING_PCT NUMBER

Planning Percentage
CUMMULATIVE_PCT VARCHAR2 (240)
Cumulative Percentage
EFFECTIVITY_DATE DATE

Effective Date
DISABLE_DATE DATE

Disable Date
PLAN_ID NUMBER
Yes To routing operation identifier
CREATED_BY NUMBER
Yes Standard Who column
SR_INSTANCE_ID NUMBER
Yes To routing operation identifier
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes 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
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
Descriptive flexfield segment
ROUTING_SEQUENCE_ID NUMBER
Yes Standard Who column
FROM_OP_SEQ_NUM NUMBER

From Routing operation sequence number
TO_OP_SEQ_NUM NUMBER

To Routing operation sequence number
TO_ROUTING_SEQUENCE_ID NUMBER

To support across routing hard link
MINIMUM_TRANSFER_QTY NUMBER

For modeling MTQ and Across Routings Operation Dependency.
MINIMUM_TIME_OFFSET NUMBER

For hard link
MAXIMUM_TIME_OFFSET NUMBER

For Hard Link
DEPENDENCY_TYPE NUMBER

1 Finish to start, 2 Start to start, 3. parent-child,4 prior-next, 5 hard link across routing
FROM_ITEM_ID NUMBER

To support hard link from component in one routing to component in other routing
APPLY_TO_CHARGES NUMBER

1 yes , 2 No
TRANSFER_QTY NUMBER

for opm
TRANSFER_UOM VARCHAR2 (3)
for opm
TRANSFER_PCT NUMBER

for opm
ORGANIZATION_ID NUMBER

organization id for from_item_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
,      REFRESH_NUMBER
,      PLANNING_PCT
,      CUMMULATIVE_PCT
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      PLAN_ID
,      CREATED_BY
,      SR_INSTANCE_ID
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORIGINAL_SYSTEM_REFERENCE
,      ROUTING_SEQUENCE_ID
,      FROM_OP_SEQ_NUM
,      TO_OP_SEQ_NUM
,      TO_ROUTING_SEQUENCE_ID
,      MINIMUM_TRANSFER_QTY
,      MINIMUM_TIME_OFFSET
,      MAXIMUM_TIME_OFFSET
,      DEPENDENCY_TYPE
,      FROM_ITEM_ID
,      APPLY_TO_CHARGES
,      TRANSFER_QTY
,      TRANSFER_UOM
,      TRANSFER_PCT
,      ORGANIZATION_ID
FROM MSC.MSC_OPERATION_NETWORKS;

Dependencies

[top of page]

MSC.MSC_OPERATION_NETWORKS does not reference any database object

MSC.MSC_OPERATION_NETWORKS is referenced by following:

SchemaAPPS
SynonymMSC_OPERATION_NETWORKS