VIEW: APPS.POS_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, POS_GET.GET_GL_VALUE(101,'GL#',101, PAF.DEFAULT_CODE_COMB_ID,'COST CENTER') COST_CENTER FROM PER_ALL_PEOPLE_F PPF, PER_ALL_ASSIGNMENTS_F PAF, FND_USER FNU, HR_ORGANIZATION_UNITS HOU, HR_LOCATIONS_ALL 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
, POS_GET.GET_GL_VALUE(101
, 'GL#'
, 101
, PAF.DEFAULT_CODE_COMB_ID
, 'COST CENTER') COST_CENTER
FROM PER_ALL_PEOPLE_F PPF
, PER_ALL_ASSIGNMENTS_F PAF
, FND_USER FNU
, HR_ORGANIZATION_UNITS HOU
, HR_LOCATIONS_ALL 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)