SELECT to_char(fo.last_mod_dttm,'Dy, DD Mon yyyy hh:mi:ss') as postdate, fo.order_id orderid, fo.order_web_job_title webjobtitle, fo.order_web_city webcity, fo.order_web_state, fo.org_unit_id officeid, fo.job_category_description as jobcategory, CASE WHEN (fo.order_type_description = 'Any of These') THEN 'Any' ELSE fo.order_type_description END assignmenttype, fo.industry_type_description description, SUBSTR(fo.org_unit_attr_value_dept, 1, 5), To_char(LPad(fo.order_web_job_description, 0)) as webjobdescription, fo.order_web_base_min webbasemin, fo.order_web_base_max webbasemax, fo.account_type_description as position_type, fo.order_web_state_name as state_name FROM SYSADM.fo_job_board_order fo WHERE fo.expiration_dttm > sysdate AND fo.job_board_url = 'http://www.rphonthego.com' AND Lower(fo.job_board_order_status) in ('posted', 'post pending', 'resubmit pending', 'resubmitted') AND Lower(fo.order_status_description) in ('open', 'hold', 'recurring', 'recruiting', 'active') ORDER BY fo.last_mod_dttm desc
Pharmacy Jobs and Careers | RPh on the Go
RPh on the Go Logo
800.553.7359
Connect:
Twitter
LinkedIn
FaceBook
RSS
Apply Now

Pharmacy Jobs

More jobs. More opportunity.

Current Search:

Not Specified
Not Specified
Not Specified
Showing Jobs 1051-1031 of 1031
© 2019 RPh on the Go, All Rights Reserved.