eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MSC.MSC_ST_ROUTINGS

Object Details

Object Name:	MSC_ST_ROUTINGS
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_ST_ROUTINGS
Subobject Name:
Status:	VALID

The staging table used by the collection program to validate and process
data for table MSC_ROUTINGS.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
ROUTING_SEQUENCE_ID	NUMBER		Routing sequence identifier
ASSEMBLY_ITEM_ID	NUMBER		Assembly item identifier
ROUTING_TYPE	NUMBER		Routing type
ROUTING_COMMENT	VARCHAR2	(960)	Routing comment
PRIORITY	NUMBER		Routing priority
ALTERNATE_ROUTING_DESIGNATOR	VARCHAR2	(40)	Name of the alternate routing. Null for primary routing
PROJECT_ID	NUMBER		Project identifier
TASK_ID	NUMBER		Task identifier
LINE_ID	NUMBER		Manufacturing line identifier
UOM_CODE	VARCHAR2	(3)	Unit of measure code
CFM_ROUTING_FLAG	NUMBER		CFM routing flag
CTP_FLAG	NUMBER		CTP flag
ROUTING_QUANTITY	NUMBER		Routing quantity
COMPLETION_SUBINVENTORY	VARCHAR2	(10)	Completion subinventory
COMPLETION_LOCATOR_ID	NUMBER		Completion locator identifier
COMMON_ROUTING_SEQUENCE_ID	NUMBER		Common routing sequence identifier
MIXED_MODEL_MAP_FLAG	NUMBER		Mix model map flag
TOTAL_PRODUCT_CYCLE_TIME	NUMBER		Total product cycle time
ORGANIZATION_ID	NUMBER		Organization identifer
DELETED_FLAG	NUMBER		Yes/No flag indicates whether corresponding record in ODS will be deleted
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
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
SR_INSTANCE_ID	NUMBER		Source application instance identifier
REFRESH_ID	NUMBER		Refresh identifier
FIRST_OP_SEQ_NUM	NUMBER		Refresh identifier
LAST_OP_SEQ_NUM	NUMBER		Refresh identifier
COMPANY_ID	NUMBER		Company identifier
COMPANY_NAME	VARCHAR2	(255)	Company name
BOM_NAME	VARCHAR2	(250)	BOM Name. If this is empty during uploads then it would be replaced by ASSEMBLY_NAME
ROUTING_NAME	VARCHAR2	(250)	Routing Name
BILL_SEQUENCE_ID	NUMBER		Bill Sequence Identifier
ORGANIZATION_CODE	VARCHAR2	(7)	Organization code
ASSEMBLY_NAME	VARCHAR2	(250)	Assembly Name
SR_INSTANCE_CODE	VARCHAR2	(3)	Source instance code
LINE_CODE	VARCHAR2	(10)	Line Code
PROJECT_NUMBER	VARCHAR2	(25)	Project Number
TASK_NUMBER	VARCHAR2	(25)	Task Number
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(40)	Alternate BOMs Reference
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
ERROR_TEXT	VARCHAR2	(2000)	If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error
DATA_SOURCE_TYPE	VARCHAR2	(15)	Source Type indicating the source of the records[
ST_TRANSACTION_ID	NUMBER		Transaction ID generated during pre-processing to uniquely identify a record in the staging table
BATCH_ID	NUMBER		Batch identifier generated during pre-processing
FIRST_OPERATION_SEQ_CODE	VARCHAR2	(10)	First operation sequence code of the network
LAST_OPERATION_SEQ_CODE	VARCHAR2	(10)	Last operation sequence code of the network
COMMON_ROUTING_NAME	VARCHAR2	(250)	Common routing sequence code
ITEM_PROCESS_COST	NUMBER		Item process cost
SOURCE_ORGANIZATION_ID	NUMBER		This is the Organization ID for the Organization in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only.
SOURCE_ASSEMBLY_ITEM_ID	NUMBER		This is the Assembly Item ID for the Assembly Item in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only.
SOURCE_ROUTING_SEQUENCE_ID	NUMBER		This is the Routing Sequence ID for the Routing Sequence in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only.
SOURCE_TASK_ID	NUMBER		This is the Task ID for the Task in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only.
SOURCE_PROJECT_ID	NUMBER		This is the Project ID for the Project in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only.
SOURCE_BILL_SEQUENCE_ID	NUMBER		This is the Bill Sequence ID for the Bill Sequence in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only.
SOURCE_COMMON_ROUTING_SEQ_ID	NUMBER		This is the Common Routing Sequence ID for the Common Routing Sequence in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only.
SOURCE_LINE_ID	NUMBER		This is the Line ID for the Line in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only.
AUTO_STEP_QTY_FLAG	NUMBER		1 Yes, 2 No1 yes => Calculate the Step Quantity fieldbased on the amount of ingredients per step as defined in the StepMaterial Association.2=> step quantities are calculated fromthe default routing steps,

Query Text

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


SELECT ROUTING_SEQUENCE_ID
,      ASSEMBLY_ITEM_ID
,      ROUTING_TYPE
,      ROUTING_COMMENT
,      PRIORITY
,      ALTERNATE_ROUTING_DESIGNATOR
,      PROJECT_ID
,      TASK_ID
,      LINE_ID
,      UOM_CODE
,      CFM_ROUTING_FLAG
,      CTP_FLAG
,      ROUTING_QUANTITY
,      COMPLETION_SUBINVENTORY
,      COMPLETION_LOCATOR_ID
,      COMMON_ROUTING_SEQUENCE_ID
,      MIXED_MODEL_MAP_FLAG
,      TOTAL_PRODUCT_CYCLE_TIME
,      ORGANIZATION_ID
,      DELETED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SR_INSTANCE_ID
,      REFRESH_ID
,      FIRST_OP_SEQ_NUM
,      LAST_OP_SEQ_NUM
,      COMPANY_ID
,      COMPANY_NAME
,      BOM_NAME
,      ROUTING_NAME
,      BILL_SEQUENCE_ID
,      ORGANIZATION_CODE
,      ASSEMBLY_NAME
,      SR_INSTANCE_CODE
,      LINE_CODE
,      PROJECT_NUMBER
,      TASK_NUMBER
,      ALTERNATE_BOM_DESIGNATOR
,      MESSAGE_ID
,      PROCESS_FLAG
,      ERROR_TEXT
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      BATCH_ID
,      FIRST_OPERATION_SEQ_CODE
,      LAST_OPERATION_SEQ_CODE
,      COMMON_ROUTING_NAME
,      ITEM_PROCESS_COST
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ASSEMBLY_ITEM_ID
,      SOURCE_ROUTING_SEQUENCE_ID
,      SOURCE_TASK_ID
,      SOURCE_PROJECT_ID
,      SOURCE_BILL_SEQUENCE_ID
,      SOURCE_COMMON_ROUTING_SEQ_ID
,      SOURCE_LINE_ID
,      AUTO_STEP_QTY_FLAG
FROM MSC.MSC_ST_ROUTINGS;

Dependencies

[top of page]

MSC.MSC_ST_ROUTINGS does not reference any database object

MSC.MSC_ST_ROUTINGS is referenced by following:

MSC: MSC_ST_ROUTINGS#