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.

APPS.OZF_TP_UTIL_QUERIES dependencies on OZF_QUOTA_ALERTS

Line 39: ozf_quota_alerts

35: IF p_alert_type = 'MTD' THEN
36: SELECT
37: MTD_ALERT INTO x_return_value
38: FROM
39: ozf_quota_alerts
40: WHERE
41: ship_to_site_use_id = p_object_id
42: AND report_date = p_report_date
43: AND resource_id = p_resource_id

Line 49: ozf_quota_alerts

45: ELSIF p_alert_type = 'QTD' THEN
46: SELECT
47: QTD_ALERT INTO x_return_value
48: FROM
49: ozf_quota_alerts
50: WHERE
51: ship_to_site_use_id = p_object_id
52: AND report_date = p_report_date
53: AND resource_id = p_resource_id

Line 59: ozf_quota_alerts

55: ELSIF p_alert_type = 'YTD' THEN
56: SELECT
57: YTD_ALERT INTO x_return_value
58: FROM
59: ozf_quota_alerts
60: WHERE
61: ship_to_site_use_id = p_object_id
62: AND report_date = p_report_date
63: AND resource_id = p_resource_id

Line 69: ozf_quota_alerts

65: ELSIF p_alert_type = 'BACK_ORDER' THEN
66: SELECT
67: BACK_ORDER_ALERT INTO x_return_value
68: FROM
69: ozf_quota_alerts
70: WHERE
71: ship_to_site_use_id = p_object_id
72: AND report_date = p_report_date
73: AND resource_id = p_resource_id

Line 79: ozf_quota_alerts

75: ELSIF p_alert_type = 'OUTSTAND_ORDER' THEN
76: SELECT
77: OUTSTAND_ORDER_ALERT INTO x_return_value
78: FROM
79: ozf_quota_alerts
80: WHERE
81: ship_to_site_use_id = p_object_id
82: AND report_date = p_report_date
83: AND resource_id = p_resource_id

Line 124: ozf_quota_alerts

120: IF p_alert_type = 'MTD' THEN
121: SELECT
122: MTD_ALERT INTO x_return_value
123: FROM
124: ozf_quota_alerts
125: WHERE
126: cust_account_id = p_cust_account_id
127: AND ship_to_site_use_id = p_site_use_id
128: AND report_date = p_report_date

Line 135: ozf_quota_alerts

131: ELSIF p_alert_type = 'QTD' THEN
132: SELECT
133: QTD_ALERT INTO x_return_value
134: FROM
135: ozf_quota_alerts
136: WHERE
137: cust_account_id = p_cust_account_id
138: AND ship_to_site_use_id = p_site_use_id
139: AND report_date = p_report_date

Line 146: ozf_quota_alerts

142: ELSIF p_alert_type = 'YTD' THEN
143: SELECT
144: YTD_ALERT INTO x_return_value
145: FROM
146: ozf_quota_alerts
147: WHERE
148: cust_account_id = p_cust_account_id
149: AND ship_to_site_use_id = p_site_use_id
150: AND report_date = p_report_date

Line 157: ozf_quota_alerts

153: ELSIF p_alert_type = 'BACK_ORDER' THEN
154: SELECT
155: BACK_ORDER_ALERT INTO x_return_value
156: FROM
157: ozf_quota_alerts
158: WHERE
159: cust_account_id = p_cust_account_id
160: AND ship_to_site_use_id = p_site_use_id
161: AND report_date = p_report_date

Line 168: ozf_quota_alerts

164: ELSIF p_alert_type = 'OUTSTAND_ORDER' THEN
165: SELECT
166: OUTSTAND_ORDER_ALERT INTO x_return_value
167: FROM
168: ozf_quota_alerts
169: WHERE
170: cust_account_id = p_cust_account_id
171: AND ship_to_site_use_id = p_site_use_id
172: AND report_date = p_report_date

Line 215: ozf_quota_alerts

211: IF p_alert_type = 'MTD' THEN
212: SELECT
213: MTD_ALERT INTO x_return_value
214: FROM
215: ozf_quota_alerts
216: WHERE
217: product_attribute = p_product_attribute
218: AND product_attr_value = p_product_attr_value
219: AND report_date = p_report_date

Line 226: ozf_quota_alerts

222: ELSIF p_alert_type = 'QTD' THEN
223: SELECT
224: QTD_ALERT INTO x_return_value
225: FROM
226: ozf_quota_alerts
227: WHERE
228: product_attribute = p_product_attribute
229: AND product_attr_value = p_product_attr_value
230: AND report_date = p_report_date

Line 237: ozf_quota_alerts

233: ELSIF p_alert_type = 'YTD' THEN
234: SELECT
235: YTD_ALERT INTO x_return_value
236: FROM
237: ozf_quota_alerts
238: WHERE
239: product_attribute = p_product_attribute
240: AND product_attr_value = p_product_attr_value
241: AND report_date = p_report_date

Line 248: ozf_quota_alerts

244: ELSIF p_alert_type = 'BACK_ORDER' THEN
245: SELECT
246: BACK_ORDER_ALERT INTO x_return_value
247: FROM
248: ozf_quota_alerts
249: WHERE
250: product_attribute = p_product_attribute
251: AND product_attr_value = p_product_attr_value
252: AND report_date = p_report_date

Line 259: ozf_quota_alerts

255: ELSIF p_alert_type = 'OUTSTAND_ORDER' THEN
256: SELECT
257: OUTSTAND_ORDER_ALERT INTO x_return_value
258: FROM
259: ozf_quota_alerts
260: WHERE
261: product_attribute = p_product_attribute
262: AND product_attr_value = p_product_attr_value
263: AND report_date = p_report_date