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]

TABLE: APPS.OZF_BASELINE_SALES_MV

Object Details

Object Name:	OZF_BASELINE_SALES_MV
Object Type:	TABLE
Owner:	APPS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_BASELINE_SALES_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	DATA_SOURCE TIME_ID MARKET_TYPE MARKET_ID ITEM_LEVEL ITEM_ID

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 does not reference any database object

APPS.OZF_BASELINE_SALES_MV is referenced by following:

APPS: OZF_BASELINE_SALES_MV; OZF_BASELINE_SALES_V