View: PA_JOB_GROUP_COMBOS_V

Product:	PA - Projects
Description:	PA_JOB_GROUP_COMBOS_V is a view that identifies the combinations of from and to Job groups that have been defined.- Retrofitted
Implementation/DBA Data:	APPS.PA_JOB_GROUP_COMBOS_V

View Text

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

Columns