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_MISC

Object Details

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

MSC_LOCAL_ID_MISC table stores the mappings between the Local IDs and the User Defined Keys for Sourcing Rules, Projects, Tasks and Categories. The table is striped by ENTITY_NAME. The entities and their mappings with staging table columns are listed below.
ENTITY_NAME: ASSIGNMENT_SET_ID
Sequence for Generating LOCAL_ID: MSC_ST_ASSIGNMENT_SET_ID_S
Staging Table for this Entity: MSC_ST_ITEM_SOURCING
CHAR1 - SR_INSTANCE_CODE
CHAR2 - COMPANY_NAME
CHAR3 - ASSIGNMENT_SET_NAME

ENTITY_NAME: SOURCING_RULE_ID
Sequence for Generating LOCAL_ID: MSC_ST_SR_SOURCING_RULE_ID_S
Staging Table for this Entity: MSC_ST_ITEM_SOURCING
CHAR1 - SR_INSTANCE_CODE
CHAR2 - COMPANY_NAME
CHAR3 - ORGANIZATION_CODE
CHAR4 - SOURCING_RULE_NAME

ENTITY_NAME: SR_RECEIPT_ID
Sequence for Generating LOCAL_ID: MSC_ST_SR_RECEIPT_ID_S
Staging Table for this Entity: MSC_ST_ITEM_SOURCING
CHAR1 - SR_INSTANCE_CODE
CHAR2 - COMPANY_NAME
CHAR3 - ORGANIZATION_CODE
CHAR4 - SOURCING_RULE_NAME
CHAR5 - RECEIPT_ORGANIZATION_CODE
CHAR6 - RECEIPT_ORG_INSTANCE_CODE
DATE1 - EFFECTIVE_DATE

ENTITY_NAME: SR_SOURCE_ID
Sequence for Generating LOCAL_ID: MSC_ST_SR_SOURCE_ID_S
Staging Table for this Entity: MSC_ST_ITEM_SOURCING
CHAR1 - SR_INSTANCE_CODE
CHAR2 - COMPANY_NAME
CHAR3 - ORGANIZATION_CODE
CHAR4 - SOURCING_RULE_NAME
CHAR5 - SOURCE_ORGANIZATION_CODE
CHAR6 - SOURCE_ORG_INSTANCE_CODE
CHAR7 - SOURCE_PARTNER_SITE_CODE
CHAR8 - SOURCE_PARTNER_NAME
CHAR9 - RECEIPT_ORGANIZATION_CODE
CHAR10 - RECEIPT_ORG_INSTANCE_CODE
DATE1 - EFFECTIVE_DATE

ENTITY_NAME: ASSIGNMENT_ID
Sequence for Generating LOCAL_ID: MSC_ST_ASSIGNMENT_ID_S
Staging Table for this Entity: MSC_ST_ITEM_SOURCING
CHAR1 - SR_INSTANCE_CODE
CHAR2 - COMPANY_NAME
CHAR3 - ORGANIZATION_CODE
CHAR4 - ASSIGNMENT_SET_NAME
CHAR5 - ITEM_NAME
CHAR6 - CATEGORY_NAME

ENTITY_NAME: PROJECT_ID
Sequence for Generating LOCAL_ID: MSC_ST_PROJECT_ID_S
Staging Table for this Entity: MSC_ST_PROJECT_TASKS
CHAR1 - SR_INSTANCE_CODE
CHAR2 - COMPANY_NAME
CHAR3 - ORGANIZATION_CODE
CHAR4 - PROJECT_NUMBER

ENTITY_NAME: TASK_ID
Sequence for Generating LOCAL_ID: MSC_ST_TASK_ID_S
Staging Table for this Entity: MSC_ST_PROJECT_TASKS
CHAR1 - SR_INSTANCE_CODE
CHAR2 - COMPANY_NAME
CHAR3 - ORGANIZATION_CODE
CHAR4 - PROJECT_NUMBER
CHAR5 - TASK_NUMBER

