DBA Data[Home] [Help]

VIEW: APPS.PA_JOB_LEVELS_V

Source

View Text - Preformatted

SELECT DISTINCT JD.SEGMENT1 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.SEGMENT1
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