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_ORDER_SALES_SUMRY_MV

Object Details

Object Name:	OZF_ORDER_SALES_SUMRY_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_ORDER_SALES_SUMRY_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID SHIP_TO_SITE_USE_ID INVENTORY_ITEM_ID
OZF_ORDER_SALES_SUMRY_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID SOLD_TO_CUST_ACCOUNT_ID INVENTORY_ITEM_ID

Columns

Name	Datatype	Comments
TIME_ID	NUMBER	Time dimention Identifier. This column along with the PERIOD_TYPE_ID column uniquely identify a time dimention.
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.
SOLD_TO_CUST_ACCOUNT_ID	NUMBER	Customer Account Identifier
SHIP_TO_SITE_USE_ID	NUMBER	Site Use Identifier for the Ship To site of the customer
BILL_TO_SITE_USE_ID	NUMBER	Site Use Identifier for the Bill To site of the customer
INVENTORY_ITEM_ID	NUMBER	Inventory Item Identifier
SALES_QTY	NUMBER	Actual Shipped Quantity in the Unit of Measure specified for the profile OZF: Unit of Measure for Quota Allocation
SALES_AMT	NUMBER	Value of Actual Shipped Quantity in the currency specified for the profile OZF: Currency for Quota Allocation

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TIME_ID
,      PERIOD_TYPE_ID
,      SOLD_TO_CUST_ACCOUNT_ID
,      SHIP_TO_SITE_USE_ID
,      BILL_TO_SITE_USE_ID
,      INVENTORY_ITEM_ID
,      SALES_QTY
,      SALES_AMT
FROM APPS.OZF_ORDER_SALES_SUMRY_MV;

Dependencies

[top of page]

APPS.OZF_ORDER_SALES_SUMRY_MV does not reference any database object

APPS.OZF_ORDER_SALES_SUMRY_MV is referenced by following:

APPS: OZF_FORECAST_UTIL_PVT - show dependent code; OZF_FUND_ALLOCATIONS_PVT - show dependent code; OZF_ORDER_SALES_SUMRY_MV; OZF_ORDER_SALES_V