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_BACKDATE_PVT dependencies on OZF_OFFERS

Line 1328: FROM ozf_offers o,

1324: l_offer_type VARCHAR2(30);
1325:
1326: CURSOR get_offer_type IS
1327: SELECT o.offer_type
1328: FROM ozf_offers o,
1329: ozf_offer_adjustments_vl a
1330: WHERE a.offer_adjustment_id = p_offer_adjustment_id
1331: and a.list_header_id = o.qp_list_header_id ;
1332:

Line 1684: FROM ozf_offer_adjustment_products a , ozf_offer_adjustments_b b, ozf_offers c

1680: , product_attribute
1681: , product_attr_value
1682: , apply_discount_flag
1683: , include_volume_flag
1684: FROM ozf_offer_adjustment_products a , ozf_offer_adjustments_b b, ozf_offers c
1685: WHERE a.offer_adjustment_id = b.offer_adjustment_id
1686: AND b.list_header_id = c.qp_list_header_id
1687: AND a.offer_adjustment_id = p_adjustment_id;
1688:

Line 1753: FROM ozf_offer_adjustment_products a, ozf_offer_discount_products b , ozf_offer_discount_lines c , ozf_offers d , ozf_offer_adjustments_b e

1749: , c.discount_type
1750: , e.effective_date
1751: , a.apply_discount_flag
1752: , a.include_volume_flag
1753: FROM ozf_offer_adjustment_products a, ozf_offer_discount_products b , ozf_offer_discount_lines c , ozf_offers d , ozf_offer_adjustments_b e
1754: WHERE a.offer_discount_line_id = c.offer_discount_line_id
1755: AND b.offer_discount_line_id = c.offer_discount_line_id
1756: AND a.product_context = b.product_context
1757: AND a.product_attribute = b.product_attribute