View: WF_AMV_CHN_UR

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

View Text

SELECT USR.USER_NAME
, 'PER'
, PER.PERSON_ID
, 'AMV_CHN'||':'||CHB.CHANNEL_ID
, 'AMV_CHN'
, CHB.CHANNEL_ID
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, 6
FROM AMV_C_CHANNELS_B CHB
, AMV_U_ACCESS CUA
, JTF_RS_RESOURCE_EXTNS JRE
, PER_ALL_PEOPLE_F PER
, FND_USER USR
WHERE CUA.ACCESS_TO_TABLE_CODE = 'CHANNEL'
AND CUA.ACCESS_TO_TABLE_RECORD_ID = CHB.CHANNEL_ID
AND CUA.USER_OR_GROUP_TYPE = 'USER'
AND CUA.EFFECTIVE_START_DATE <= SYSDATE
AND NVL(CUA.EXPIRATION_DATE
, SYSDATE) >= SYSDATE
AND CUA.CHL_APPROVER_FLAG = 'T'
AND CUA.USER_OR_GROUP_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