Search This Blog

Saturday, November 25, 2017

Fusion Person Address Query

select papf.person_number,pa.ADDRESS_LINE_1, pa.ADDRESS_LINE_2, pa.ADDRESS_LINE_3,pa.COUNTRY,pa.POSTAL_CODE from  per_addresses_F pa, PER_PERSON_ADDR_USAGES_F ppa,per_all_people_f papf
where ppa.address_id = pa.address_id
and papf.person_id = ppa.person_id
and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date

No comments:

Post a Comment