[Home] [Help] [Dependency Information]
Object Name: | MSD_LEVEL_VALUES_V1 |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSD.MSD_LEVEL_VALUES_V1 |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view specifies the Level Values along with the system generated primary keys for these level values. This view is used only for the Level Values form.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier | |
INSTANCE | VARCHAR2 | (40) | Yes | Instance |
INSTANCE_CODE | VARCHAR2 | (3) | Yes | Instance Code |
LEVEL_ID | NUMBER | Yes | Level Id | |
LEVEL_NAME | VARCHAR2 | (30) | Yes | Level Name |
DIMENSION_CODE | VARCHAR2 | (3) | Yes | Dimension Code |
LEVEL_VALUE | VARCHAR2 | (240) | Yes | Level Value |
LEVEL_PK | NUMBER | Yes | Level Primary Key | |
SR_LEVEL_PK | VARCHAR2 | (240) | Yes | Source Level Primary Key |
LEVEL_VALUE_DESC | VARCHAR2 | (240) | Level Value Desc | |
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 | ||
REQUEST_ID | NUMBER | Enhanced Who Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Enhanced Who Column | ||
PROGRAM_ID | NUMBER | Enhanced Who Column | ||
PROGRAM_UPDATE_DATE | DATE | Enhanced Who Column | ||
LAST_REFRESH_NUM | NUMBER | last refresh number | ||
CREATED_BY_REFRESH_NUM | NUMBER | created by refresh number | ||
DP_ENABLED_FLAG | NUMBER | Dimension Values enabled for SOP but not DP |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, INSTANCE
, INSTANCE_CODE
, LEVEL_ID
, LEVEL_NAME
, DIMENSION_CODE
, LEVEL_VALUE
, LEVEL_PK
, SR_LEVEL_PK
, LEVEL_VALUE_DESC
, 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
, LAST_REFRESH_NUM
, CREATED_BY_REFRESH_NUM
, DP_ENABLED_FLAG
FROM APPS.MSD_LEVEL_VALUES_V1;
APPS.MSD_LEVEL_VALUES_V1 is not referenced by any database object
|
|
|