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: MSD.MSD_LOCAL_ID_SETUP

Object Details

Object Name:	MSD_LOCAL_ID_SETUP
Object Type:	TABLE
Owner:	MSD
FND Design Data:	MSD.MSD_LOCAL_ID_SETUP
Subobject Name:
Status:	VALID

This table is used by Legacy Collection to generate Local ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
LOCAL_ID	NUMBER		Primary Key.
INSTANCE_ID	NUMBER		Source Instance ID
LEVEL_ID	NUMBER		Level ID for which LOCAL_ID is being generated
DATA_SOURCE_TYPE	VARCHAR2	(20)	Data Source Type. For example XML, BATCH. This is an internal column and is populated and used by Legacy Collection.
NUMBER1	NUMBER		Generic Column to store Level Value of number datatype
NUMBER2	NUMBER		Generic Column to store Level Value of number datatype
NUMBER3	NUMBER		Generic Column to store Level Value of number datatype
NUMBER4	NUMBER		Generic Column to store Level Value of number datatype
NUMBER5	NUMBER		Generic Column to store Level Value of number datatype
CHAR1	VARCHAR2	(255)	Generic Column to store Level Value of alphanumeric datatype
CHAR2	VARCHAR2	(255)	Generic Column to store Level Value of alphanumeric datatype
CHAR3	VARCHAR2	(255)	Generic Column to store Level Value of alphanumeric datatype
CHAR4	VARCHAR2	(255)	Generic Column to store Level Value of alphanumeric datatype
CHAR5	VARCHAR2	(255)	Generic Column to store Level Value of alphanumeric datatype
CHAR6	VARCHAR2	(255)	Generic Column to store Level Value of alphanumeric datatype
CHAR7	VARCHAR2	(255)	Generic Column to store Level Value of alphanumeric datatype
CHAR8	VARCHAR2	(255)	Generic Column to store Level Value of alphanumeric datatype
CHAR9	VARCHAR2	(255)	Generic Column to store Level Value of alphanumeric datatype
CHAR10	VARCHAR2	(255)	Generic Column to store Level Value of alphanumeric datatype
DATE1	DATE		Generic Column to store Level Value of date datatype
DATE2	DATE		Generic Column to store Level Value of date datatype
DATE3	DATE		Generic Column to store Level Value of date datatype
DATE4	DATE		Generic Column to store Level Value of date datatype
DATE5	DATE		Generic Column to store Level Value of date datatype
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

Query Text

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


SELECT LOCAL_ID
,      INSTANCE_ID
,      LEVEL_ID
,      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
FROM MSD.MSD_LOCAL_ID_SETUP;

Dependencies

[top of page]

MSD.MSD_LOCAL_ID_SETUP does not reference any database object

MSD.MSD_LOCAL_ID_SETUP is referenced by following:

APPS: MSD_LOCAL_ID_SETUP