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_CHECK_DUP_PROD_PVT dependencies on OZF_OFFER_DISCOUNT_PRODUCTS

Line 152: FROM ozf_offer_discount_products

148: CURSOR c_products(p_pbh_line_id NUMBER, p_excluder_flag VARCHAR2) IS
149: SELECT product_context,
150: product_attribute,
151: product_attr_value
152: FROM ozf_offer_discount_products
153: WHERE offer_id = p_offer_id
154: AND offer_discount_line_id = p_pbh_line_id
155: AND excluder_flag = p_excluder_flag;
156:

Line 160: FROM ozf_offer_discount_products

156:
157:
158: CURSOR c_products_count(p_pbh_line_id NUMBER, p_excluder_flag VARCHAR2) IS
159: SELECT COUNT(*)
160: FROM ozf_offer_discount_products
161: WHERE offer_id = p_offer_id
162: AND offer_discount_line_id = p_pbh_line_id
163: AND excluder_flag = p_excluder_flag;
164: