VIEW: APPS.POS_PO_EMPLOYEE_DETAILS_V

Source

View Text - Preformatted

SELECT P.PERSON_ID, P.EMPLOYEE_NUMBER, P.FULL_NAME, P.FIRST_NAME, P.LAST_NAME, P.EMAIL_ADDRESS, HR_GENERAL.GET_WORK_PHONE(P.PERSON_ID) "WORK_TELEPHONE", A.LOCATION_ID, P.ATTRIBUTE1, P.ATTRIBUTE2, P.ATTRIBUTE3, P.ATTRIBUTE4, P.ATTRIBUTE5, P.ATTRIBUTE6, P.ATTRIBUTE7, P.ATTRIBUTE8, P.ATTRIBUTE9, P.ATTRIBUTE10, P.ATTRIBUTE11, P.ATTRIBUTE12, P.ATTRIBUTE13, P.ATTRIBUTE14, P.ATTRIBUTE15, P.ATTRIBUTE16, P.ATTRIBUTE17, P.ATTRIBUTE18, P.ATTRIBUTE19, P.ATTRIBUTE20, HOU.NAME, POS.NAME, P.MAILSTOP, HR_GENERAL.GET_PHONE_NUMBER( P.PERSON_ID, 'WF', SYSDATE ), HR_GENERAL.GET_PHONE_NUMBER( P.PERSON_ID, 'P', SYSDATE ) FROM PER_ALL_PEOPLE_F P, PER_ALL_ASSIGNMENTS_F A, HR_ORGANIZATION_UNITS HOU, PER_ALL_POSITIONS POS WHERE A.PERSON_ID = P.PERSON_ID AND A.PRIMARY_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE AND TRUNC(SYSDATE) BETWEEN A.EFFECTIVE_START_DATE AND A.EFFECTIVE_END_DATE AND P.EMPLOYEE_NUMBER IS NOT NULL AND A.ASSIGNMENT_TYPE = 'E' AND HOU.ORGANIZATION_ID = P.BUSINESS_GROUP_ID AND HOU.BUSINESS_GROUP_ID = P.BUSINESS_GROUP_ID AND POS.POSITION_ID (+) = A.POSITION_ID

View Text - HTML Formatted

SELECT P.PERSON_ID
, P.EMPLOYEE_NUMBER
, P.FULL_NAME
, P.FIRST_NAME
, P.LAST_NAME
, P.EMAIL_ADDRESS
, HR_GENERAL.GET_WORK_PHONE(P.PERSON_ID) "WORK_TELEPHONE"
, A.LOCATION_ID
, P.ATTRIBUTE1
, P.ATTRIBUTE2
, P.ATTRIBUTE3
, P.ATTRIBUTE4
, P.ATTRIBUTE5
, P.ATTRIBUTE6
, P.ATTRIBUTE7
, P.ATTRIBUTE8
, P.ATTRIBUTE9
, P.ATTRIBUTE10
, P.ATTRIBUTE11
, P.ATTRIBUTE12
, P.ATTRIBUTE13
, P.ATTRIBUTE14
, P.ATTRIBUTE15
, P.ATTRIBUTE16
, P.ATTRIBUTE17
, P.ATTRIBUTE18
, P.ATTRIBUTE19
, P.ATTRIBUTE20
, HOU.NAME
, POS.NAME
, P.MAILSTOP
, HR_GENERAL.GET_PHONE_NUMBER( P.PERSON_ID
, 'WF'
, SYSDATE )
, HR_GENERAL.GET_PHONE_NUMBER( P.PERSON_ID
, 'P'
, SYSDATE )
FROM PER_ALL_PEOPLE_F P
, PER_ALL_ASSIGNMENTS_F A
, HR_ORGANIZATION_UNITS HOU
, PER_ALL_POSITIONS POS
WHERE A.PERSON_ID = P.PERSON_ID
AND A.PRIMARY_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN A.EFFECTIVE_START_DATE
AND A.EFFECTIVE_END_DATE
AND P.EMPLOYEE_NUMBER IS NOT NULL
AND A.ASSIGNMENT_TYPE = 'E'
AND HOU.ORGANIZATION_ID = P.BUSINESS_GROUP_ID
AND HOU.BUSINESS_GROUP_ID = P.BUSINESS_GROUP_ID
AND POS.POSITION_ID (+) = A.POSITION_ID