[Home] [Help] [Dependency Information]
Object Name: | MSD_SR_GRP1_GRP2_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSD.MSD_SR_GRP1_GRP2_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 First level Sales Group to Second level Sales Group in the Sales Representative Dimension. This view would be applied to an Oracle Applications 11i instance from which the First level Sales Group to Second level Sales Group association information is to be retrieved.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEVEL_VALUE_PK | NUMBER | Level Value Primary Key | ||
LEVEL_VALUE | VARCHAR2 | (4000) | Level Value | |
LEVEL_VALUE_DESC | VARCHAR2 | (0) | Level Value Description | |
PARENT_VALUE_PK | NUMBER | Parent Value Primary Key | ||
PARENT_VALUE | VARCHAR2 | (4000) | Parent Value | |
PARENT_VALUE_DESC | VARCHAR2 | (0) | Parent Level Value Desc | |
ATTRIBUTE1 | VARCHAR2 | (0) | Attribute1 | |
ATTRIBUTE2 | VARCHAR2 | (0) | Attribute2 | |
ATTRIBUTE3 | VARCHAR2 | (0) | Attribute3 | |
ATTRIBUTE4 | VARCHAR2 | (0) | Attribute4 | |
ATTRIBUTE5 | VARCHAR2 | (0) | Attribute5 |
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
FROM APPS.MSD_SR_GRP1_GRP2_V;
APPS.MSD_SR_GRP1_GRP2_V is not referenced by any database object
|
|
|