VIEW: APPS.HRBV_ADDRESS

Source

View Text - Preformatted

SELECT 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 date_from ,addr.date_to date_to ,addr.address_line1 address_line1 ,addr.address_line2 address_line2 ,addr.address_line3 address_line3 ,addr.comments comments ,addr.country country ,addr.postal_code postal_code ,addr.region_1 region_1 ,addr.region_2 region_2 ,addr.region_3 region_3 ,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_or_city ,addr.derived_locale derived_locale ,'_DF:PER:PER_ADDRESSES:addr' ,'_DF:PER:Address Structure:addr' ,addr.style style_code ,addr.address_type address_type_code ,addr.primary_flag primary_flag_code ,addr.business_group_id business_group_id ,addr.person_id person_id ,addr.address_id address_id ,addr.party_id party_id ,addr.last_update_date last_update_date ,addr.last_updated_by last_updated_by ,addr.last_update_login last_update_login ,addr.created_by created_by ,addr.creation_date creation_date ,CASE WHEN (addr.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, addr.business_group_id)) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM per_addresses addr

View Text - HTML Formatted

SELECT 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 DATE_FROM
, ADDR.DATE_TO DATE_TO
, ADDR.ADDRESS_LINE1 ADDRESS_LINE1
, ADDR.ADDRESS_LINE2 ADDRESS_LINE2
, ADDR.ADDRESS_LINE3 ADDRESS_LINE3
, ADDR.COMMENTS COMMENTS
, ADDR.COUNTRY COUNTRY
, ADDR.POSTAL_CODE POSTAL_CODE
, ADDR.REGION_1 REGION_1
, ADDR.REGION_2 REGION_2
, ADDR.REGION_3 REGION_3
, 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_OR_CITY
, ADDR.DERIVED_LOCALE DERIVED_LOCALE
, '_DF:PER:PER_ADDRESSES:ADDR'
, '_DF:PER:ADDRESS STRUCTURE:ADDR'
, ADDR.STYLE STYLE_CODE
, ADDR.ADDRESS_TYPE ADDRESS_TYPE_CODE
, ADDR.PRIMARY_FLAG PRIMARY_FLAG_CODE
, ADDR.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ADDR.PERSON_ID PERSON_ID
, ADDR.ADDRESS_ID ADDRESS_ID
, ADDR.PARTY_ID PARTY_ID
, ADDR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ADDR.LAST_UPDATED_BY LAST_UPDATED_BY
, ADDR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ADDR.CREATED_BY CREATED_BY
, ADDR.CREATION_DATE CREATION_DATE
, CASE WHEN (ADDR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ADDR.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_ADDRESSES ADDR