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

TABLE: MSC.MSC_LOCAL_ID_ITEM

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


MSC_LOCAL_ID_ITEM table stores the mappings between the Local IDs and the User Defined Keys for Items. The table is striped by ENTITY_NAME. The entities and their mappings with staging table columns are listed below.
ENTITY_NAME: SR_INVENTORY_ITEM_ID
Sequence for Generating LOCAL_ID: MSC_ST_SR_INVENTORY_ITEM_ID_S
Staging Table for this Entity: MSC_ST_SYSTEM_ITEMS
CHAR1 - SR_INSTANCE_CODE
CHAR2 - COMPANY_NAME
CHAR3 - ORGANIZATION_CODE
CHAR4 - ITEM_NAME


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_LOCAL_ID_ITEM_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHAR4
ColumnENTITY_NAME
ColumnCHAR3
ColumnCHAR1
ColumnCHAR2
Columns
Name Datatype Length Mandatory 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)
Entity Name to identify the target for 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_SR_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_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_PRIMARY_SUPPLIER_ID NUMBER

This is the Primary Supplier ID for the Primary Supplier 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_BASE_ITEM_ID NUMBER

This is the Base Item ID for the Base 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.
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_SR_INVENTORY_ITEM_ID
,      SOURCE_SOURCE_ORG_ID
,      SOURCE_PRIMARY_SUPPLIER_ID
,      SOURCE_BASE_ITEM_ID
FROM MSC.MSC_LOCAL_ID_ITEM;

Dependencies

[top of page]

MSC.MSC_LOCAL_ID_ITEM does not reference any database object

MSC.MSC_LOCAL_ID_ITEM is referenced by following:

SchemaMSC
ViewMSC_LOCAL_ID_ITEM#