DBA Data[Home] [Help]

APPS.OE_REASONS_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 46: FROM oe_price_adjustments WHERE price_adjustment_id = p_entity_id;

42: SELECT header_id INTO l_header_id
43: FROM oe_order_lines_all WHERE line_id = p_entity_id;
44: ELSIF p_entity_code IN ('HEADER_ADJ','LINE_ADJ') THEN
45: SELECT header_id INTO l_header_id
46: FROM oe_price_adjustments WHERE price_adjustment_id = p_entity_id;
47: ELSIF p_entity_code IN ('HEADER_SCREDIT','LINE_SCREDIT') THEN
48: SELECT header_id INTO l_header_id
49: FROM oe_sales_credits WHERE sales_credit_id = p_entity_id;
50: ELSIF p_entity_code = 'BLANKET_HEADER' THEN