APPS.INV_MGD_MVT_PURGE_TRANS SQL Statements

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

Line: 105

  DELETE FROM MTL_MOVEMENT_STATISTICS
  WHERE  entity_org_id      = p_legal_entity_id
   AND   upper(stat_type)   like nvl(upper(p_stat_type),'%')
   AND   upper(usage_type)  like nvl(upper(p_usage_type),'%')
   AND   upper(zone_code)   like nvl(upper(p_zone_code),'%')
   AND   upper(period_name) =    upper(p_period_name)
   AND   upper(document_source_type)
                like nvl(upper(p_document_source_type),'%')
   AND   (MOVEMENT_STATUS IN ('F','I','X')
   OR  EDI_SENT_FLAG      = 'Y')
 ;

Line: 138

      , 'Update_Movement_Status'
      );

Line: 151

      , 'Update_Movement_Status'
      );