SELECT DISTINCT JD.SEGMENT2 FROM PER_JOBS J , PER_JOB_DEFINITIONS JD , PA_IMPLEMENTATIONS I WHERE J.BUSINESS_GROUP_ID = I.BUSINESS_GROUP_ID AND J.JOB_DEFINITION_ID = JD.JOB_DEFINITION_ID
View Text - HTML Formatted
SELECT DISTINCT JD.SEGMENT2 FROM PER_JOBS J , PER_JOB_DEFINITIONS JD , PA_IMPLEMENTATIONS I WHERE J.BUSINESS_GROUP_ID = I.BUSINESS_GROUP_ID AND J.JOB_DEFINITION_ID = JD.JOB_DEFINITION_ID