DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.MSD_SR_ITEM_LIST_PRICE_V

Object Details
Object Name: MSD_SR_ITEM_LIST_PRICE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSD.MSD_SR_ITEM_LIST_PRICE_V
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.MSD_SR_ITEM_LIST_PRICE_V references the following:

SchemaAPPS
PL/SQL PackageMSD_SR_UTIL - show dependent code
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.MSD_SR_ITEM_LIST_PRICE_V is not referenced by any database object