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

TABLE: MSC.MSC_ST_OPERATION_NETWORKS

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


The staging table used by collections program to validate and process data for table MSC_OPERATION_NETWORKS.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
FROM_OP_SEQ_ID NUMBER

From Op Seq Id
TO_OP_SEQ_ID NUMBER

To Op Seq Id
TRANSITION_TYPE NUMBER

Transition Type
DELETED_FLAG NUMBER

Deleted Flag
REFRESH_ID NUMBER

Refresh Id
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
Descriptive flexfield segment
PLANNING_PCT NUMBER

planning percentage
CUMMULATIVE_PCT NUMBER

cumulative percentage
EFECTIVITY_DATE DATE

Disable Date
DISABLE_DATE DATE

Disable Date
PLAN_ID NUMBER

plan id
SR_INSTANCE_ID NUMBER

sr instance id
CREATED_BY NUMBER

Standard Who Column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

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 (240)
Attribute4
ATTRIBUTE5 VARCHAR2 (240)
Attribute5
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Attribute8
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Attribute10
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
ROUTING_SEQUENCE_ID NUMBER

Standard Who column
FROM_OP_SEQ_NUM NUMBER

From Routing operation sequence number
TO_OP_SEQ_NUM NUMBER

To Routing operation sequence number
FROM_OPERATION_SEQ_CODE VARCHAR2 (10)
From Operation Seq Code
FROM_OP_EFFECTIVITY_DATE DATE

Effectivity Date of the From Operation
FROM_OP_DISABLE_DATE DATE

Disable Date of the From Operation
TO_OPERATION_SEQ_CODE VARCHAR2 (10)
TO Operation Seq Code
TO_OP_EFFECTIVITY_DATE DATE

Effectivity Date of the To Operation
TO_OP_DISABLE_DATE DATE

Disble Date of the To Operation
ROUTING_NAME VARCHAR2 (250)
Routing Name
ASSEMBLY_NAME VARCHAR2 (250)
Assembly Name
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate Routing Designator
COMPANY_NAME VARCHAR2 (255)
Company Name
ORGANIZATION_CODE VARCHAR2 (7)
Organization Code
SR_INSTANCE_CODE VARCHAR2 (3)
Sr Instance Code
MESSAGE_ID NUMBER

This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML
PROCESS_FLAG NUMBER

Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed
DATA_SOURCE_TYPE VARCHAR2 (15)
Data Source Type
BATCH_ID NUMBER

Batch identifier generated during pre-processing
ERROR_TEXT VARCHAR2 (2000)
If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error
PROGRAM_APPLICATION_ID NUMBER

Program Application Id
REQUEST_ID NUMBER

Request Id
PROGRAM_ID NUMBER

Program Id
PROGRAM_UPDATE_DATE DATE

Program Update Date
ST_TRANSACTION_ID NUMBER

Transaction ID generated during pre-processing to uniquely identify a record in the staging table
TO_ROUTING_SEQUENCE_ID NUMBER

To Support across routing hard link
FROM_ITEM_ID NUMBER

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

For modeling MTQ and Across Routing Operation Dependency
MINIMUM_TIME_OFFSET NUMBER

For modeling MTQ and Across Routing Operation Dependency
MAXIMUM_TIME_OFFSET NUMBER

For modeling MTQ and Across Routing Operation Dependency
TO_ROUTING_NAME VARCHAR2 (250)
Routing Name .To support across routing hard link
TO_ASSEMBLY_ITEM_NAME VARCHAR2 (250)
Assembly Name .To support across routing hard link
FROM_ITEM_NAME VARCHAR2 (250)
Item name of from_item_id . For legacy
TO_ALT_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate Routing designator of 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
DEPENDENCY_TYPE NUMBER

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

org 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
,      DELETED_FLAG
,      REFRESH_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      PLANNING_PCT
,      CUMMULATIVE_PCT
,      EFECTIVITY_DATE
,      DISABLE_DATE
,      PLAN_ID
,      SR_INSTANCE_ID
,      CREATED_BY
,      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
,      ROUTING_SEQUENCE_ID
,      FROM_OP_SEQ_NUM
,      TO_OP_SEQ_NUM
,      FROM_OPERATION_SEQ_CODE
,      FROM_OP_EFFECTIVITY_DATE
,      FROM_OP_DISABLE_DATE
,      TO_OPERATION_SEQ_CODE
,      TO_OP_EFFECTIVITY_DATE
,      TO_OP_DISABLE_DATE
,      ROUTING_NAME
,      ASSEMBLY_NAME
,      ALTERNATE_ROUTING_DESIGNATOR
,      COMPANY_NAME
,      ORGANIZATION_CODE
,      SR_INSTANCE_CODE
,      MESSAGE_ID
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      BATCH_ID
,      ERROR_TEXT
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ST_TRANSACTION_ID
,      TO_ROUTING_SEQUENCE_ID
,      FROM_ITEM_ID
,      MINIMUM_TRANSFER_QTY
,      MINIMUM_TIME_OFFSET
,      MAXIMUM_TIME_OFFSET
,      TO_ROUTING_NAME
,      TO_ASSEMBLY_ITEM_NAME
,      FROM_ITEM_NAME
,      TO_ALT_ROUTING_DESIGNATOR
,      APPLY_TO_CHARGES
,      TRANSFER_QTY
,      TRANSFER_UOM
,      TRANSFER_PCT
,      DEPENDENCY_TYPE
,      ORGANIZATION_ID
FROM MSC.MSC_ST_OPERATION_NETWORKS;

Dependencies

[top of page]

MSC.MSC_ST_OPERATION_NETWORKS does not reference any database object

MSC.MSC_ST_OPERATION_NETWORKS is referenced by following:

SchemaMSC
ViewMSC_ST_OPERATION_NETWORKS#