View: GL_HR_EMPLOYEES_CURRENT_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_HR_EMPLOYEES_CURRENT_V

View Text

SELECT P.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, A.ORGANIZATION_ID ORGANIZATION_ID
, P.PERSON_ID EMPLOYEE_ID
, P.LAST_UPDATE_DATE LAST_UPDATE_DATE
, P.LAST_UPDATED_BY LAST_UPDATED_BY
, P.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, P.CREATION_DATE CREATION_DATE
, P.CREATED_BY CREATED_BY
, P.FULL_NAME EMPLOYEE_NAME
, P.TITLE TITLE
, A.SUPERVISOR_ID SUPERVISOR_ID
, A.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
FROM PER_PEOPLE_X P
, PER_ASSIGNMENTS_X A
WHERE P.BUSINESS_GROUP_ID + 0 = A.BUSINESS_GROUP_ID + 0
AND A.PRIMARY_FLAG = 'Y'
AND P.EMPLOYEE_NUMBER IS NOT NULL
AND A.ASSIGNMENT_TYPE = 'E'
AND A.PERSON_ID = P.PERSON_ID

Columns