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


CREATE proc JMO_JTR_Self (
   @k_jtr_scdn      char(65),
   @k_jtr_name      char(65),
   @k_jtr_jno       char(5),
   @k_jtr_qual      char(5)
)
as
begin
   Select
      jtr_scdn,
      jtr_name,
      jtr_jno,
      jtr_qual,
      jtr_ows,
      jtr_ws,
      jtr_subu,
      jtr_subfile,
      jtr_abscd,
      jtr_avgtb,
      jtr_any,
      jtr_uxjno,
      jtr_erly,
      jtr_must,
      jtr_dedln,
      jtr_mxtim,
      jtr_avgt,
      jtr_flg1,
      jtr_bklog,
      jtr_sutyp,
      jtr_wstyp,
      jtr_desc,
      jtr_newpr,
      jtr_histc,
      jtr_fordate,
      jtr_erdt,
      jtr_mudt,
      jtr_dedt,
      jtr_mxdt,
      jtr_adate,
      jtr_vdate,
      jtr_sdate,
      jtr_edate,
      jtr_pdate,
      jtr_atime,
      jtr_vtime,
      jtr_stime,
      jtr_etime,
      jtr_ptime,
      jtr_dprty,
      jtr_comp,
      jtr_cput,
      jtr_pid,
      jtr_cc,
      jtr_hstat,
      jtr_rstat,
      jtr_flg3,
      jtr_flg4,
      jtr_flg5,
      jtr_cmrun,
      jtr_cmhld,
      jtr_cmrls,
      jtr_cmcnc,
      jtr_cmfrc,
      jtr_cmstr,
      jtr_cmcmp,
      jtr_luser,
      jtr_cal,
      jtr_cmsub,
      jtr_abcnt,
      jtr_alias,
      jtr_nodea,
      jtr_emsg,
      jtr_faill,
      jtr_failh,
      jtr_subp,
      jtr_domain,
      jtr_cycle,
      jtr_freq,
      jtr_count,
      jtr_qname,
      jtr_can
   From jmo_jtr
   Where
       jtr_scdn         = @k_jtr_scdn      and
       jtr_name         = @k_jtr_name      and
       jtr_jno          = @k_jtr_jno       and
       jtr_qual         = @k_jtr_qual
   Order by
       jtr_scdn,
       jtr_name,
       jtr_jno,
       jtr_qual
end
GO
GRANT EXECUTE ON  [dbo].[JMO_JTR_Self] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_JTR_Self] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_JTR_Self] TO [uniadmin]
GO