1. Tables and Views for Financials
  2. AP_OFR_EMPLOYEES_V

AP_OFR_EMPLOYEES_V

Details

  • Schema: FUSION

  • Object owner: AP

  • Object type: VIEW

Columns

Name

PERSON_ID

PERSON_NUMBER

EMAIL_ADDRESS

FIRST_NAME

LAST_NAME

LIST_NAME

PERSON_NAME_ID

Query

SQL_Statement

SELECT

PersonPEO.PERSON_ID,

PersonDPEO.PERSON_NUMBER,

EmailAddressPEO.EMAIL_ADDRESS,

PersonNameDPEO.FIRST_NAME,

PersonNameDPEO.LAST_NAME,

PersonNameDPEO.LIST_NAME,

PersonNameDPEO.PERSON_NAME_ID

FROM

PER_PERSONS PersonPEO

,PER_ALL_PEOPLE_F PersonDPEO

,PER_PERSON_NAMES_F_V PersonNameDPEO

,PER_ALL_ASSIGNMENTS_M AssignmentDPEO

,PER_PERSON_TYPES_VL PersonTypePEO

,PER_USERS UserPEO

,PER_EMAIL_ADDRESSES EmailAddressPEO

Where PersonPEO.PERSON_ID = PersonDPEO.PERSON_ID

AND PersonDPEO.PRIMARY_EMAIL_ID = EmailAddressPEO.EMAIL_ADDRESS_ID(+)

AND TRUNC(SYSDATE) BETWEEN trunc(PersonDPEO.EFFECTIVE_START_DATE) AND

trunc(PersonDPEO.EFFECTIVE_END_DATE)

AND PersonPEO.PERSON_ID = PersonNameDPEO.PERSON_ID

AND TRUNC(SYSDATE) BETWEEN trunc(PersonNameDPEO.EFFECTIVE_START_DATE) AND

trunc(PersonNameDPEO.EFFECTIVE_END_DATE)

AND PersonPEO.PERSON_ID = AssignmentDPEO.PERSON_ID

AND TRUNC(SYSDATE) BETWEEN trunc(AssignmentDPEO.EFFECTIVE_START_DATE) AND

trunc(AssignmentDPEO.EFFECTIVE_END_DATE)

AND AssignmentDPEO.WORK_TERMS_ASSIGNMENT_ID IS NOT NULL

AND AssignmentDPEO.PRIMARY_FLAG = 'Y'

AND AssignmentDPEO.ASSIGNMENT_TYPE IN ('E','C')

AND PersonTypePEO.SYSTEM_PERSON_TYPE IN ('EMP','CWK')

AND PersonTypePEO.PERSON_TYPE_ID = AssignmentDPEO.PERSON_TYPE_ID

AND UserPEO.PERSON_ID = PersonPEO.PERSON_ID

AND AssignmentDPEO.ASSIGNMENT_STATUS_TYPE <> 'INACTIVE'