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

TABLE: OZF.OZF_BASELINE_SALES_MV

Object Details
Object Name: OZF_BASELINE_SALES_MV
Object Type: TABLE
Owner: OZF
FND Design Data: TableOZF.OZF_BASELINE_SALES_MV
Subobject Name:
Status: VALID


Summary Table for Baseline Sales


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
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 OZF.OZF_BASELINE_SALES_MV;

Dependencies

[top of page]

OZF.OZF_BASELINE_SALES_MV does not reference any database object

OZF.OZF_BASELINE_SALES_MV is referenced by following:

SchemaOZF
ViewOZF_BASELINE_SALES_MV#