eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_JOB_GROUP_COMBOS_V

Source

View Text - Preformatted


SELECT DISTINCT PJG1.DISPLAYED_NAME, PJR.FROM_JOB_GROUP_ID, PJG1.MASTER_FLAG, PJG2.DISPLAYED_NAME, PJR.TO_JOB_GROUP_ID, PJG2.MASTER_FLAG FROM PA_JOB_RELATIONSHIPS PJR, PER_JOB_GROUPS PJG1, PER_JOB_GROUPS PJG2 WHERE PJR.FROM_JOB_GROUP_ID = PJG1.JOB_GROUP_ID AND PJR.TO_JOB_GROUP_ID = PJG2.JOB_GROUP_ID AND ( ( PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N' AND fnd_profile.value('PER_BUSINESS_GROUP_ID') = PJG1.BUSINESS_GROUP_ID AND fnd_profile.value('PER_BUSINESS_GROUP_ID') = PJG2.BUSINESS_GROUP_ID ) OR PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y' )

View Text - HTML Formatted

SELECT DISTINCT PJG1.DISPLAYED_NAME
, PJR.FROM_JOB_GROUP_ID
, PJG1.MASTER_FLAG
, PJG2.DISPLAYED_NAME
, PJR.TO_JOB_GROUP_ID
, PJG2.MASTER_FLAG
FROM PA_JOB_RELATIONSHIPS PJR
, PER_JOB_GROUPS PJG1
, PER_JOB_GROUPS PJG2
WHERE PJR.FROM_JOB_GROUP_ID = PJG1.JOB_GROUP_ID
AND PJR.TO_JOB_GROUP_ID = PJG2.JOB_GROUP_ID
AND ( ( PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE = 'N'
AND FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') = PJG1.BUSINESS_GROUP_ID
AND FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') = PJG2.BUSINESS_GROUP_ID ) OR PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE = 'Y' )