Thursday, 13 August 2020

Manage Person Transactions table query

 select txnh.creation_date,txnh.transaction_id,pname.full_name,per.person_number from fusion.hrc_txn_header txnh,per_person_names_f pname,per_all_people_f per where txnh.object_id = pname.person_id and trunc(sysdate) between pname.effective_start_date and pname.effective_end_date and pname.name_Type ='GLOBAL' and txnh.process_owner='Manage Person'

and per.person_id = pname.person_id

and trunc(sysdate) between per.effective_start_date and per.effective_end_date

--and txnh.transaction_id = '300000060534900'

No comments:

Post a Comment