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

VIEW: MSD.MSD_LEVEL_VALUES#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
INSTANCE VARCHAR2 (40) Yes
LEVEL_ID NUMBER
Yes
LEVEL_VALUE VARCHAR2 (240) Yes
LEVEL_VALUE_PK NUMBER

PARENT_LEVEL_ID NUMBER

PARENT_LEVEL_VALUE VARCHAR2 (240)
PARENT_LEVEL_VALUE_PK VARCHAR2 (240)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

SR_LEVEL_PK VARCHAR2 (240) Yes
LEVEL_PK NUMBER
Yes
LAST_REFRESH_NUM NUMBER

CREATED_BY_REFRESH_NUM NUMBER

ACTION_CODE VARCHAR2 (30)
LEVEL_VALUE_DESC VARCHAR2 (240)
SYSTEM_ATTRIBUTE1 VARCHAR2 (240)
SYSTEM_ATTRIBUTE2 VARCHAR2 (240)
DP_ENABLED_FLAG NUMBER

Query Text

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


SELECT INSTANCE
,      LEVEL_ID
,      LEVEL_VALUE
,      LEVEL_VALUE_PK
,      PARENT_LEVEL_ID
,      PARENT_LEVEL_VALUE
,      PARENT_LEVEL_VALUE_PK
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SR_LEVEL_PK
,      LEVEL_PK
,      LAST_REFRESH_NUM
,      CREATED_BY_REFRESH_NUM
,      ACTION_CODE
,      LEVEL_VALUE_DESC
,      SYSTEM_ATTRIBUTE1
,      SYSTEM_ATTRIBUTE2
,      DP_ENABLED_FLAG
FROM MSD.MSD_LEVEL_VALUES#;

Dependencies

[top of page]

MSD.MSD_LEVEL_VALUES# references the following:

SchemaMSD
TableMSD_LEVEL_VALUES
MSD.MSD_LEVEL_VALUES# is referenced by following:

SchemaAPPS
SynonymMSD_LEVEL_VALUES