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

VIEW: APPS.MSD_ITEM_MASTER_LB_V

Object Details
Object Name: MSD_ITEM_MASTER_LB_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


For Liability Analysis, 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
DEMAND_PLAN_ID NUMBER
Yes Demand Plan Id
ITEM_PK NUMBER
Yes Item Key
FORECAST_TYPE_ID NUMBER

ATO Forecast Control Type Id
AVG_DISCOUNT NUMBER

Average Discount Value
BASE_UOM VARCHAR2 (4000)
Base Uom
Query Text

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


SELECT DEMAND_PLAN_ID
,      ITEM_PK
,      FORECAST_TYPE_ID
,      AVG_DISCOUNT
,      BASE_UOM
FROM APPS.MSD_ITEM_MASTER_LB_V;

Dependencies

[top of page]

APPS.MSD_ITEM_MASTER_LB_V references the following:

SchemaAPPS
PL/SQL PackageMSD_COMMON_UTILITIES_LB - show dependent code
SynonymMSD_DEMAND_PLANS
SynonymMSD_LEVEL_VALUES_LB

APPS.MSD_ITEM_MASTER_LB_V is not referenced by any database object