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

VIEW: APPS.MSD_ITEM_MASTER_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view exposes item specific properties - forecast type, base uom, average discount, list price - to the demand planning engine.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ITEM_PK NUMBER

Item Key
ITEM VARCHAR2 (320) Yes Item Name
ITEM_TYPE_ID VARCHAR2 (30) Yes BOM Item Type Id
ITEM_TYPE VARCHAR2 (80) Yes BOM Item Type
FORECAST_TYPE_ID VARCHAR2 (30) Yes ATO Forecast Control Type Id
FORECAST_TYPE VARCHAR2 (80) Yes ATO Forecast Control Type
BASE_UOM VARCHAR2 (3)
Base UOM
AVG_DISCOUNT NUMBER

Average Discount Value
LIST_PRICE NUMBER

Item List Price
LAST_REFRESH_NUM NUMBER

last refresh number
CREATED_BY_REFRESH_NUM NUMBER

created by refresh number
ACTION_CODE VARCHAR2 (30)
DML action code
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ITEM_PK
,      ITEM
,      ITEM_TYPE_ID
,      ITEM_TYPE
,      FORECAST_TYPE_ID
,      FORECAST_TYPE
,      BASE_UOM
,      AVG_DISCOUNT
,      LIST_PRICE
,      LAST_REFRESH_NUM
,      CREATED_BY_REFRESH_NUM
,      ACTION_CODE
FROM APPS.MSD_ITEM_MASTER_V;

Dependencies

[top of page]

APPS.MSD_ITEM_MASTER_V references the following:

SchemaAPPS
ViewFND_COMMON_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageMSD_COMMON_UTILITIES - show dependent code
SynonymMSD_ITEM_LIST_PRICE

APPS.MSD_ITEM_MASTER_V is not referenced by any database object