[Home] [Help] [Dependency Information]
Object Name: | MSD_LEVEL_ASSOCIATIONS_V1 |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSD.MSD_LEVEL_ASSOCIATIONS_V1 |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view specifies the Level Value Associations for a level with its parent level value in a hierarchy along with the system generated primary keys for these level values. This view is used only for the Level Associations form.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Idetifier | |
INSTANCE | VARCHAR2 | (40) | Instance | |
INSTANCE_CODE | VARCHAR2 | (3) | Instance Code | |
LEVEL_ID | NUMBER | Level Id | ||
LEVEL_NAME | VARCHAR2 | (30) | Level Name | |
DIMENSION_CODE | VARCHAR2 | (3) | Dimension Code | |
LEVEL_VALUE | VARCHAR2 | (240) | Level Value | |
LEVEL_PK | NUMBER | Level Primary Key | ||
SR_LEVEL_PK | VARCHAR2 | (240) | Source Level Primary Key | |
PARENT_LEVEL_ID | NUMBER | Parent Level Id | ||
PARENT_LEVEL_NAME | VARCHAR2 | (30) | Parent Level Name | |
PARENT_LEVEL_VALUE | VARCHAR2 | (4000) | Parent Level Value | |
SR_PARENT_LEVEL_PK | VARCHAR2 | (240) | Source Parent Level Primary Key | |
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 | 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 | ||
PARENT_DP_ENABLED_FLAG | NUMBER | Dimension Values enabled for SOP but not DP | ||
PLAN_TYPE | VARCHAR2 | (3) | Plan Type. Possible Values - SOP, EOL |
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
, PARENT_LEVEL_ID
, PARENT_LEVEL_NAME
, PARENT_LEVEL_VALUE
, SR_PARENT_LEVEL_PK
, 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
, PARENT_DP_ENABLED_FLAG
, PLAN_TYPE
FROM APPS.MSD_LEVEL_ASSOCIATIONS_V1;
APPS.MSD_LEVEL_ASSOCIATIONS_V1 is not referenced by any database object
|
|
|