View: PA_RES_ADDRESSES_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_RES_ADDRESSES_V

View Text

SELECT PER.PERSON_ID RESOURCE_SOURCE_ID
, PER.FULL_NAME
, ADDR.ADDRESS_TYPE
, TER.TERRITORY_SHORT_NAME
, ADDR.REGION_2 STATE
, ADDR.REGION_1 PROVINCE
, ADDR.TOWN_OR_CITY CITY
, ADDR.PRIMARY_FLAG
FROM PER_PEOPLE_F PER
, PER_ADDRESSES ADDR
, FND_TERRITORIES_TL TER
WHERE PER.PERSON_ID = ADDR.PERSON_ID
AND SYSDATE BETWEEN ADDR.DATE_FROM
AND NVL(ADDR.DATE_TO
, SYSDATE + 1)
AND TER.TERRITORY_CODE = ADDR.COUNTRY
AND TER.LANGUAGE = USERENV('LANG')

Columns