View: PA_JOB_RELATIONSHIPS_V

Product:	PA - Projects
Description:	PA_JOB_RELATIONSHIPS_V is a view that identifies relationships between jobs that have been defined based on the groups used.- Retrofitted
Implementation/DBA Data:	APPS.PA_JOB_RELATIONSHIPS_V

View Text

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' )

Columns