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 1642: FROM ozf_volume_offer_tiers

1638: WHERE qp_list_header_id = p_source_object_id;
1639:
1640: CURSOR c_vol_offer_tiers IS
1641: SELECT *
1642: FROM ozf_volume_offer_tiers
1643: WHERE qp_list_header_id = p_source_object_id;
1644: l_vol_offr_tier_rec ozf_vol_offr_pvt.vol_offr_tier_rec_type;
1645:
1646: CURSOR c_act_products IS

Line 1706: FROM ozf_volume_offer_tiers

1702:
1703: -- bug 3747303
1704: CURSOR c_vol_off_discount IS
1705: SELECT discount_type_code, discount
1706: FROM ozf_volume_offer_tiers
1707: WHERE qp_list_header_id = p_source_object_id
1708: AND tier_value_from =
1709: (SELECT MIN(tier_value_from)
1710: FROM ozf_volume_offer_tiers

Line 1710: FROM ozf_volume_offer_tiers

1706: FROM ozf_volume_offer_tiers
1707: WHERE qp_list_header_id = p_source_object_id
1708: AND tier_value_from =
1709: (SELECT MIN(tier_value_from)
1710: FROM ozf_volume_offer_tiers
1711: WHERE qp_list_header_id = p_source_object_id);
1712: l_discount_type VARCHAR2(30);
1713: l_discount NUMBER;
1714: l_offer_id NUMBER;