Process Queue Entries

				
					select r.obj_2_id          "BGP"
      ,p.prcq_id           "ID"
      ,substr(i.name,1,40) "Process Queue" 
      ,substr(s.intl_id || ' (' || p.prcq_status_id  || ')',1,20) "Status"
      ,p.*
  from k.code_prcq_status  s
      ,k.obj_name_intl     i
      ,k.obj_rel           r
      ,k.prcq              p
  where  1=1
  --and  p.prcq_status_id in (9)  
  -- 1 hold 2 ready first 3 ready retry 4 processing 5 done 6 done idle 7 ready manual 9 failed
    and  i.obj_id       (+)= p.prcq_id
    and  r.obj_1_id     (+)= p.prcq_id
    and  s.id           (+)= p.prcq_status_id
    and  p.prcq_id = 833 -- 
  --and  p.bu_id = 6
order by timestamp_ins desc
;