DBA Data[Home] [Help]

VIEW: APPS.HR_LOCATIONS_NO_JOIN

Source

View Text - Preformatted

SELECT location_id, location_code, business_group_id+0, description, ship_to_location_id, ship_to_site_flag, receiving_site_flag, bill_to_site_flag, in_organization_flag, office_site_flag, designated_receiver_id, inventory_organization_id, tax_name, inactive_date, style, address_line_1, address_line_2, address_line_3, town_or_city, country, postal_code, region_1, region_2, region_3, telephone_number_1, telephone_number_2, telephone_number_3, loc_information13, loc_information14, loc_information15, loc_information16, loc_information17, loc_information18, loc_information19, loc_information20, attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, attribute10, attribute11, attribute12, attribute13, attribute14, attribute15, attribute16, attribute17, attribute18, attribute19, attribute20, global_attribute_category, global_attribute1, global_attribute2, global_attribute3, global_attribute4, global_attribute5, global_attribute6, global_attribute7, global_attribute8, global_attribute9, global_attribute10, global_attribute11, global_attribute12, global_attribute13, global_attribute14, global_attribute15, global_attribute16, global_attribute17, global_attribute18, global_attribute19, global_attribute20, last_update_date, last_updated_by, last_update_login, created_by, creation_date, entered_by, tp_header_id, ece_tp_location_code, object_version_number, timezone_code from hr_locations_all where nvl (business_group_id, nvl(hr_general.get_business_group_id, -99) ) = nvl (hr_general.get_business_group_id, -99)
View Text - HTML Formatted

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