APPS.IBE_OM_INTEGRATION_GRP SQL Statements

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

Line: 46

         SELECT order_number, org_id
         FROM oe_order_headers_all
         WHERE header_id = p_order_header_id;

Line: 51

         SELECT fnd.customer_id
         FROM fnd_user fnd,
              oe_order_headers_all oe
         WHERE oe.header_id = p_order_header_id
         AND   oe.created_by = fnd.user_id;

Line: 58

         SELECT meaning
	    FROM wf_lookups
	    WHERE lookup_type = 'OE_RMA_REJECTION_REASON'
	    AND lookup_code = p_reject_reason_code;