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_COPY_OFFER_PVT dependencies on OZF_VOLUME_OFFER_TIERS

Line 1674: FROM ozf_volume_offer_tiers

1670: WHERE qp_list_header_id = p_source_object_id;
1671:
1672: CURSOR c_vol_offer_tiers IS
1673: SELECT *
1674: FROM ozf_volume_offer_tiers
1675: WHERE qp_list_header_id = p_source_object_id;
1676: l_vol_offr_tier_rec ozf_vol_offr_pvt.vol_offr_tier_rec_type;
1677:
1678: CURSOR c_act_products IS

Line 1738: FROM ozf_volume_offer_tiers

1734:
1735: -- bug 3747303
1736: CURSOR c_vol_off_discount IS
1737: SELECT discount_type_code, discount
1738: FROM ozf_volume_offer_tiers
1739: WHERE qp_list_header_id = p_source_object_id
1740: AND tier_value_from =
1741: (SELECT MIN(tier_value_from)
1742: FROM ozf_volume_offer_tiers

Line 1742: FROM ozf_volume_offer_tiers

1738: FROM ozf_volume_offer_tiers
1739: WHERE qp_list_header_id = p_source_object_id
1740: AND tier_value_from =
1741: (SELECT MIN(tier_value_from)
1742: FROM ozf_volume_offer_tiers
1743: WHERE qp_list_header_id = p_source_object_id);
1744: l_discount_type VARCHAR2(30);
1745: l_discount NUMBER;
1746: l_offer_id NUMBER;