View: HRFV_US_ADDRESSES

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_US_ADDRESSES

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, ADDR.STYLE ADDRESS_STYLE
, HR_BIS.BIS_DECODE_LOOKUP('ADDRESS_TYPE'
, ADDR.ADDRESS_TYPE) ADDRESS_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ADDR.PRIMARY_FLAG) PRIMARY_FLAG
, ADDR.DATE_FROM ADDR_DATE_FROM
, ADDR.DATE_TO ADDR_DATE_TO
, ADDR.ADDRESS_LINE1 ADDRESS_LINE1
, ADDR.ADDRESS_LINE2 ADDRESS_LINE2
, ADDR.ADDRESS_LINE3 ADDRESS_LINE3
, ADDR.COMMENTS ADDR_COMMENTS
, ADDR.COUNTRY COUNTRY
, ADDR.POSTAL_CODE ZIP_CODE
, ADDR.REGION_1 COUNTY
, HR_BIS.BIS_DECODE_LOOKUP('US_STATE'
, ADDR.REGION_2) STATE_NAME
, ADDR.REGION_2 STATE_CODE
, ADDR.TELEPHONE_NUMBER_1 TELEPHONE_NUMBER_1
, ADDR.TELEPHONE_NUMBER_2 TELEPHONE_NUMBER_2
, ADDR.TELEPHONE_NUMBER_3 TELEPHONE_NUMBER_3
, ADDR.TOWN_OR_CITY CITY
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.CURRENT_EMPLOYEE_FLAG) CURRENT_EMPLOYEE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.CURRENT_APPLICANT_FLAG) CURRENT_APPLICANT_FLAG
, PTT.USER_PERSON_TYPE PERSON_TYPE
, '_DF:PER:PER_ADDRESSES:ADDR'
, ADDR.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ADDR.PERSON_ID PERSON_ID
, PTT.PERSON_TYPE_ID PERSON_TYPE_ID
FROM PER_ADDRESSES ADDR
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PERSON_TYPES_TL PTT
, PER_PEOPLE_X PEO
WHERE TRUNC(SYSDATE) BETWEEN ADDR.DATE_FROM
AND NVL(ADDR.DATE_TO
, TRUNC(SYSDATE))
AND ADDR.STYLE = 'US'
AND PEO.PERSON_ID = ADDR.PERSON_ID
AND PEO.PERSON_TYPE_ID = PTT.PERSON_TYPE_ID
AND PTT.LANGUAGE = USERENV('LANG')
AND ADDR.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ADDR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ADDR.BUSINESS_GROUP_ID) WITH READ ONLY

Columns