[Home] [Help] [Dependency Information]
Object Name: | OZF_BASELINE_SALES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view shows baseline sales in Amount or in Quantity, from various 3rd party data sources
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATA_SOURCE | VARCHAR2 | (30) | Yes | Data Source identifier: Look Code for 3rd Party Data Source as seeded in the extensible lookup. |
MARKET_TYPE | VARCHAR2 | (30) | Yes | Customer identifier |
MARKET_ID | NUMBER | Yes | Customer identifier like ship to site_use_id | |
ITEM_LEVEL | VARCHAR2 | (30) | Yes | Item identifier like PRICING_ATTRIBUTE1 |
ITEM_ID | NUMBER | Yes | Item identifier like inventory_item_id | |
TIME_ID | NUMBER | Time dimension Identifier | ||
PERIOD_TYPE_ID | NUMBER | Time dimension Identifier | ||
BASELINE_SALES | NUMBER | Baseline Sales in Quantity or in Amount |
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_SALES
FROM APPS.OZF_BASELINE_SALES_V;
|
|
|