[Home] [Help] [Dependency Information]
Object Name: | MSD_HIERARCHIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSD.MSD_HIERARCHIES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view provides the Hierachies, their corresponding State (Valid or Not) and the Dimension to which it belongs.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Underlying row identifier for a form. Not important for the Express server. | |
HIERARCHY_ID | NUMBER | Yes | The Hierarchy ID associated with a particular demand plan dimension. | |
HIERARCHY_NAME | VARCHAR2 | (30) | Yes | The Hierarchy Name associated with a particular DP dimension. |
DESCRIPTION | VARCHAR2 | (240) | Yes | The Hierarchy description. |
OWNING_DIMENSION_CODE | VARCHAR2 | (3) | Yes | Code for the dimension to which that particular hierarchy belongs. |
OWNING_DIMENSION | VARCHAR2 | (80) | Yes | The real dimension to which that particular hierarchy belongs. |
VALID_FLAG | NUMBER | Yes | Hierarchy validity information. The possible values are- 1. Yes, 2. No. This is based on SYS_YES_NO lookup. | |
VALID | VARCHAR2 | (80) | Yes | The actual description for the valid flag. |
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
, HIERARCHY_ID
, HIERARCHY_NAME
, DESCRIPTION
, OWNING_DIMENSION_CODE
, OWNING_DIMENSION
, VALID_FLAG
, VALID
, 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_HIERARCHIES_V;
|
|
|