VIEW: APPS.ICX_PO_LIST_USERS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)