VIEW: APPS.HR_LOCATIONS_ALL_VL

Source

View Text - Preformatted

SELECT loc.rowid row_id, loc.location_id, lot.location_code, 'HR', loc.business_group_id+0 business_group_id, lot.description, loc.ship_to_location_id, loc.ship_to_site_flag, loc.receiving_site_flag, loc.bill_to_site_flag, loc.in_organization_flag, loc.office_site_flag, loc.designated_receiver_id, loc.inventory_organization_id, loc.tax_name, loc.inactive_date,loc.derived_locale, loc.style, loc.address_line_1, loc.address_line_2, loc.address_line_3, loc.town_or_city, loc.country, loc.postal_code, loc.region_1, loc.region_2, loc.region_3, loc.telephone_number_1, loc.telephone_number_2, loc.telephone_number_3, loc.loc_information13, loc.loc_information14, loc.loc_information15, loc.loc_information16, loc.loc_information17, loc.loc_information18, loc.loc_information19, loc.loc_information20, loc.attribute_category, loc.attribute1, loc.attribute2, loc.attribute3, loc.attribute4, loc.attribute5, loc.attribute6, loc.attribute7, loc.attribute8, loc.attribute9, loc.attribute10, loc.attribute11, loc.attribute12, loc.attribute13, loc.attribute14, loc.attribute15, loc.attribute16, loc.attribute17, loc.attribute18, loc.attribute19, loc.attribute20, loc.global_attribute_category, loc.global_attribute1, loc.global_attribute2, loc.global_attribute3, loc.global_attribute4, loc.global_attribute5, loc.global_attribute6, loc.global_attribute7, loc.global_attribute8, loc.global_attribute9, loc.global_attribute10, loc.global_attribute11, loc.global_attribute12, loc.global_attribute13, loc.global_attribute14, loc.global_attribute15, loc.global_attribute16, loc.global_attribute17, loc.global_attribute18, loc.global_attribute19, loc.global_attribute20, loc.last_update_date, loc.last_updated_by, loc.last_update_login, loc.created_by, loc.creation_date, loc.entered_by, loc.tp_header_id, loc.ece_tp_location_code, loc.object_version_number,loc.geometry, loc.legal_address_flag, loc.timezone_code from hr_locations_all loc, hr_locations_all_tl lot WHERE loc.location_id = lot.location_id and lot.language = userenv('LANG')

View Text - HTML Formatted

SELECT LOC.ROWID ROW_ID
, LOC.LOCATION_ID
, LOT.LOCATION_CODE
, 'HR'
, LOC.BUSINESS_GROUP_ID+0 BUSINESS_GROUP_ID
, LOT.DESCRIPTION
, LOC.SHIP_TO_LOCATION_ID
, LOC.SHIP_TO_SITE_FLAG
, LOC.RECEIVING_SITE_FLAG
, LOC.BILL_TO_SITE_FLAG
, LOC.IN_ORGANIZATION_FLAG
, LOC.OFFICE_SITE_FLAG
, LOC.DESIGNATED_RECEIVER_ID
, LOC.INVENTORY_ORGANIZATION_ID
, LOC.TAX_NAME
, LOC.INACTIVE_DATE
, LOC.DERIVED_LOCALE
, LOC.STYLE
, LOC.ADDRESS_LINE_1
, LOC.ADDRESS_LINE_2
, LOC.ADDRESS_LINE_3
, LOC.TOWN_OR_CITY
, LOC.COUNTRY
, LOC.POSTAL_CODE
, LOC.REGION_1
, LOC.REGION_2
, LOC.REGION_3
, LOC.TELEPHONE_NUMBER_1
, LOC.TELEPHONE_NUMBER_2
, LOC.TELEPHONE_NUMBER_3
, LOC.LOC_INFORMATION13
, LOC.LOC_INFORMATION14
, LOC.LOC_INFORMATION15
, LOC.LOC_INFORMATION16
, LOC.LOC_INFORMATION17
, LOC.LOC_INFORMATION18
, LOC.LOC_INFORMATION19
, LOC.LOC_INFORMATION20
, LOC.ATTRIBUTE_CATEGORY
, LOC.ATTRIBUTE1
, LOC.ATTRIBUTE2
, LOC.ATTRIBUTE3
, LOC.ATTRIBUTE4
, LOC.ATTRIBUTE5
, LOC.ATTRIBUTE6
, LOC.ATTRIBUTE7
, LOC.ATTRIBUTE8
, LOC.ATTRIBUTE9
, LOC.ATTRIBUTE10
, LOC.ATTRIBUTE11
, LOC.ATTRIBUTE12
, LOC.ATTRIBUTE13
, LOC.ATTRIBUTE14
, LOC.ATTRIBUTE15
, LOC.ATTRIBUTE16
, LOC.ATTRIBUTE17
, LOC.ATTRIBUTE18
, LOC.ATTRIBUTE19
, LOC.ATTRIBUTE20
, LOC.GLOBAL_ATTRIBUTE_CATEGORY
, LOC.GLOBAL_ATTRIBUTE1
, LOC.GLOBAL_ATTRIBUTE2
, LOC.GLOBAL_ATTRIBUTE3
, LOC.GLOBAL_ATTRIBUTE4
, LOC.GLOBAL_ATTRIBUTE5
, LOC.GLOBAL_ATTRIBUTE6
, LOC.GLOBAL_ATTRIBUTE7
, LOC.GLOBAL_ATTRIBUTE8
, LOC.GLOBAL_ATTRIBUTE9
, LOC.GLOBAL_ATTRIBUTE10
, LOC.GLOBAL_ATTRIBUTE11
, LOC.GLOBAL_ATTRIBUTE12
, LOC.GLOBAL_ATTRIBUTE13
, LOC.GLOBAL_ATTRIBUTE14
, LOC.GLOBAL_ATTRIBUTE15
, LOC.GLOBAL_ATTRIBUTE16
, LOC.GLOBAL_ATTRIBUTE17
, LOC.GLOBAL_ATTRIBUTE18
, LOC.GLOBAL_ATTRIBUTE19
, LOC.GLOBAL_ATTRIBUTE20
, LOC.LAST_UPDATE_DATE
, LOC.LAST_UPDATED_BY
, LOC.LAST_UPDATE_LOGIN
, LOC.CREATED_BY
, LOC.CREATION_DATE
, LOC.ENTERED_BY
, LOC.TP_HEADER_ID
, LOC.ECE_TP_LOCATION_CODE
, LOC.OBJECT_VERSION_NUMBER
, LOC.GEOMETRY
, LOC.LEGAL_ADDRESS_FLAG
, LOC.TIMEZONE_CODE
FROM HR_LOCATIONS_ALL LOC
, HR_LOCATIONS_ALL_TL LOT
WHERE LOC.LOCATION_ID = LOT.LOCATION_ID
AND LOT.LANGUAGE = USERENV('LANG')