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

VIEW: MSD.MSD_LOCAL_ID_SETUP#

Object Details
Object Name: MSD_LOCAL_ID_SETUP#
Object Type: VIEW
Owner: MSD
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOCAL_ID NUMBER

INSTANCE_ID NUMBER

LEVEL_ID NUMBER

DATA_SOURCE_TYPE VARCHAR2 (20)
NUMBER1 NUMBER

NUMBER2 NUMBER

NUMBER3 NUMBER

NUMBER4 NUMBER

NUMBER5 NUMBER

CHAR1 VARCHAR2 (255)
CHAR2 VARCHAR2 (255)
CHAR3 VARCHAR2 (255)
CHAR4 VARCHAR2 (255)
CHAR5 VARCHAR2 (255)
CHAR6 VARCHAR2 (255)
CHAR7 VARCHAR2 (255)
CHAR8 VARCHAR2 (255)
CHAR9 VARCHAR2 (255)
CHAR10 VARCHAR2 (255)
DATE1 DATE

DATE2 DATE

DATE3 DATE

DATE4 DATE

DATE5 DATE

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

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# references the following:

SchemaMSD
TableMSD_LOCAL_ID_SETUP
MSD.MSD_LOCAL_ID_SETUP# is referenced by following:

SchemaAPPS
SynonymMSD_LOCAL_ID_SETUP