[Home] [Help] [Dependency Information]
Object Name: | MSD_SR_REP_MGR1_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSD.MSD_SR_REP_MGR1_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 Sales Representative Level to First level Sales Manager in the Sales Representative Dimension. This view would be applied to an Oracle Applications 11i instance from which the Sales Representative to First level Sales Manager association information is to be retrieved.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEVEL_VALUE_PK | NUMBER | Level Value PK | ||
LEVEL_VALUE | VARCHAR2 | (4000) | Level Value | |
LEVEL_VALUE_DESC | VARCHAR2 | (0) | Level Value Description | |
PARENT_VALUE_PK | NUMBER | Parent Value PK | ||
PARENT_VALUE | VARCHAR2 | (4000) | Parent Value | |
PARENT_VALUE_DESC | VARCHAR2 | (0) | 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 | |
ORG_LEVEL_ID | NUMBER | Organization Level Value that this Sales Rep relates to | ||
ORG_LEVEL_VALUE_PK | NUMBER | Organization Level Value Pk |
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
, ORG_LEVEL_ID
, ORG_LEVEL_VALUE_PK
FROM APPS.MSD_SR_REP_MGR1_V;
APPS.MSD_SR_REP_MGR1_V is not referenced by any database object
|
|
|