1260: ,adr.postal_code postal_code
1261: ,SUBSTR(per.national_identifier,-4,4) national_identifier
1262: ,per.business_group_id bg_id
1263: FROM per_all_people_f per
1264: ,per_all_assignments_f ass
1265: ,per_business_groups_perf bg
1266: ,hr_locations_all loc
1267: ,hr_all_organization_units org
1268: ,per_addresses adr
1586: adr.postal_code "PostalCode",
1587: SUBSTR(per.national_identifier,-4,4) "NationalIdentifier",
1588: per.business_group_id "BusinessGroupId"
1589: from per_all_people_f per
1590: ,per_all_assignments_f ass
1591: ,hr_all_organization_units_tl bg
1592: ,hr_locations_all_tl loc
1593: ,hr_all_organization_units_tl org
1594: ,per_addresses adr
1688: ,adr.postal_code "PostalCode"
1689: ,SUBSTR(per.national_identifier,-4,4) "NationalIdentifier"
1690: ,per.business_group_id "BusinessGroupId"
1691: FROM per_all_people_f per
1692: ,per_all_assignments_f ass
1693: ,per_business_groups_perf bg
1694: ,hr_locations_all loc
1695: ,hr_all_organization_units org
1696: ,per_addresses adr