[Home] [Help]
VIEW: APPS.OZF_BASELINE_SALES_V
Source
View Text - Preformatted
SELECT DATA_SOURCE, MARKET_TYPE, MARKET_ID, ITEM_LEVEL, ITEM_ID, TIME_ID, PERIOD_TYPE_ID, DECODE(OZF_TP_UTIL_QUERIES.GET_QUOTA_UNIT, 'Q', BASELINE_QTY, BASELINE_AMT) BASELINE_SALES FROM OZF_BASELINE_SALES_MV
View Text - HTML Formatted
SELECT DATA_SOURCE
, MARKET_TYPE
, MARKET_ID
, ITEM_LEVEL
, ITEM_ID
, TIME_ID
, PERIOD_TYPE_ID
, DECODE(OZF_TP_UTIL_QUERIES.GET_QUOTA_UNIT
, 'Q'
, BASELINE_QTY
, BASELINE_AMT) BASELINE_SALES
FROM OZF_BASELINE_SALES_MV