View: MTL_EMPLOYEES_CURRENT_VIEW

Product:	INV - Inventory
Description:	View of employees currently assigned to a given organization
Implementation/DBA Data:	APPS.MTL_EMPLOYEES_CURRENT_VIEW

View Text

SELECT ORG.ORGANIZATION_ID
, P.BUSINESS_GROUP_ID
, A.ORGANIZATION_ID
, P.PERSON_ID
, A.ASSIGNMENT_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
, A.LOCATION_ID
, A.SUPERVISOR_ID
, A.SET_OF_BOOKS_ID
, A.DEFAULT_CODE_COMB_ID
, P.EXPENSE_CHECK_SEND_TO_ADDRESS
, A.EFFECTIVE_END_DATE
, 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
, T.SYSTEM_PERSON_TYPE
FROM PER_PEOPLE_X P
, PER_ASSIGNMENTS_X A
, PER_PERSON_TYPES T
, HR_ORGANIZATION_UNITS ORG
WHERE A.PERSON_ID = P.PERSON_ID
AND ORG.BUSINESS_GROUP_ID = P.BUSINESS_GROUP_ID + 0
AND A.PRIMARY_FLAG = 'Y'
AND A.ASSIGNMENT_TYPE = 'E'
AND P.PERSON_TYPE_ID = T.PERSON_TYPE_ID
AND P.BUSINESS_GROUP_ID = T.BUSINESS_GROUP_ID
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 P.CURRENT_EMPLOYEE_FLAG ='Y'

Columns