APPS.OE_ORDER_UPGRADE_UTIL SQL Statements

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

Line: 23

     SELECT NVL(MAX(old_line_id), -99)
	  INTO l_so_line_id
	  FROM OE_UPGRADE_LOG_V
      WHERE new_line_ID = p_entity_key;

Line: 32

    l_sql := 'SELECT '||p_SColumn_name||' FROM so_lines_all WHERE line_id = :so_line_id';

Line: 38

  l_sql := 'SELECT '||p_SColumn_name||' FROM so_headers_all WHERE header_id = :hdr_id';

Line: 59

  SELECT nvl(invoice_interface_status_code, 'NO')
  INTO l_invoice_status_code
  FROM oe_order_lines_all
  WHERE line_id = p_line_id;

Line: 139

      SELECT shipped_quantity
      INTO l_shipped_quantity
      FROM oe_order_lines_all
      WHERE line_id=p_line_id;

Line: 223

	select DISTINCT responsibility_id,
	responsibility_application_id application_id
	from fnd_user_resp_groups
	where user_id = l_user_id;

Line: 234

    SELECT nvl(multi_org_flag, 'N')
    INTO l_multi_org_flag
    FROM fnd_product_groups;