View: WF_POS_UR

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

View Text

SELECT USR.USER_NAME
, 'PER'
, PER.PERSON_ID
, 'POS'||':'||POS.POSITION_ID
, 'POS'
, POS.POSITION_ID
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, 4
FROM PER_ALL_ASSIGNMENTS_F ASS
, PER_ALL_POSITIONS POS
, FND_USER USR
, PER_ALL_PEOPLE_F PER
WHERE ASS.POSITION_ID = POS.POSITION_ID
AND ASS.PERSON_ID = USR.EMPLOYEE_ID
AND ASS.PERSON_ID = PER.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN ASS.EFFECTIVE_START_DATE
AND ASS.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN USR.START_DATE
AND NVL(USR.END_DATE
, SYSDATE+1)
AND PER.EMPLOYEE_NUMBER IS NOT NULL
AND ASS.ASSIGNMENT_TYPE = 'E'

Columns