AP_INVOICE_REQUESTERS

Details

Name
PERSON_ID PERSON_NUMBER EMAIL_ADDRESS FIRST_NAME LAST_NAME LIST_NAME PERSON_NAME_ID

Name

PERSON_ID

PERSON_NUMBER

EMAIL_ADDRESS

FIRST_NAME

LAST_NAME

LIST_NAME

PERSON_NAME_ID

SQL_Statement
SELECT person.person_id, papf.person_number, emailaddress.email_address, personname.first_name, personname.last_name, personname.list_name, personname.person_name_id FROM per_persons person, per_all_people_f papf, per_person_names_f_v personname, per_all_assignments_m assgn, per_person_types_vl persontype, per_users usr, per_email_addresses emailaddress WHERE person.person_id = papf.person_id AND papf.primary_email_id = emailaddress.email_address_id (+) AND trunc(sysdate) BETWEEN trunc(papf.effective_start_date) AND trunc(papf.effective_end_date) AND person.person_id = personname.person_id AND trunc(sysdate) BETWEEN trunc(personname.effective_start_date) AND trunc(personname.effective_end_date) AND person.person_id = assgn.person_id AND trunc(sysdate) BETWEEN trunc(assgn.effective_start_date) AND trunc(assgn.effective_end_date) AND assgn.work_terms_assignment_id IS NOT NULL AND assgn.primary_flag = 'Y' AND assgn.assignment_type IN ( 'E', 'C' ) AND persontype.system_person_type IN ( 'EMP', 'CWK' ) AND persontype.person_type_id = assgn.person_type_id AND usr.person_id = person.person_id AND assgn.assignment_status_type <> 'INACTIVE'

SQL_Statement

SELECT

person.person_id,

papf.person_number,

emailaddress.email_address,

personname.first_name,

personname.last_name,

personname.list_name,

personname.person_name_id

FROM

per_persons person,

per_all_people_f papf,

per_person_names_f_v personname,

per_all_assignments_m assgn,

per_person_types_vl persontype,

per_users usr,

per_email_addresses emailaddress

WHERE

person.person_id = papf.person_id

AND papf.primary_email_id = emailaddress.email_address_id (+)

AND trunc(sysdate) BETWEEN trunc(papf.effective_start_date) AND trunc(papf.effective_end_date)

AND person.person_id = personname.person_id

AND trunc(sysdate) BETWEEN trunc(personname.effective_start_date) AND trunc(personname.effective_end_date)

AND person.person_id = assgn.person_id

AND trunc(sysdate) BETWEEN trunc(assgn.effective_start_date) AND trunc(assgn.effective_end_date)

AND assgn.work_terms_assignment_id IS NOT NULL

AND assgn.primary_flag = 'Y'

AND assgn.assignment_type IN ( 'E', 'C' )

AND persontype.system_person_type IN ( 'EMP', 'CWK' )

AND persontype.person_type_id = assgn.person_type_id

AND usr.person_id = person.person_id

AND assgn.assignment_status_type <> 'INACTIVE'