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

TABLE: MSC.MSC_ST_JOB_OPERATION_NETWORKS

Object Details
Object Name: MSC_ST_JOB_OPERATION_NETWORKS
Object Type: TABLE
Owner: MSC
Subobject Name:
Status: VALID


This table stores the operation network for a lot based job


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

wip entity identifier
SR_INSTANCE_ID NUMBER

Instance identifier
ORGANIZATION_ID NUMBER

Organization indentifier
FROM_OP_SEQ_NUM NUMBER

From routing operation sequence number
TO_OP_SEQ_NUM NUMBER

To routing operation sequence number
FROM_OP_SEQ_ID NUMBER

From routing operation identifier
TO_OP_SEQ_ID NUMBER

To routing operation identifier
RECOMMENDED VARCHAR2 (1)
Recommended by planning or scheduling; or user preferred
TRANSITION_TYPE NUMBER

Primary Alternate or Rework connection
PLANNING_PCT NUMBER

Planning Percentage
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
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
DELETED_FLAG NUMBER

Yes/No flag indicates whether corresponding record in ODS will be deleted
REFRESH_ID NUMBER

Refresh number populated by the collection program
COMPANY_NAME VARCHAR2 (255)
Company Name
SR_INSTANCE_CODE VARCHAR2 (3)
Source instance code
WIP_ENTITY_NAME VARCHAR2 (240)
wip entity name
ORGANIZATION_CODE VARCHAR2 (7)
Organization code
FROM_OPERATION_SEQ_CODE VARCHAR2 (10)
From routing operation sequence code
TO_OPERATION_SEQ_CODE VARCHAR2 (10)
To routing operation sequence code
FROM_OP_EFFECTIVITY_DATE DATE

From routing operation effectivity date
TO_OP_EFFECTIVITY_DATE DATE

To routing operation effectivity date
ROUTING_NAME VARCHAR2 (250)
Routing Name
ASSEMBLY_NAME VARCHAR2 (250)
Assembly Name
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate routing designator
ROUTING_SEQUENCE_ID NUMBER

Routing sequence identifier
DATA_SOURCE_TYPE VARCHAR2 (10)
Source type indicates source of records BATCH/XML
BATCH_ID NUMBER

Batch identifier
ST_TRANSACTION_ID NUMBER

Transaction id generated during pre-processing to uniquely identify the records
MESSAGE_ID NUMBER

To identify the records got via XML
ERROR_TEXT VARCHAR2 (2000)
Error text
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
TO_WIP_ENTITY_ID NUMBER

for inter routing dependency for opm or inter wo dependency for eam
TOP_WIP_ENTITY_ID NUMBER

Identifier of object at upper end of hierarchy
TRANSFER_QTY NUMBER

for opm
TRANSFER_UOM VARCHAR2 (4)
for opm
TRANSFER_PCT NUMBER

for opm
FROM_ITEM_ID NUMBER

populated for opm hard links
MINIMUM_TRANSFER_QTY NUMBER

for modelling MTQ and Across Routing Operation Dependency
MINIMUM_TIME_OFFSET NUMBER

For modelling MTQ and for inter and intra routings operation dependency
MAXIMUM_TIME_OFFSET NUMBER

for modelling MTQ and across routing operation dependency
TO_WIP_ENTITY_NAME VARCHAR2 (240)
for legacy
FROM_ITEM_NAME VARCHAR2 (240)
For Legacy
APPLY_TO_CHARGES NUMBER

Hard link apply to charges or operation
DEPENDENCY_TYPE NUMBER

1 Finish to start, 2 Start to start, 3. parent-child,4 prior-next,
Query Text

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


SELECT WIP_ENTITY_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      FROM_OP_SEQ_NUM
,      TO_OP_SEQ_NUM
,      FROM_OP_SEQ_ID
,      TO_OP_SEQ_ID
,      RECOMMENDED
,      TRANSITION_TYPE
,      PLANNING_PCT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DELETED_FLAG
,      REFRESH_ID
,      COMPANY_NAME
,      SR_INSTANCE_CODE
,      WIP_ENTITY_NAME
,      ORGANIZATION_CODE
,      FROM_OPERATION_SEQ_CODE
,      TO_OPERATION_SEQ_CODE
,      FROM_OP_EFFECTIVITY_DATE
,      TO_OP_EFFECTIVITY_DATE
,      ROUTING_NAME
,      ASSEMBLY_NAME
,      ALTERNATE_ROUTING_DESIGNATOR
,      ROUTING_SEQUENCE_ID
,      DATA_SOURCE_TYPE
,      BATCH_ID
,      ST_TRANSACTION_ID
,      MESSAGE_ID
,      ERROR_TEXT
,      PROCESS_FLAG
,      TO_WIP_ENTITY_ID
,      TOP_WIP_ENTITY_ID
,      TRANSFER_QTY
,      TRANSFER_UOM
,      TRANSFER_PCT
,      FROM_ITEM_ID
,      MINIMUM_TRANSFER_QTY
,      MINIMUM_TIME_OFFSET
,      MAXIMUM_TIME_OFFSET
,      TO_WIP_ENTITY_NAME
,      FROM_ITEM_NAME
,      APPLY_TO_CHARGES
,      DEPENDENCY_TYPE
FROM MSC.MSC_ST_JOB_OPERATION_NETWORKS;

Dependencies

[top of page]

MSC.MSC_ST_JOB_OPERATION_NETWORKS does not reference any database object

MSC.MSC_ST_JOB_OPERATION_NETWORKS is referenced by following:

SchemaAPPS
SynonymMSC_ST_JOB_OPERATION_NETWORKS