APPS.CTO_PUBLIC_UTILITY_PK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 70

		select ato_line_id, ordered_quantity
		into   config_ato_line_id, config_ordered_qty
		from   oe_order_lines_all
		where  line_id = p_config_line_id;

Line: 88

	select nvl( sum(l.UNIT_SELLING_PRICE * nvl(ORDERED_QUANTITY,0)) / config_ordered_qty , 0),
	       nvl((sum(l.UNIT_SELLING_PRICE * nvl(ORDERED_QUANTITY,0)) / config_ordered_qty) * p_quantity, 0),
	       max(h.TRANSACTIONAL_CURR_CODE)
	into   x_unit_selling_price,
	       x_qty_selling_price,
	       x_currency_code
	from   oe_order_lines_all l,
	       oe_order_headers_all h
	where  l.ato_line_id = decode(p_config_line_id, null, p_model_line_id, config_ato_line_id)
	and    l.header_id = h.header_id;