DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on OE_DISCOUNTS

Line 687: oe_discounts d

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
691: AND dln.discount_line_id = adj.discount_line_id

Line 751: oe_discounts d

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
755: AND dln.discount_line_id = adj.discount_line_id