Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
select 
  count (PIN) 
from VIEWID 
where Issue='Unconfirmed Sign ON' 
--and NUMORGID=:P_CLIENTID
Info

Note: VIEWID should be substituted with the crew list view ID: e.g PW001SRV51 . The crew list view ID can be checked in the General Codes.

...