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.OE_DELAYED_REQUESTS_UTIL dependencies on OE_DISCOUNT_LINES

Line 686: oe_discount_lines dln,

682:
683: SELECT count(d.name)
684: INTO l_count
685: FROM oe_price_adjustments adj,
686: oe_discount_lines dln,
687: oe_discounts d
688: WHERE adj.header_id = l_header_id
689: AND Nvl(adj.line_id, l_line_id) = l_line_id
690: AND d.discount_id = adj.discount_id

Line 723: FROM oe_discount_lines dln

719: WHERE adj.header_id = l_header_id
720: AND Nvl(adj.line_id, l_line_id) = l_line_id
721: AND exists
722: (SELECT 'fixed_price'
723: FROM oe_discount_lines dln
724: WHERE dln.discount_line_id = l_discount_line_id
725: AND dln.price IS NOT NULL)
726: AND ROWNUM = 1;
727:

Line 750: oe_discount_lines dln,

746:
747: SELECT d.name
748: INTO l_fixed_price
749: FROM oe_price_adjustments adj,
750: oe_discount_lines dln,
751: oe_discounts d
752: WHERE adj.header_id = l_header_id
753: AND Nvl(adj.line_id, l_line_id) = l_line_id
754: AND d.discount_id = adj.discount_id