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_LINES

Line 136: FROM ozf_offer_discount_lines

132: IS
133:
134: CURSOR c_pbh_lines IS
135: SELECT offer_discount_line_id
136: FROM ozf_offer_discount_lines
137: WHERE offer_id = p_offer_id
138: AND tier_type = 'PBH'
139: AND tier_level = 'HEADER';
140:

Line 143: FROM ozf_offer_discount_lines

139: AND tier_level = 'HEADER';
140:
141: CURSOR c_pbh_lines_count IS
142: SELECT COUNT(*)
143: FROM ozf_offer_discount_lines
144: WHERE offer_id = p_offer_id
145: AND tier_type = 'PBH'
146: AND tier_level = 'HEADER';
147: