SELECT position_id, business_group_id, date_effective, date_end, name, job_id, organization_id from hr_positions_f WHERE (status is NULL or status <> 'INVALID')
View Text - HTML Formatted
SELECT POSITION_ID , BUSINESS_GROUP_ID , DATE_EFFECTIVE , DATE_END , NAME , JOB_ID , ORGANIZATION_ID FROM HR_POSITIONS_F WHERE (STATUS IS NULL OR STATUS <> 'INVALID')