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 687: oe_discount_lines dln,

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

Line 724: FROM oe_discount_lines dln

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

Line 751: oe_discount_lines dln,

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