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


VIEW: APPS.MSD_HIERARCHIES_V

Object Details
Object Name: MSD_HIERARCHIES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSD.MSD_HIERARCHIES_V
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.MSD_HIERARCHIES_V references the following:

SchemaAPPS
ViewFND_LOOKUP_VALUES_VL
ViewMFG_LOOKUPS
SynonymMSD_HIERARCHIES
APPS.MSD_HIERARCHIES_V is referenced by following:

SchemaAPPS
ViewMSD_HIERARCHY_LEVELS_V