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_SUPPLY

Object Details

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

This table stores mappings between the Local IDs and the User Defined Keys for all the Supplies. The table is striped by ENTITY_NAME. The entities stored and their mappings with staging table columns are listed below.
ENTITY_NAME: DISPOSITION_ID_MPS
Sequence for Generating LOCAL_ID: MSC_ST_DISPOSITION_ID_S
Staging Table for this Entity: MSC_ST_SUPPLIES
CHAR1 - SR_INSTANCE_CODE
CHAR2 - COMPANY_NAME
CHAR3 - ORGANIZATION_CODE
CHAR4 - SCHEDULE_DESIGNATOR
CHAR5 - SCHEDULE_LINE_NUM
NUMBER1 - ORDER_TYPE
ENTITY_NAME: DISPOSITION_ID
Sequence for Generating LOCAL_ID: MSC_ST_DISPOSITION_ID_S
Staging Table for this Entity: MSC_ST_SUPPLIES
CHAR1 - SR_INSTANCE_CODE
CHAR2 - COMPANY_NAME
CHAR3 - ORDER_NUMBER
NUMBER1 - ORDER_TYPE

ENTITY_NAME: PO_LINE_ID
Sequence for Generating LOCAL_ID: MSC_ST_PO_LINE_ID_S
Staging Table for this Entity: MSC_ST_SUPPLIES
CHAR1 - SR_INSTANCE_CODE
CHAR2 - COMPANY_NAME
CHAR3 - ORDER_NUMBER
NUMBER1 - PURCH_LINE_NUM
NUMBER2 - ORDER_TYPE

ENTITY_NAME: SCHEDULE_GROUP_ID
Sequence for Generating LOCAL_ID: MSC_ST_SCHEDULE_GROUP_ID_S
Staging Table for this Entity: MSC_ST_SUPPLIES
CHAR1 - SR_INSTANCE_CODE
CHAR2 - COMPANY_NAME
CHAR3 - ORGANIZATION_CODE
CHAR4 - SCHEDULE_GROUP_NAME
ENTITY_NAME: SR_MTL_SUPPLY_ID
Sequence for Generating LOCAL_ID: MSC_ST_SR_MTL_SUPPLY_ID_S
Staging Table for this Entity: MSC_ST_SUPPLIES
CHAR1 - SR_INSTANCE_CODE
CHAR2 - COMPANY_NAME
CHAR3 - ORGANIZATION_CODE
CHAR4 - ORDER_NUMBER
NUMBER1 - PURCH_LINE_NUM
NUMBER2 - ORDER_TYPE

ENTITY_NAME: WIP_ENTITY_ID
Sequence for Generating LOCAL_ID: MSC_ST_WIP_ENTITY_ID_S
Staging Table for this Entity: MSC_ST_SUPPLIES
CHAR1 - SR_INSTANCE_CODE
CHAR2 - COMPANY_NAME
CHAR3 - ORGANIZATION_CODE
CHAR4 - WIP_ENTITY_NAME

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_LOCAL_ID_SUPPLY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHAR4 CHAR3 CHAR1 CHAR2 NUMBER1 NUMBER2
MSC_LOCAL_ID_SUPPLY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHAR5 CHAR4 CHAR3 CHAR1 CHAR2 NUMBER1
MSC_LOCAL_ID_SUPPLY_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHAR3 NUMBER1 CHAR1 CHAR2 NUMBER2

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 to identify 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_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_INVENTORY_ITEM_ID	NUMBER		This is the Inventory Item ID for the Inventory 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_VENDOR_ID	NUMBER		This is the Vendor ID for the Vendor 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_VENDOR_SITE_ID	NUMBER		This is the Vendor Site ID for the Vendor 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_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_FROM_ORGANIZATION_ID	NUMBER		the From Organization Id for the Sourcing Organization (mentioned in the From Organization Code) 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_MTL_SUPPLY_ID	NUMBER		This is a unique ID to identify this supply 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_DISPOSITION_ID	NUMBER		This is the Disposition ID for the Supply 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_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_SCHEDULE_GROUP_ID	NUMBER		This is the Schedule Group ID for the Schedule 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.

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_INVENTORY_ITEM_ID
,      SOURCE_VENDOR_ID
,      SOURCE_VENDOR_SITE_ID
,      SOURCE_TASK_ID
,      SOURCE_FROM_ORGANIZATION_ID
,      SOURCE_SR_MTL_SUPPLY_ID
,      SOURCE_DISPOSITION_ID
,      SOURCE_PROJECT_ID
,      SOURCE_BILL_SEQUENCE_ID
,      SOURCE_ROUTING_SEQUENCE_ID
,      SOURCE_SCHEDULE_GROUP_ID
,      SOURCE_WIP_ENTITY_ID
FROM MSC.MSC_LOCAL_ID_SUPPLY;

Dependencies

[top of page]

MSC.MSC_LOCAL_ID_SUPPLY does not reference any database object

MSC.MSC_LOCAL_ID_SUPPLY is referenced by following:

APPS: MSC_LOCAL_ID_SUPPLY