APPS.OE_RMA_WF SQL Statements

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

Line: 172

    oe_debug_pub.add('Calling Update Row', 2);

Line: 173

        OE_Line_Util.Update_Row (l_x_line_rec);

Line: 278

  		SELECT DECODE(l.shippable_flag,NULL,m.shippable_item_flag ,
				    l.shippable_flag),
			  mtl_transactions_enabled_flag
		INTO l_shippable_flag,l_transactable_flag
  		FROM mtl_system_items m, oe_order_lines_all l
  		WHERE m.inventory_item_id = l.inventory_item_id
  		AND l.line_id = to_number(itemkey)
  		AND m.organization_id = l.ship_from_org_id;

Line: 375

          	    OE_Order_WF_Util.Update_Flow_Status_Code
                    (p_line_id               =>   to_number(itemkey),
                     p_flow_status_code      =>   'AWAITING_RETURN',
                     x_return_status         =>   l_return_status
                     );

Line: 391

                   UPDATE OE_ORDER_LINES_ALL
			    SET flow_status_code = 'AWAITING_RETURN'
			    WHERE line_id = to_number(itemkey);