eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

MATERIALIZED VIEW: APPS.OZF_BASELINE_SALES_MV

Object Details

Object Name:	OZF_BASELINE_SALES_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	OZF_BASELINE_SALES_MV
Updatable:	N
Rewrite Enabled:	N
Rewrite Capability:	TEXTMATCH
Refresh Mode:	DEMAND
Refresh Method:	FORCE
Build Mode:	IMMEDIATE
Fast Refreshable:	NO

MV Log Dependencies:


OZF_TIME_DAY

[View Source Query]

Columns

Name	Datatype	Length	Mandatory	Comments
DATA_SOURCE	VARCHAR2	(30)	Yes	Data Source Identifier: Identifies the source of third party Baseline Sales data.
MARKET_TYPE	VARCHAR2	(30)	Yes	Customer Identifier: Valid value is SHIP_TO for a Ship To site of the customer.
MARKET_ID	NUMBER		Yes	Customer Identifier: Site Use Identifier for the Ship To site of the customer
ITEM_LEVEL	VARCHAR2	(30)	Yes	Inventory Item Identifier: Valid value is PRICING_ATTRIBUTE1 for a inventory item.
ITEM_ID	NUMBER		Yes	Inventory Item Identifier: Valid value is inventory_item_id for a inventory item.
TIME_ID	NUMBER			Time dimension Identifier : This column along with the PERIOD_TYPE_ID column uniquely identifies time dimension.
PERIOD_TYPE_ID	NUMBER			Period Type Identifier: Valid values are 1 for Day, 16 for Week, 32 for Month, 64 for Quarter and 128 for Year.
BASELINE_QTY	NUMBER			Baseline Sales Quantity in the Unit of Measure specified for the profile OZF: Common Unit of Measure for Trade Management
BASELINE_AMT	NUMBER			Baseline Sales Quantity in the currency specified for the profile OZF: Common Currency for Trade Management

Query Text

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


SELECT DATA_SOURCE
,      MARKET_TYPE
,      MARKET_ID
,      ITEM_LEVEL
,      ITEM_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      BASELINE_QTY
,      BASELINE_AMT
FROM APPS.OZF_BASELINE_SALES_MV;

Dependencies

[top of page]

APPS.OZF_BASELINE_SALES_MV references the following:

APPS: OZF_BASELINE_SALES_FACTS; OZF_BASELINE_SALES_MV; OZF_TIME_DAY
OZF: OZF_BASELINE_SALES_FACTS; OZF_TIME_DAY

APPS.OZF_BASELINE_SALES_MV is not referenced by any database object