APPS.OE_1019PC2_LINE_RTLREJD SQL Statements

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

Line: 21

   SELECT count(*) 
   FROM wf_item_activity_statuses  w, wf_process_activities wpa
   WHERE w.item_type     = l_wf_item_type
   AND w.process_activity = wpa.instance_id
   AND wpa.activity_name = l_wf_activity_name
   AND w.activity_status = l_wf_activity_status_code
   AND w.activity_result_code = l_wf_activity_result_code
   AND   w.item_key IN 
          ( SELECT  a.LINE_ID || ''
                         FROM OE_AK_ORDER_LINES_V a 
  WHERE   a.BLANKET_NUMBER =  OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER
  AND   a.BLANKET_LINE_NUMBER =  OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER
                         )
;

Line: 37

   SELECT count(*) 
   FROM OE_AK_ORDER_LINES_V a 
  WHERE   a.BLANKET_NUMBER =  OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER
  AND   a.BLANKET_LINE_NUMBER =  OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER
;