Skip to content

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

VIEW: APPS.OZF_BASELINE_SALES_V

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

View Type

A Business Intelligence System view


This view shows baseline sales in Amount or in Quantity, from various 3rd party data sources


[View Source]

Columns
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
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_SALES
FROM APPS.OZF_BASELINE_SALES_V;

Dependencies

[top of page]

APPS.OZF_BASELINE_SALES_V references the following:

SchemaAPPS
TableOZF_BASELINE_SALES_MV
PL/SQL PackageOZF_TP_UTIL_QUERIES - show dependent code
APPS.OZF_BASELINE_SALES_V is referenced by following:

SchemaAPPS
Package BodyOZF_CUST_FACTS_PVT - show dependent code
Package BodyOZF_FORECAST_UTIL_PVT - show dependent code