VIEW: APPS.GL_HR_EMPLOYEES_CURRENT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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