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


VIEW: APPS.MSD_LEVEL_VALUES_SOP_V

Object Details
Object Name: MSD_LEVEL_VALUES_SOP_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View DPE to read level values during download stage of a EOL plan. This view is no longer used.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INSTANCE VARCHAR2 (40) Yes Source instance ID
LEVEL_ID NUMBER
Yes Level identifier
LEVEL_VALUE VARCHAR2 (240) Yes Value of the level
SR_LEVEL_PK VARCHAR2 (240) Yes Primary key for the level for the source instance
LEVEL_PK NUMBER
Yes System generated primary key for level
PARENT_LEVEL_ID NUMBER
Yes Parent level ID
PARENT_LEVEL_VALUE VARCHAR2 (4000)
Parent level value
PARENT_SR_LEVEL_PK VARCHAR2 (240)
Parent Source Level Primary Key
PARENT_LEVEL_PK NUMBER

Primary key for the parent level
ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield segment
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER
Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
LAST_REFRESH_NUM NUMBER

Last refresh number
CREATED_BY_REFRESH_NUM NUMBER

Created by refresh number
LEVEL_VALUE_SHORT VARCHAR2 (240) Yes Level Value Short
LEVEL_VALUE_MEDIUM VARCHAR2 (240)
Level Value Medium
LEVEL_VALUE_LONG VARCHAR2 (481)
Level Value Long
PARENT_LEVEL_VALUE_SHORT VARCHAR2 (4000)
Parent Level Value Short
PARENT_LEVEL_VALUE_MEDIUM VARCHAR2 (4000)
Parent Level Value Medium
PARENT_LEVEL_VALUE_LONG VARCHAR2 (4000)
Parent Level Value Long
SYSTEM_ATTRIBUTE1 VARCHAR2 (240)
Attribute to distinguish level values in the same level
SYSTEM_ATTRIBUTE2 VARCHAR2 (240)
Attribute to distinguish level values in the same level
Query Text

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


SELECT INSTANCE
,      LEVEL_ID
,      LEVEL_VALUE
,      SR_LEVEL_PK
,      LEVEL_PK
,      PARENT_LEVEL_ID
,      PARENT_LEVEL_VALUE
,      PARENT_SR_LEVEL_PK
,      PARENT_LEVEL_PK
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_REFRESH_NUM
,      CREATED_BY_REFRESH_NUM
,      LEVEL_VALUE_SHORT
,      LEVEL_VALUE_MEDIUM
,      LEVEL_VALUE_LONG
,      PARENT_LEVEL_VALUE_SHORT
,      PARENT_LEVEL_VALUE_MEDIUM
,      PARENT_LEVEL_VALUE_LONG
,      SYSTEM_ATTRIBUTE1
,      SYSTEM_ATTRIBUTE2
FROM APPS.MSD_LEVEL_VALUES_SOP_V;

Dependencies

[top of page]

APPS.MSD_LEVEL_VALUES_SOP_V references the following:

SchemaAPPS
PL/SQL PackageMSD_COMMON_UTILITIES - show dependent code
SynonymMSD_LEVELS
SynonymMSD_LEVEL_ASSOCIATIONS
SynonymMSD_LEVEL_VALUES
PL/SQL PackageMSD_SR_UTIL - show dependent code

APPS.MSD_LEVEL_VALUES_SOP_V is not referenced by any database object