[Home] [Help] [Dependency Information]
Object Name: | MSD_SR_CLASS_ALL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSD.MSD_SR_CLASS_ALL_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This is the Source View that associates the Customer Class level to Top level in the Geography Dimension. This view would be applied to an Oracle Applications 11i instance from which the Customer Class to Top level association information is to be retrieved.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEVEL_VALUE_PK | VARCHAR2 | (4000) | Level Value Pk | |
LEVEL_VALUE | VARCHAR2 | (4000) | Level Value | |
LEVEL_VALUE_DESC | VARCHAR2 | (0) | Level Value Description | |
PARENT_VALUE_PK | VARCHAR2 | (40) | Parent Value Pk | |
PARENT_VALUE | VARCHAR2 | (4000) | Parent Value | |
PARENT_VALUE_DESC | VARCHAR2 | (4000) | Parent Level Value Desc | |
ATTRIBUTE1 | VARCHAR2 | (0) | Attribute 1 | |
ATTRIBUTE2 | VARCHAR2 | (0) | Attribute 2 | |
ATTRIBUTE3 | VARCHAR2 | (0) | Attribute 3 | |
ATTRIBUTE4 | VARCHAR2 | (0) | Attribute 4 | |
ATTRIBUTE5 | VARCHAR2 | (0) | Attribute 5 | |
SYSTEM_ATTRIBUTE1 | VARCHAR2 | (80) | System Attribute 1 | |
SYSTEM_ATTRIBUTE2 | VARCHAR2 | (0) | System Attribute 2 | |
DP_ENABLED_FLAG | NUMBER | Indicates whether this level value should be visible in regular demand planning or not. |
Cut, paste (and edit) the following text to query this object:
SELECT LEVEL_VALUE_PK
, LEVEL_VALUE
, LEVEL_VALUE_DESC
, PARENT_VALUE_PK
, PARENT_VALUE
, PARENT_VALUE_DESC
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, SYSTEM_ATTRIBUTE1
, SYSTEM_ATTRIBUTE2
, DP_ENABLED_FLAG
FROM APPS.MSD_SR_CLASS_ALL_V;
APPS.MSD_SR_CLASS_ALL_V is not referenced by any database object
|
|
|