VIEW: APPS.MTL_EMPLOYEES_VIEW

Source

View Text - Preformatted

SELECT ORG.ORGANIZATION_ID, P.BUSINESS_GROUP_ID , P.PERSON_ID , P.LAST_UPDATE_DATE , P.LAST_UPDATED_BY , P.LAST_UPDATE_LOGIN , P.CREATION_DATE, P.CREATED_BY , P.EMPLOYEE_NUMBER , P.FULL_NAME , P.FIRST_NAME , P.MIDDLE_NAMES , P.LAST_NAME , P.TITLE , P.EXPENSE_CHECK_SEND_TO_ADDRESS , P.EMAIL_ADDRESS, 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, P.ATTRIBUTE_CATEGORY FROM PER_PEOPLE_X P, HR_ORGANIZATION_UNITS ORG WHERE P.BUSINESS_GROUP_ID + 0 = ORG.BUSINESS_GROUP_ID AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE AND P.EMPLOYEE_NUMBER IS NOT NULL

View Text - HTML Formatted

SELECT ORG.ORGANIZATION_ID
, P.BUSINESS_GROUP_ID
, P.PERSON_ID
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY
, P.LAST_UPDATE_LOGIN
, P.CREATION_DATE
, P.CREATED_BY
, P.EMPLOYEE_NUMBER
, P.FULL_NAME
, P.FIRST_NAME
, P.MIDDLE_NAMES
, P.LAST_NAME
, P.TITLE
, P.EXPENSE_CHECK_SEND_TO_ADDRESS
, P.EMAIL_ADDRESS
, 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
, P.ATTRIBUTE_CATEGORY
FROM PER_PEOPLE_X P
, HR_ORGANIZATION_UNITS ORG
WHERE P.BUSINESS_GROUP_ID + 0 = ORG.BUSINESS_GROUP_ID
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND P.EMPLOYEE_NUMBER IS NOT NULL