ENTITY_NAME: COSTING_GROUP_ID
Sequence for Generating LOCAL_ID: MSC_ST_COSTING_GROUP_ID_S
Staging Table for this Entity: MSC_ST_PROJECT_TASKS
CHAR1 - SR_INSTANCE_CODE
CHAR2 - COMPANY_NAME
CHAR3 - ORGANIZATION_CODE
CHAR4 - COST_GROUP_ID

ENTITY_NAME: SR_CATEGORY_ID
Sequence for Generating LOCAL_ID: MSC_ST_SR_CATEGORY_ID_S
Staging Table for this Entity: MSC_ST_ITEM_CATEGORIES
CHAR1 - SR_INSTANCE_CODE
CHAR2 - COMPANY_NAME
CHAR3 - CATEGORY_NAME
ENTITY_NAME: SR_CATEGORY_SET_ID
Sequence for Generating LOCAL_ID: MSC_ST_SR_CATEGORY_SET_ID_S
Staging Table for this Entity: MSC_ST_CATEGORY_SETS
CHAR1 - SR_INSTANCE_CODE
CHAR2 - COMPANY_NAME
CHAR3 - CATEGORY_SET_NAME

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_LOCAL_ID_MISC_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHAR4 ENTITY_NAME CHAR3 CHAR1 CHAR2 CHAR5 CHAR6
MSC_LOCAL_ID_MISC_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHAR5 CHAR6 CHAR4 ENTITY_NAME CHAR3 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 identifying the source of data , BATCH/XML
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_ORG_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_RECEIPT_ORGANIZATION_ID	NUMBER		This is the Receipt Organization ID for the Receipt 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_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_CATEGORY_SET_ID	NUMBER		This is the Category Set ID for the Category Set 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_CATEGORY_ID	NUMBER		This is the Category ID for the Category 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_PARTNER_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_SOURCE_PARTNER_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_SOURCE_ORGANIZATION_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_SOURCING_RULE_ID	NUMBER		This is the Sourcing Rule ID for the Sourcing Rule 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_ASSIGNMENT_SET_ID	NUMBER		This is the Assignment Set ID for the Assignment Set 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_RECEIPT_ID	NUMBER		This is the Receipt ID for the Receipt 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_SOURCE_ID	NUMBER		This is the Supplying Organization ID for the Supplying 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_ASSIGNMENT_ID	NUMBER		This is the Assignment ID for the Assignment 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_CATEGORY_SET_ID	NUMBER		This is the Category Set ID for the Category Set 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_CATEGORY_ID	NUMBER		This is the Category ID for the Category 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_ABC_CLASS_ID	NUMBER		This is the ABS Class ID for the ABC Class 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_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_COSTING_GROUP_ID	NUMBER		This is the Costing Group ID for the Costing 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.

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_ORG_ID
,      SOURCE_RECEIPT_ORGANIZATION_ID
,      SOURCE_INVENTORY_ITEM_ID
,      SOURCE_CATEGORY_SET_ID
,      SOURCE_CATEGORY_ID
,      SOURCE_SOURCE_PARTNER_ID
,      SOURCE_SOURCE_PARTNER_SITE_ID
,      SOURCE_SOURCE_ORGANIZATION_ID
,      SOURCE_SOURCING_RULE_ID
,      SOURCE_ASSIGNMENT_SET_ID
,      SOURCE_SR_RECEIPT_ID
,      SOURCE_SR_SOURCE_ID
,      SOURCE_ASSIGNMENT_ID
,      SOURCE_SR_CATEGORY_SET_ID
,      SOURCE_SR_CATEGORY_ID
,      SOURCE_ABC_CLASS_ID
,      SOURCE_PROJECT_ID
,      SOURCE_TASK_ID
,      SOURCE_COSTING_GROUP_ID
FROM MSC.MSC_LOCAL_ID_MISC;

Dependencies

[top of page]

MSC.MSC_LOCAL_ID_MISC does not reference any database object

MSC.MSC_LOCAL_ID_MISC is referenced by following:

APPS: MSC_LOCAL_ID_MISC