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

TABLE: MSC.MSC_ROUTINGS

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


This table stores the different routings available for a bill of material.


Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_ROUTINGS_U1 NORMAL UNIQUE Tablespace ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnROUTING_SEQUENCE_ID
ColumnACTIVITY_ITEM_ID
ColumnASSEMBLY_ITEM_ID
MSC_ROUTINGS_N1 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnASSEMBLY_ITEM_ID
ColumnORGANIZATION_ID
ColumnROUTING_SEQUENCE_ID
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Plan identifier
SR_INSTANCE_ID NUMBER
Yes Source application instance identifier
ROUTING_SEQUENCE_ID NUMBER
Yes Source application operational routing sequence identifier
ROUTING_TYPE NUMBER
Yes Manufacturing(1), or Engineering(2). For UI and reports
ROUTING_COMMENT VARCHAR2 (240)
Comments. Used for UI and reports
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (40)
Name of the alternate routing. Null for primary routing
PROJECT_ID NUMBER

Project identifier for project manufacturing
TASK_ID NUMBER

Task identifier for project manufacturing
LINE_ID NUMBER

For flow manufacturing. A routing is actually a line (not used for now)
UOM_CODE VARCHAR2 (3)
Unit of measure
CFM_ROUTING_FLAG NUMBER

Flag to indicate whether the routing is continuos flow or traditional routing
CTP_FLAG NUMBER

Flag to indicate whether capacity must be checked when item is ordered
ASSEMBLY_ITEM_ID NUMBER
Yes Assembly item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
ROUTING_QUANTITY NUMBER

Routing quantity
REFRESH_NUMBER NUMBER

Refresh number populated by the collection program
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN 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
FIRST_OP_SEQ_NUM NUMBER

Concurrent Who column
LAST_OP_SEQ_NUM NUMBER

Concurrent Who column
COMMON_ROUTING_SEQUENCE_ID NUMBER

Value of Common Routing Sequence ID
AUTO_STEP_QTY_FLAG NUMBER

Populated for OPM 1 yes, 2 No
REPAIRABLE NUMBER

ACTIVITY_ITEM_ID NUMBER

SIMULATION_SET_ID NUMBER

Query Text

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


SELECT PLAN_ID
,      SR_INSTANCE_ID
,      ROUTING_SEQUENCE_ID
,      ROUTING_TYPE
,      ROUTING_COMMENT
,      ALTERNATE_ROUTING_DESIGNATOR
,      PROJECT_ID
,      TASK_ID
,      LINE_ID
,      UOM_CODE
,      CFM_ROUTING_FLAG
,      CTP_FLAG
,      ASSEMBLY_ITEM_ID
,      ORGANIZATION_ID
,      ROUTING_QUANTITY
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      FIRST_OP_SEQ_NUM
,      LAST_OP_SEQ_NUM
,      COMMON_ROUTING_SEQUENCE_ID
,      AUTO_STEP_QTY_FLAG
,      REPAIRABLE
,      ACTIVITY_ITEM_ID
,      SIMULATION_SET_ID
FROM MSC.MSC_ROUTINGS;

Dependencies

[top of page]

MSC.MSC_ROUTINGS does not reference any database object

MSC.MSC_ROUTINGS is referenced by following:

SchemaMSC
ViewMSC_ROUTINGS#