VIEW: APPS.WF_POS_UR

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'