APPS.OE_RLM_WF SQL Statements

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

Line: 57

   /* 	SELECT header_id
	INTO l_header_id
      	FROM oe_order_lines
       	WHERE line_id = l_line_id; */

Line: 70

	   SELECT PARENT.ACTIVITY_ITEM_TYPE, PARENT.ACTIVITY_NAME
	   INTO l_wf_item, l_wf_activity
	   FROM WF_ITEM_ACTIVITY_STATUSES IAS,
	        WF_PROCESS_ACTIVITIES CHILD,
	        WF_PROCESS_ACTIVITIES PARENT
	   WHERE CHILD.INSTANCE_ID = actid
	   AND CHILD.PROCESS_ITEM_TYPE = PARENT.ACTIVITY_ITEM_TYPE
	   AND CHILD.PROCESS_NAME = PARENT.ACTIVITY_NAME
	   AND PARENT.INSTANCE_ID = IAS.PROCESS_ACTIVITY
	   AND IAS.ITEM_TYPE = itemtype
	   AND IAS.ITEM_KEY = itemkey;

Line: 83

	   SELECT nvl(AUTHORIZED_TO_SHIP_FLAG, 'Y')
		into l_authorized_to_ship_flag
		FROM oe_order_lines
	    WHERE line_id = l_line_id;