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_LOCAL_ID_SETUP

Object Details

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

MSC_LOCAL_ID_SETUP table stores the mappings between the Local IDs and the User Defined Keys for BOM, Routing, Trading Partners, Departments, Resources and Calendars. The table is striped by ENTITY_NAME. The entities and their mappings with staging table columns are listed below.
ENTITY_NAME: BILL_SEQUENCE_ID
Seq for Generating LOCAL_ID: MSC_ST_BILL_SEQUENCE_ID_S
St Table for this Entity: MSC_ST_BOMS
CHAR1 -SR_INSTANCE_CODE
CHAR2 -COMPANY_NAME
CHAR3 -ORGANIZATION_CODE
CHAR4 -BOM_NAME
CHAR5 -ASSEMBLY_NAME
CHAR6 -ALTERNATE_BOM_DESIGNATOR
ENTITY_NAME: COMPONENT_SEQUENCE_ID
Seq for Generating LOCAL_ID: MSC_ST_COMPONENT_SEQUENCE_ID_S
St Table for this Entity: MSC_ST_BOMS
CHAR1 -SR_INSTANCE_CODE
CHAR2 -COMPANY_NAME
CHAR3 -ORGANIZATION_CODE
CHAR4 -BOM_NAME
CHAR5 -COMPONENT_NAME
CHAR6 -ALTERNATE_BOM_DESIGNATOR
CHAR7 -OPERATION_SEQ_CODE
DATE1 -EFFECTIVITY_DATE
DATE2 -DISABLE_DATE
ENTITY_NAME: ROUTING_SEQUENCE_ID
Seq for Generating LOCAL_ID: MSC_ST_ROUTING_SEQUENCE_ID_S
St Table for this Entity: MSC_ST_ROUTINGS
CHAR1 -SR_INSTANCE_CODE
CHAR2 -COMPANY_NAME
CHAR3 -ORGANIZATION_CODE
CHAR4 -ROUTING_NAME
CHAR5 -ASSEMBLY_NAME
CHAR6 -ALTERNATE_ROUTING_DESIGNATOR
NUMBER1 - BILL_SEQUENCE_ID
ENTITY_NAME: OPERATION_SEQUENCE_ID
Seq for Generating LOCAL_ID: MSC_OPERATION_SEQUENCE_ID_S
St Table for this Entity: MSC_ST_ROUTING_OPERATIONS
CHAR1 -SR_INSTANCE_CODE
CHAR2 -COMPANY_NAME
CHAR3 -ORGANIZATION_CODE
CHAR4 -ROUTING_NAME
CHAR5 -OPERATION_SEQ_CODE
CHAR6 -ALTERNATE_ROUTING_DESIGNATOR
DATE1 -EFFFECTIVITY_DATE
DATE2 -DISABLE_DATE
NUMBER1 - OPERATION_SEQ_NUM
ENTITY_NAME: RESOURCE_SEQ_NUM
Seq for Generating LOCAL_ID: MSC_ST_RESOURCE_SEQ_NUM_S
St Table for this Entity: MSC_ST_OPERATION_RESOURCES
CHAR1 -SR_INSTANCE_CODE
CHAR2 -COMPANY_NAME
CHAR3 -ORGANIZATION_CODE
CHAR4 -ROUTING_NAME
CHAR5 -OPERATION_SEQ_CODE
CHAR6 -RESOURCE_SEQ_CODE
CHAR7 -ALTERNATE_ROUTING_DESIGNATOR
NUMBER1 - ALTERNATE_NUMBER
ENTITY_NAME: DEPARTMENT_ID
Seq for Generating LOCAL_ID: MSC_ST_DEPARTMENT_ID_S
St Table for this Entity: MSC_ST_DEPARTMENT_RESOURCES
CHAR1 -SR_INSTANCE_CODE
CHAR2 -COMPANY_NAME
CHAR3 -ORGANIZATION_CODE
CHAR4 -DEPARTMENT_CODE
ENTITY_NAME: RESOURCE_ID
Seq for Generating LOCAL_ID: MSC_ST_RESOURCE_ID_S
St Table for this Entity: MSC_ST_DEPARTMENT_RESOURCES
CHAR1 - SR_INSTANCE_CODE
CHAR2 -COMPANY_NAME
CHAR3 -ORGANIZATION_CODE
CHAR4 -RESOURCE_CODE
ENTITY_NAME: LINE_ID
Seq for Generating LOCAL_ID: MSC_ST_LINE_ID_S
St Table for this Entity: MSC_ST_DEPARTMENT_RESOURCES
CHAR1 -SR_INSTANCE_CODE
CHAR2 -COMPANY_NAME
CHAR3 -ORGANIZATION_CODE
CHAR4 -LINE_CODE
ENTITY_NAME: SHIFT_NUM
Seq for Generating LOCAL_ID: MSC_ST_SHIFT_NUM_S
St Table for this Entity: MSC_ST_CALENDAR_SHIFTS
CHAR1 -SR_INSTANCE_CODE
CHAR2 -CALENDAR_CODE
CHAR3 -COMPANY_NAME
CHAR4 -SHIFT_NAME
ENTITY_NAME: SR_TP_ID
Seq for Generating LOCAL_ID: MSC_ST_SR_TP_ID_S
St Table for this Entity: MSC_ST_TRADING_PARTNERS
CHAR1 -SR_INSTANCE_CODE
CHAR2 -COMPANY_NAME
CHAR3 -PARTNER_NAME
NUMBER1 -PARTNER_TYPE
ENTITY_NAME: SR_TP_SITE_ID
Seq for Generating LOCAL_ID: MSC_ST_SR_TP_SITE_ID_S
St Table for this Entity: MSC_ST_TRADING_PARTNER_SITES
CHAR1 -SR_INSTANCE_CODE
CHAR2 -COMPANY_NAME
CHAR3 -PARTNER_NAME
CHAR4 -TP_SITE_CODE
NUMBER1 -PARTNER_TYPE
ENTITY_NAME: LOCATION_ID
Seq for Generating LOCAL_ID: MSC_ST_LOCATION_ID_S
St Table for this Entity: MSC_ST_LOCATION_ASSOCIATIONS
CHAR1 -SR_INSTANCE_CODE
CHAR2 -COMPANY_NAME
CHAR3 -PARTNER_NAME
CHAR4 -LOCATION

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_LOCAL_ID_SETUP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHAR5 CHAR4 ENTITY_NAME CHAR3 CHAR1 CHAR2 CHAR6
MSC_LOCAL_ID_SETUP_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHAR4 ENTITY_NAME CHAR3 CHAR1 CHAR2
MSC_LOCAL_ID_SETUP_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHAR3 ENTITY_NAME CHAR1 CHAR2

