VIEW: APPS.AMW_PEOPLE_V

Source

View Text - Preformatted

SELECT P.party_id person_id, P.party_name person_name, U.user_name user_name, U.user_id user_id, per.email_address email_address, 'INTERNAL' person_type, null company_id, null company_name, null person_title, null person_prefix, null person_first_name, null person_middle_name, null person_last_name, null person_name_suffix, null phone_country_code, null phone_area_code, null phone_number, null phone_extension, null fax_country_code, null fax_area_code, null fax_number, null fax_extension, null known_as FROM hz_parties P, fnd_user U, per_all_people_f per WHERE U.employee_id IS NOT NULL AND p.party_id = per.party_id and per.person_id = u.employee_id AND per.effective_start_date <= SYSDATE AND (per.effective_end_date IS NULL OR per.effective_end_date > SYSDATE) AND per.current_employee_flag = 'Y' AND U.start_date <= SYSDATE AND (U.end_date IS NULL OR U.end_date >= SYSDATE)

View Text - HTML Formatted

SELECT P.PARTY_ID PERSON_ID
, P.PARTY_NAME PERSON_NAME
, U.USER_NAME USER_NAME
, U.USER_ID USER_ID
, PER.EMAIL_ADDRESS EMAIL_ADDRESS
, 'INTERNAL' PERSON_TYPE
, NULL COMPANY_ID
, NULL COMPANY_NAME
, NULL PERSON_TITLE
, NULL PERSON_PREFIX
, NULL PERSON_FIRST_NAME
, NULL PERSON_MIDDLE_NAME
, NULL PERSON_LAST_NAME
, NULL PERSON_NAME_SUFFIX
, NULL PHONE_COUNTRY_CODE
, NULL PHONE_AREA_CODE
, NULL PHONE_NUMBER
, NULL PHONE_EXTENSION
, NULL FAX_COUNTRY_CODE
, NULL FAX_AREA_CODE
, NULL FAX_NUMBER
, NULL FAX_EXTENSION
, NULL KNOWN_AS
FROM HZ_PARTIES P
, FND_USER U
, PER_ALL_PEOPLE_F PER
WHERE U.EMPLOYEE_ID IS NOT NULL
AND P.PARTY_ID = PER.PARTY_ID
AND PER.PERSON_ID = U.EMPLOYEE_ID
AND PER.EFFECTIVE_START_DATE <= SYSDATE
AND (PER.EFFECTIVE_END_DATE IS NULL OR PER.EFFECTIVE_END_DATE > SYSDATE)
AND PER.CURRENT_EMPLOYEE_FLAG = 'Y'
AND U.START_DATE <= SYSDATE
AND (U.END_DATE IS NULL OR U.END_DATE >= SYSDATE)