[Home] [Help] [Dependency Information]
Object Name: | MSD_LEVELS_LB_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
For Liability Analysis, this view provides the Levels, their Owning Dimension. It also specifies the Level Type.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Underlying row identifier for a form. Not important for the Express server. | |
LEVEL_ID | NUMBER | Yes | Level ID. | |
LEVEL_NAME | VARCHAR2 | (30) | Yes | Level name. |
DESCRIPTION | VARCHAR2 | (240) | Yes | Level description. |
OWNING_DIMENSION_CODE | VARCHAR2 | (3) | Yes | Code for the dimension to which that particular hierarchy belongs. |
OWNING_DIMENSION | VARCHAR2 | (80) | Yes | Description for the dimension to which that particular hierarchy belongs. |
LEVEL_TYPE_CODE | VARCHAR2 | (1) | Yes | Level type. The possible values are- 1. Top, 2. Bottom, 3. Internediate. |
LEVEL_TYPE | VARCHAR2 | (80) | Yes | Level type description. |
ATTRIBUTE1_CONTEXT | VARCHAR2 | (240) | Context of the first attribute for this level. | |
ATTRIBUTE2_CONTEXT | VARCHAR2 | (240) | Context of the second attribute for this level. | |
ATTRIBUTE3_CONTEXT | VARCHAR2 | (240) | Context of the third attribute for this level. | |
ATTRIBUTE4_CONTEXT | VARCHAR2 | (240) | Context of the fourth attribute for this level. | |
ATTRIBUTE5_CONTEXT | VARCHAR2 | (240) | Context of the fifth attribute for this level. | |
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. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, LEVEL_ID
, LEVEL_NAME
, DESCRIPTION
, OWNING_DIMENSION_CODE
, OWNING_DIMENSION
, LEVEL_TYPE_CODE
, LEVEL_TYPE
, ATTRIBUTE1_CONTEXT
, ATTRIBUTE2_CONTEXT
, ATTRIBUTE3_CONTEXT
, ATTRIBUTE4_CONTEXT
, ATTRIBUTE5_CONTEXT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM APPS.MSD_LEVELS_LB_V;
|
|
|