View: WF_AMV_APPR_UR

Product:	FND - Application Object Library
Description:	Bulk Sync Directory Service User Role View for Role Orig System AMV_APPR
Implementation/DBA Data:	APPS.WF_AMV_APPR_UR

View Text

SELECT USR.USER_NAME
, 'PER'
, PER.PERSON_ID
, 'AMV_APPR'
, 'AMV_APPR'
, 520
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, 5
FROM JTF_RS_ROLES_B JRB
, JTF_RS_ROLE_RELATIONS JRR
, JTF_RS_RESOURCE_EXTNS JRE
, PER_ALL_PEOPLE_F PER
, FND_USER USR
WHERE JRB.ROLE_TYPE_CODE = 'MES'
AND JRB.ROLE_CODE = 'MES_APPROVE'
AND JRB.ROLE_ID = JRR.ROLE_ID
AND JRR.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL'
AND JRR.ROLE_RESOURCE_ID = JRE.RESOURCE_ID
AND JRE.CATEGORY = 'EMPLOYEE'
AND JRE.SOURCE_ID = PER.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND PER.PERSON_ID = USR.EMPLOYEE_ID UNION SELECT USR.USER_NAME
, 'PER'
, PER.PERSON_ID
, 'AMV_APPR'
, 'AMV_APPR'
, 520
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, 5
FROM JTF_RS_ROLES_B JRB
, JTF_RS_ROLE_RELATIONS JRR
, JTF_RS_GROUP_USAGES JGU
, JTF_RS_GROUPS_B JGB
, JTF_RS_GROUP_MEMBERS JGM
, JTF_RS_RESOURCE_EXTNS JRE
, PER_ALL_PEOPLE_F PER
, FND_USER USR
WHERE JRB.ROLE_TYPE_CODE = 'MES'
AND JRB.ROLE_CODE = 'MES_APPROVE'
AND JRB.ROLE_ID = JRR.ROLE_ID
AND JRR.ROLE_RESOURCE_TYPE = 'RS_GROUP'
AND JRR.ROLE_RESOURCE_ID = JGB.GROUP_ID
AND NVL(JRR.DELETE_FLAG
, 'N') <> 'Y'
AND JGU.USAGE = 'MES_GROUP'
AND JGU.GROUP_ID = JGB.GROUP_ID
AND JGU.GROUP_ID = JRR.ROLE_RESOURCE_ID
AND JGB.GROUP_ID = JGM.GROUP_ID
AND NVL(JGM.DELETE_FLAG
, 'N') <> 'Y'
AND JGM.RESOURCE_ID = JRE.RESOURCE_ID
AND JRE.CATEGORY = 'EMPLOYEE'
AND JRE.SOURCE_ID = PER.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND PER.PERSON_ID = USR.EMPLOYEE_ID

Columns