create or replace view vw_jy_bbcj00_fqpdjh as
select
('请'||a.dlh000||'号'||substrb(SF_XT_GETPDJHBRXM(a.BRXM00,'0'),1,20)||'到'||a.ckmc00) as dsxsxx,
('请'||a.dlh000||'号'||a.brxm00||'到'||a.ckmc00) as jhyyxx,
  a.DLH000||'号' DLH000,
  a.CKMC00,
  a.JHBZ00,
  a.djsj00,
  decode(JHBZ00,'1','请到窗口！','3','请准备！','7','请到窗口！','8,','请准备！') ZT0000,
  decode(a.BRXM00,'0','',substrb(SF_XT_GETPDJHBRXM(a.BRXM00,'0'),1,20)) BRXM00,
  a.CYCKBH
  from JY_PDJHB0 a
  where a.jhbz00 in ('1','3','7','8')
  and a.phrq00=to_char(sysdate,'YYYYMMDD')
  order by decode(a.jhbz00,'7','1',a.JHBZ00),a.djsj00 desc;