VIEW: APPS.HRBV_LOCATION

Source

View Text - Preformatted

SELECT locT.location_code location_name ,locT.description description ,loc.address_line_1 address_line_1 ,loc.address_line_2 address_line_2 ,loc.address_line_3 address_line_3 ,loc.town_or_city town_or_city ,loc.region_1 region_1 ,loc.region_2 region_2 ,loc.region_3 region_3 ,loc.country country ,loc.postal_code postal_code ,loc.telephone_number_1 telephone_number_1 ,loc.telephone_number_2 telephone_number_2 ,loc.telephone_number_3 telephone_number_3 ,loc.loc_information13 loc_information13 ,loc.loc_information14 loc_information14 ,loc.loc_information15 loc_information15 ,loc.loc_information16 loc_information16 ,loc.loc_information17 loc_information17 ,loc.loc_information18 loc_information18 ,loc.loc_information19 loc_information19 ,loc.loc_information20 loc_information20 ,loc.inactive_date inactive_date ,loc.tax_name tax_name ,loc.derived_locale derived_locale ,hr_bis.bis_decode_lookup('YES_NO',loc.bill_to_site_flag) bill_to_site_flag ,hr_bis.bis_decode_lookup('YES_NO',loc.in_organization_flag) internal_site_flag ,hr_bis.bis_decode_lookup('YES_NO',loc.receiving_site_flag) receiving_site_flag ,hr_bis.bis_decode_lookup('YES_NO',loc.office_site_flag) office_site_flag ,hr_bis.bis_decode_lookup('YES_NO',loc.ship_to_site_flag) ship_to_location_flag ,hr_bis.bis_decode_lookup('YES_NO',loc.legal_address_flag) legal_address_flag ,loc.bill_to_site_flag bill_to_site_flag_code ,loc.in_organization_flag in_organization_flag_code ,loc.receiving_site_flag receiving_site_flag_code ,loc.office_site_flag office_site_flag_code ,loc.ship_to_site_flag ship_to_site_flag_code ,loc.style address_style_code ,loc.legal_address_flag legal_address_flag_code ,'_DF:PER:HR_LOCATIONS:loc' ,'_DF:PER:Address Location:loc' ,'_DF:JG:JG_HR_LOCATIONS:loc' ,loc.entered_by entered_by ,loc.business_group_id business_group_id ,loc.designated_receiver_id designated_receiver_id ,loc.inventory_organization_id inventory_organization_id ,loc.location_id location_id ,loc.ship_to_location_id ship_to_location_id ,loc.last_update_date last_update_date ,loc.last_updated_by last_updated_by ,loc.last_update_login last_update_login ,loc.created_by created_by ,loc.creation_date creation_date , CASE WHEN (( (hr_bis.get_sec_profile_bg_id IS NULL) OR (loc.business_group_id IS NULL) OR (loc.business_group_id = hr_bis.get_sec_profile_bg_id))) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM hr_locations_all loc ,hr_locations_all_tl locT WHERE loc.location_id = locT.location_id AND locT.language = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT LOCT.LOCATION_CODE LOCATION_NAME
, LOCT.DESCRIPTION DESCRIPTION
, LOC.ADDRESS_LINE_1 ADDRESS_LINE_1
, LOC.ADDRESS_LINE_2 ADDRESS_LINE_2
, LOC.ADDRESS_LINE_3 ADDRESS_LINE_3
, LOC.TOWN_OR_CITY TOWN_OR_CITY
, LOC.REGION_1 REGION_1
, LOC.REGION_2 REGION_2
, LOC.REGION_3 REGION_3
, LOC.COUNTRY COUNTRY
, LOC.POSTAL_CODE POSTAL_CODE
, LOC.TELEPHONE_NUMBER_1 TELEPHONE_NUMBER_1
, LOC.TELEPHONE_NUMBER_2 TELEPHONE_NUMBER_2
, LOC.TELEPHONE_NUMBER_3 TELEPHONE_NUMBER_3
, LOC.LOC_INFORMATION13 LOC_INFORMATION13
, LOC.LOC_INFORMATION14 LOC_INFORMATION14
, LOC.LOC_INFORMATION15 LOC_INFORMATION15
, LOC.LOC_INFORMATION16 LOC_INFORMATION16
, LOC.LOC_INFORMATION17 LOC_INFORMATION17
, LOC.LOC_INFORMATION18 LOC_INFORMATION18
, LOC.LOC_INFORMATION19 LOC_INFORMATION19
, LOC.LOC_INFORMATION20 LOC_INFORMATION20
, LOC.INACTIVE_DATE INACTIVE_DATE
, LOC.TAX_NAME TAX_NAME
, LOC.DERIVED_LOCALE DERIVED_LOCALE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, LOC.BILL_TO_SITE_FLAG) BILL_TO_SITE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, LOC.IN_ORGANIZATION_FLAG) INTERNAL_SITE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, LOC.RECEIVING_SITE_FLAG) RECEIVING_SITE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, LOC.OFFICE_SITE_FLAG) OFFICE_SITE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, LOC.SHIP_TO_SITE_FLAG) SHIP_TO_LOCATION_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, LOC.LEGAL_ADDRESS_FLAG) LEGAL_ADDRESS_FLAG
, LOC.BILL_TO_SITE_FLAG BILL_TO_SITE_FLAG_CODE
, LOC.IN_ORGANIZATION_FLAG IN_ORGANIZATION_FLAG_CODE
, LOC.RECEIVING_SITE_FLAG RECEIVING_SITE_FLAG_CODE
, LOC.OFFICE_SITE_FLAG OFFICE_SITE_FLAG_CODE
, LOC.SHIP_TO_SITE_FLAG SHIP_TO_SITE_FLAG_CODE
, LOC.STYLE ADDRESS_STYLE_CODE
, LOC.LEGAL_ADDRESS_FLAG LEGAL_ADDRESS_FLAG_CODE
, '_DF:PER:HR_LOCATIONS:LOC'
, '_DF:PER:ADDRESS LOCATION:LOC'
, '_DF:JG:JG_HR_LOCATIONS:LOC'
, LOC.ENTERED_BY ENTERED_BY
, LOC.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LOC.DESIGNATED_RECEIVER_ID DESIGNATED_RECEIVER_ID
, LOC.INVENTORY_ORGANIZATION_ID INVENTORY_ORGANIZATION_ID
, LOC.LOCATION_ID LOCATION_ID
, LOC.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, LOC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LOC.LAST_UPDATED_BY LAST_UPDATED_BY
, LOC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LOC.CREATED_BY CREATED_BY
, LOC.CREATION_DATE CREATION_DATE
, CASE WHEN (( (HR_BIS.GET_SEC_PROFILE_BG_ID IS NULL) OR (LOC.BUSINESS_GROUP_ID IS NULL) OR (LOC.BUSINESS_GROUP_ID = HR_BIS.GET_SEC_PROFILE_BG_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM HR_LOCATIONS_ALL LOC
, HR_LOCATIONS_ALL_TL LOCT
WHERE LOC.LOCATION_ID = LOCT.LOCATION_ID
AND LOCT.LANGUAGE = USERENV('LANG') WITH READ ONLY