Product: | AMW - Internal Controls Manager |
---|---|
Description: | View for peoples |
Implementation/DBA Data: | APPS.AMW_PEOPLE_V |
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)