[Home] [Help] [Dependency Information]
Object Name: | MSD_SR_ITEM_LIST_PRICE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSD.MSD_SR_ITEM_LIST_PRICE_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This is the Source View for Item List Price. This view would be applied to an Oracle Applications 11i instance from which the Item List Price information is to be retrieved. This view specifies the Base UOM, List Price and Average Discount for an Item.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM | VARCHAR2 | (40) | Item | |
SR_ITEM_PK | NUMBER | Yes | Sr Item Pk | |
LIST_PRICE | NUMBER | List Price | ||
AVG_DISCOUNT | VARCHAR2 | (0) | Avg Discount | |
BASE_UOM | VARCHAR2 | (3) | Base Uom | |
ITEM_TYPE_ID | NUMBER | Yes | BOM Item Type | |
FORECAST_TYPE_ID | NUMBER | ATO Forecast Control Type |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM
, SR_ITEM_PK
, LIST_PRICE
, AVG_DISCOUNT
, BASE_UOM
, ITEM_TYPE_ID
, FORECAST_TYPE_ID
FROM APPS.MSD_SR_ITEM_LIST_PRICE_V;
APPS.MSD_SR_ITEM_LIST_PRICE_V is not referenced by any database object
|
|
|