DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on OE_DISCOUNTS

Line 688: oe_discounts d

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

Line 752: oe_discounts d

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