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_OFFER_MARKET_OPTIONS_PVT dependencies on OZF_OFFER_DISCOUNT_LINES

Line 11: SELECT count(distinct(volume_type)) FROM ozf_offer_discount_lines

7: FUNCTION get_combine_discounts(p_offer_id IN NUMBER)
8: RETURN VARCHAR2
9: IS
10: CURSOR c_volume_type_cnt (p_offer_id NUMBER) IS
11: SELECT count(distinct(volume_type)) FROM ozf_offer_discount_lines
12: WHERE offer_id = p_offer_id
13: AND tier_type = 'PBH';
14: l_vol_type_cnt NUMBER:=0;
15:

Line 17: SELECT count(distinct(uom_code)) FROM ozf_offer_discount_lines

13: AND tier_type = 'PBH';
14: l_vol_type_cnt NUMBER:=0;
15:
16: CURSOR c_uom_code_cnt(p_offer_id NUMBER) IS
17: SELECT count(distinct(uom_code)) FROM ozf_offer_discount_lines
18: WHERE offer_id = p_offer_id
19: AND tier_type = 'PBH';
20: l_uom_code_cnt NUMBER := 0;
21: