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_VOLUME_OFFER_DISC_PVT dependencies on OZF_OFFR_DISC_STRUCT_NAME_TL

Line 98: SELECT 1 FROM OZF_OFFR_DISC_STRUCT_NAME_TL tl, ozf_offr_disc_struct_name_b b, ozf_offer_discount_lines l

94: CURSOR c_name(p_name IN VARCHAR2 , p_offer_id IN NUMBER)
95: IS
96: SELECT 1 FROM DUAL WHERE EXISTS
97: (
98: SELECT 1 FROM OZF_OFFR_DISC_STRUCT_NAME_TL tl, ozf_offr_disc_struct_name_b b, ozf_offer_discount_lines l
99: WHERE b.offr_disc_struct_name_id = tl.offr_disc_struct_name_id
100: AND tl.LANGUAGE = userenv('LANG')
101: AND l.offer_discount_line_id = b.offer_discount_line_id
102: AND tl.discount_table_name = p_name

Line 1734: FROM OZF_OFFER_DISCOUNT_LINES a, ozf_offr_disc_struct_name_b b, ozf_offr_disc_struct_name_tl tl

1730: , a.uom_code
1731: , tl.discount_table_name
1732: , tl.description
1733: , a.tier_level
1734: FROM OZF_OFFER_DISCOUNT_LINES a, ozf_offr_disc_struct_name_b b, ozf_offr_disc_struct_name_tl tl
1735: WHERE a.offer_discount_line_id = b.offer_discount_line_id
1736: AND b.offr_disc_struct_name_id = tl.offr_disc_struct_name_id
1737: AND tl.language = userenv('LANG')
1738: AND a.offer_discount_line_id = p_offer_discount_line_id;