/****** Object:  Stored Procedure dbo.JMO_TRT1_Self    Script Date: 12/1/2005 11:49:37 PM ******/


CREATE proc JMO_TRT1_Self (
   @k_trt_trev      char(9),
   @k_trt_trid      char(65),
   @k_trt_qual      char(5)
)
as
begin
   Select
       trt_trev,
       trt_trid,
       trt_qual,
       trt_apc7,
       trt_desc,
       trt_jnam,
       trt_usid,
       trt_stan,
       trt_faill,
       trt_failh,
       trt_file,
       trt_ustat,
       trt_jobn,
       trt_scdn,
       trt_bklog,                     
       trt_cal,                     
       trt_fdate,                            
       trt_tstat                  
   From jmo_trt1
   Where
       trt_trev         = @k_trt_trev      and
       trt_trid         = @k_trt_trid      and
       trt_qual         = @k_trt_qual
   Order by
       trt_trev,
       trt_trid,
       trt_qual
end
GO
GRANT EXECUTE ON  [dbo].[JMO_TRT1_Self] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_TRT1_Self] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_TRT1_Self] TO [uniadmin]
GO