Columns

Name	Datatype	Length	Comments
LOCAL_ID	NUMBER		ID generated locally by Pre-processor
ST_TRANSACTION_ID	NUMBER		Transaction ID in the staging table for the record
INSTANCE_ID	NUMBER		Instance Identifier
ENTITY_NAME	VARCHAR2	(80)	The Entity name to identify the target for the user defined keys
DATA_SOURCE_TYPE	VARCHAR2	(15)	Source type indicating the source of data
NUMBER1	NUMBER		Number1
NUMBER2	NUMBER		Number2
NUMBER3	NUMBER		Number3
NUMBER4	NUMBER		Number4
NUMBER5	NUMBER		Number5
CHAR1	VARCHAR2	(255)	Char1
CHAR2	VARCHAR2	(255)	Char2
CHAR3	VARCHAR2	(255)	Char3
CHAR4	VARCHAR2	(255)	Char4
CHAR5	VARCHAR2	(255)	Char5
CHAR6	VARCHAR2	(255)	Char6
CHAR7	VARCHAR2	(255)	Char7
CHAR8	VARCHAR2	(255)	Char8
CHAR9	VARCHAR2	(255)	Char9
CHAR10	VARCHAR2	(255)	Char10
DATE1	DATE		Date1
DATE2	DATE		Date2
DATE3	DATE		Date3
DATE4	DATE		Date4
DATE5	DATE		Date5
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
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_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_INVENTORY_ITEM_ID	NUMBER		This is the Inventory Item ID for the 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_COMPONENT_SEQ_ID	NUMBER		This is the Component Sequence ID for the Component 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_USING_ASSEMBLY_ID	NUMBER		This is the Using Assembly ID for the Assembly 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_DRIVING_ITEM_ID	NUMBER		This is the Driving Item ID for the Driving 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_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_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.
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_OPERATION_SEQUENCE_ID	NUMBER		This is the Operation Sequence ID for the Operation 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_OPERATION_SEQ_NUM	NUMBER		This is the Operation Sequence Number for the Operation 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_DEPARTMENT_ID	NUMBER		This is the Department ID for the Department 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_RESOURCE_SEQ_NUM	NUMBER		This is the Resource Sequence Number for the Resource 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_RESOURCE_ID	NUMBER		This is the Resource ID for the Resource 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_OWNING_DEPARTMENT_ID	NUMBER		This is the Owning Department ID for the Owning Department 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_SOURCE_ORG_ID	NUMBER		This is the Organization ID for the Sourcing 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_SR_TP_ID	NUMBER		This is the Trading partner ID for the Trading partner 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_SR_TP_SITE_ID	NUMBER		This is the Trading Partner Site ID for the Trading Partner Site 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_COMPONENT_ID	NUMBER		This is the Component ID for the Component 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_CO_PRODUCT_ID	NUMBER		This is the Product ID for the Co Product 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_CO_PRODUCT_GROUP_ID	NUMBER		This is the Product Group ID for the Co Product Group 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_WIP_ENTITY_ID	NUMBER		This is the Wip Entity ID for the Wip Entity 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.

