[Home] [Help]
[Dependency Information]
Object Name: | MSD_SR_PRD_IT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
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 Product level to Interest Type level in the Product Dimension. This view would be applied to an Oracle Sales Online Applications 11i instance from which the Product to Interest Type level association information is to be retrieved.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEVEL_VALUE_PK | NUMBER | Level Value Pk | ||
LEVEL_VALUE | VARCHAR2 | (40) | Level Value | |
LEVEL_VALUE_DESC | VARCHAR2 | (240) | 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) | Attribute1 | |
ATTRIBUTE2 | VARCHAR2 | (0) | Attribute2 | |
ATTRIBUTE3 | VARCHAR2 | (0) | Attribute3 | |
ATTRIBUTE4 | VARCHAR2 | (0) | Attribute4 | |
ATTRIBUTE5 | VARCHAR2 | (0) | Attribute5 | |
DP_ENABLED_FLAG | VARCHAR2 | (0) | This column is not in use. It was used to distinguish DP, SOP and EOL level values. |
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
, DP_ENABLED_FLAG
FROM APPS.MSD_SR_PRD_IT_V;
APPS.MSD_SR_PRD_IT_V is not referenced by any database object
|
|
|