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: OZF.OZF_QUOTA_ALERTS

Object Details

Object Name:	OZF_QUOTA_ALERTS
Object Type:	TABLE
Owner:	OZF
FND Design Data:	OZF.OZF_QUOTA_ALERTS
Subobject Name:
Status:	VALID

This table stores all the alerts that need to be raised on the Account Manager Dashboard

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_QUOTA_ALERTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUOTA_ALERT_ID
OZF_QUOTA_ALERTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPORT_DATE RESOURCE_ID
OZF_QUOTA_ALERTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ALERT_FOR CUST_ACCOUNT_ID SHIP_TO_SITE_USE_ID
OZF_QUOTA_ALERTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ALERT_FOR PRODUCT_ATTRIBUTE PRODUCT_ATTR_VALUE

Columns

Name	Datatype	Length	Mandatory	Comments
QUOTA_ALERT_ID	NUMBER		Yes	Unique Identifier
REPORT_DATE	DATE			Date for which the alerts are populated
RESOURCE_ID	NUMBER			Resource Identifier
ALERT_FOR	VARCHAR2	(30)		Object for which the alert is raised. Account or Product
CUST_ACCOUNT_ID	NUMBER			Customer Account identifier
SHIP_TO_SITE_USE_ID	NUMBER			Ship to site identifier
PRODUCT_ATTRIBUTE	VARCHAR2	(30)		Product attribute
PRODUCT_ATTR_VALUE	NUMBER			Product attribute Identifier
MTD_ALERT	VARCHAR2	(30)		Alter for Month to date
QTD_ALERT	VARCHAR2	(30)		Alert for quarter to date
YTD_ALERT	VARCHAR2	(30)		Alert for Year to date
BACK_ORDER_ALERT	VARCHAR2	(30)		Alert for Back order
OUTSTAND_ORDER_ALERT	VARCHAR2	(30)		Alert for Outstanding orders

Query Text

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


SELECT QUOTA_ALERT_ID
,      REPORT_DATE
,      RESOURCE_ID
,      ALERT_FOR
,      CUST_ACCOUNT_ID
,      SHIP_TO_SITE_USE_ID
,      PRODUCT_ATTRIBUTE
,      PRODUCT_ATTR_VALUE
,      MTD_ALERT
,      QTD_ALERT
,      YTD_ALERT
,      BACK_ORDER_ALERT
,      OUTSTAND_ORDER_ALERT
FROM OZF.OZF_QUOTA_ALERTS;

Dependencies

[top of page]

OZF.OZF_QUOTA_ALERTS does not reference any database object

OZF.OZF_QUOTA_ALERTS is referenced by following:

OZF: OZF_QUOTA_ALERTS#