View: HRFV_GB_ADDRESSES

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PER.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 POST_CODE
, HR_BIS.BIS_DECODE_LOOKUP('GB_COUNTY'
, ADDR.REGION_1) COUNTY
, 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 TOWN
, PER.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PER.CURRENT_EMPLOYEE_FLAG) CURRENT_EMPLOYEE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PER.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 PER
WHERE TRUNC(SYSDATE) BETWEEN ADDR.DATE_FROM
AND NVL(ADDR.DATE_TO
, TRUNC(SYSDATE))
AND ADDR.STYLE = 'GB'
AND PER.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.PERSON_ID = PER.PERSON_ID
AND ADDR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ADDR.BUSINESS_GROUP_ID) WITH READ ONLY

Columns