View: ICX_PO_LIST_USERS_V

Product:	ICX - Oracle iProcurement
Description:	List of Users view
Implementation/DBA Data:	APPS.ICX_PO_LIST_USERS_V

View Text

SELECT DISTINCT PPF.PERSON_ID
, PPF.FIRST_NAME
, PPF.LAST_NAME
, PPF.FULL_NAME
, HR_GENERAL.GET_WORK_PHONE( PPF.PERSON_ID) "WORK_TELEPHONE"
, FNU.USER_NAME
, PPF.MAILSTOP
, HOU.NAME
, PPF.ATTRIBUTE1
, PPF.ATTRIBUTE2
, PPF.ATTRIBUTE3
, PPF.ATTRIBUTE4
, PPF.ATTRIBUTE5
, PPF.ATTRIBUTE6
, PPF.ATTRIBUTE7
, PPF.ATTRIBUTE8
, PPF.ATTRIBUTE9
, PPF.ATTRIBUTE10
, PPF.ATTRIBUTE11
, PPF.ATTRIBUTE12
, PPF.ATTRIBUTE13
, PPF.ATTRIBUTE14
, PPF.ATTRIBUTE15
, PPF.ATTRIBUTE16
, PPF.ATTRIBUTE17
, PPF.ATTRIBUTE18
, PPF.ATTRIBUTE19
, PPF.ATTRIBUTE20
, PPF.ATTRIBUTE_CATEGORY
, HRL.LOCATION_CODE LOC
, PAF.DEFAULT_CODE_COMB_ID
, ICX_GET.GET_GL_VALUE(101
, 'GL#'
, 101
, PAF.DEFAULT_CODE_COMB_ID
, 'COST CENTER') COST_CENTER
FROM PER_PEOPLE_F PPF
, PER_ASSIGNMENTS_F PAF
, FND_USER FNU
, HR_ORGANIZATION_UNITS HOU
, HR_LOCATIONS HRL
WHERE PPF.EMPLOYEE_NUMBER IS NOT NULL
AND TRUNC(SYSDATE) BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PAF.PERSON_ID = PPF.PERSON_ID
AND PAF.PRIMARY_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PAF.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND FNU.EMPLOYEE_ID (+) = PPF.PERSON_ID
AND HRL.LOCATION_ID (+) = PAF.LOCATION_ID
AND PPF.PERSON_ID IN (SELECT PREPARER_ID
FROM PO_REQUISITION_HEADERS GROUP BY PREPARER_ID)

Columns