VIEW: APPS.PA_JOB_RELATIONSHIPS_V

Source

View Text - Preformatted

SELECT PJR.ROWID ROW_ID, PJR.JOB_RELATIONSHIP_ID, PJ1.NAME FROM_JOB_NAME, PJR.FROM_JOB_ID, PJ2.NAME TO_JOB_NAME, PJR.TO_JOB_ID, PJR.FROM_JOB_GROUP_ID, PJR.TO_JOB_GROUP_ID, PJR.CREATED_BY, PJR.CREATION_DATE, PJR.LAST_UPDATE_DATE, PJR.LAST_UPDATED_BY, PJR.LAST_UPDATE_LOGIN FROM PA_JOB_RELATIONSHIPS PJR, PER_JOBS PJ1, PER_JOBS PJ2 WHERE PJR.FROM_JOB_ID = PJ1.JOB_ID AND PJR.TO_JOB_ID = PJ2.JOB_ID AND ( ( PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N' AND fnd_profile.value('PER_BUSINESS_GROUP_ID') = PJ1.BUSINESS_GROUP_ID AND fnd_profile.value('PER_BUSINESS_GROUP_ID') = PJ2.BUSINESS_GROUP_ID ) OR PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y' )

View Text - HTML Formatted

SELECT PJR.ROWID ROW_ID
, PJR.JOB_RELATIONSHIP_ID
, PJ1.NAME FROM_JOB_NAME
, PJR.FROM_JOB_ID
, PJ2.NAME TO_JOB_NAME
, PJR.TO_JOB_ID
, PJR.FROM_JOB_GROUP_ID
, PJR.TO_JOB_GROUP_ID
, PJR.CREATED_BY
, PJR.CREATION_DATE
, PJR.LAST_UPDATE_DATE
, PJR.LAST_UPDATED_BY
, PJR.LAST_UPDATE_LOGIN
FROM PA_JOB_RELATIONSHIPS PJR
, PER_JOBS PJ1
, PER_JOBS PJ2
WHERE PJR.FROM_JOB_ID = PJ1.JOB_ID
AND PJR.TO_JOB_ID = PJ2.JOB_ID
AND ( ( PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE = 'N'
AND FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') = PJ1.BUSINESS_GROUP_ID
AND FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') = PJ2.BUSINESS_GROUP_ID ) OR PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE = 'Y' )