Query Text

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


SELECT LOCAL_ID
,      ST_TRANSACTION_ID
,      INSTANCE_ID
,      ENTITY_NAME
,      DATA_SOURCE_TYPE
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      NUMBER5
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      CHAR6
,      CHAR7
,      CHAR8
,      CHAR9
,      CHAR10
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      DATE5
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SOURCE_ORGANIZATION_ID
,      SOURCE_BILL_SEQUENCE_ID
,      SOURCE_INVENTORY_ITEM_ID
,      SOURCE_COMPONENT_SEQ_ID
,      SOURCE_USING_ASSEMBLY_ID
,      SOURCE_DRIVING_ITEM_ID
,      SOURCE_ASSEMBLY_ITEM_ID
,      SOURCE_ROUTING_SEQUENCE_ID
,      SOURCE_TASK_ID
,      SOURCE_LINE_ID
,      SOURCE_COMMON_ROUTING_SEQ_ID
,      SOURCE_OPERATION_SEQUENCE_ID
,      SOURCE_OPERATION_SEQ_NUM
,      SOURCE_DEPARTMENT_ID
,      SOURCE_RESOURCE_SEQ_NUM
,      SOURCE_RESOURCE_ID
,      SOURCE_OWNING_DEPARTMENT_ID
,      SOURCE_SOURCE_ORG_ID
,      SOURCE_SR_TP_ID
,      SOURCE_SR_TP_SITE_ID
,      SOURCE_COMPONENT_ID
,      SOURCE_CO_PRODUCT_ID
,      SOURCE_CO_PRODUCT_GROUP_ID
,      SOURCE_WIP_ENTITY_ID
,      SOURCE_PROJECT_ID
FROM MSC.MSC_LOCAL_ID_SETUP;

Dependencies

[top of page]

MSC.MSC_LOCAL_ID_SETUP does not reference any database object

MSC.MSC_LOCAL_ID_SETUP is referenced by following:

APPS: MSC_LOCAL_ID_SETUP