VIEW: APPS.JTF_ORG_CONTACTS_V

Source

View Text - Preformatted

SELECT rank, job_title, department, department_code from hz_org_contacts where department_code is not null or rank is not null or job_title_code is not null

View Text - HTML Formatted

SELECT RANK
, JOB_TITLE
, DEPARTMENT
, DEPARTMENT_CODE
FROM HZ_ORG_CONTACTS
WHERE DEPARTMENT_CODE IS NOT NULL OR RANK IS NOT NULL OR JOB_TITLE_CODE IS NOT NULL