APPS.RCV_OE_RMA_RECEIPTS_SV SQL Statements

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

Line: 56

   SELECT EARLIEST_ACCEPTABLE_DATE,
	  LATEST_ACCEPTABLE_DATE
   INTO   x_earliest_acceptable_date,
	  x_latest_acceptable_date
   FROM   oe_order_lines_all --1561179
   WHERE  header_id = x_oe_order_header_id
   AND    line_id = x_oe_order_line_id;

Line: 125

	select number_value
        into x_new_org_id
        from wf_item_attribute_values
        where item_key = to_char(X_oe_order_line_id)
        and item_type='OEOL'
        and name='ORG_ID';

Line: 132

        select org_id
        into x_new_org_id
        from oe_order_lines_all
        where line_id = X_oe_order_line_id;