eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PO_HR_LOCATIONS

Source

View Text - Preformatted


SELECT 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.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 from hr_locations_all loc, hr_locations_all_tl lot where nvl (loc.business_group_id, nvl(hr_general.get_business_group_id, -99) ) = nvl (hr_general.get_business_group_id, -99) and loc.location_id = lot.location_id and lot.language = userenv('LANG') UNION ALL select hz.location_id location_id, NULL location_code , 'TCA' location_use, to_number(null) business_group_id, /* business_group_id */ substr(hz.address1,1,50) description, /* description */ hz.location_id ship_to_location_id, /* ship_to_location_id */ 'Y' ship_to_site_flag, /* ship_to_site_flag */ 'Y' receiving_site_flag,/* receiving_site_flag */ 'N' bill_to_site_flag,/* bill_to_site_flag */ 'N' in_organization_flag,/* in_organization_flag */ 'N' office_site_flag, /* office_site_flag */ to_number(null) designated_receiver_id,/* designated_receiver_id */ to_number(null) inventory_organization_id,/* inventory_organization_id */ null tax_name, /* tax_name */ hz.address_expiration_date inactive_date , /* inactive_date */ decode (hz.address_style, 'US', 'US', 'GENERIC') style,/* style */ hz.address1 address_line_1, /* address_line_1 */ hz.address2 address_line_2,/* address_line_2 */ hz.address3 address_line_3, /* address_line_3 */ hz.city town_or_city,/* town_or_city */ hz.country country,/* country */ hz.postal_code postal_code, /* postal_code */ hz.county region_1, /* region_1 */ hz.state region_2, /* region_2 */ hz.province region_3, /* region_3 */ null telephone_number_1, /* telephone_number_1 */ null telephone_number_2, /* telephone_number_2 */ null telephone_number_3, /* telephone_number_3 */ hz.address4 loc_information13, /* loc_information13 */ null loc_information14,/* loc_information14 */ null loc_information15,/* loc_information15 */ null loc_information16 ,/* loc_information16 */ null loc_information17,/* loc_information17 */ null loc_information18,/* loc_information18 */ null loc_information19,/* loc_information19 */ null loc_information20 ,/* loc_information20 */ null attribute_category,/* attribute_category */ null attribute1,/* attribute1 */ null attribute2 ,/* attribute2 */ null attribute3 , /* attribute3 */ null attribute4, /* attribute4 */ null attribute5, /* attribute5 */ null attribute6, /* attribute6 */ null attribute7, /* attribute7 */ null attribute8, /* attribute8 */ null attribute9, /* attribute9 */ null attribute10, /* attribute10 */ null attribute11, /* attribute11 */ null attribute12, /* attribute12 */ null attribute13, /* attribute13 */ null attribute14, /* attribute14 */ null attribute15 , /* attribute15 */ null attribute16, /* attribute16 */ null attribute17, /* attribute17 */ null attribute18, /* attribute18 */ null attribute19, /* attribute19 */ null attribute20, /* attribute20 */ null global_attribute_category, /* global_attribute_category */ null global_attribute1, /* global_attribute1 */ null global_attribute2, /* global_attribute2 */ null global_attribute3, /* global_attribute3 */ null global_attribute4, /* global_attribute4 */ null global_attribute5, /* global_attribute5 */ null global_attribute6, /* global_attribute6 */ null global_attribute7, /* global_attribute7 */ null global_attribute8 , /* global_attribute8 */ null global_attribute9 , /* global_attribute9 */ null global_attribute10, /* global_attribute10 */ null global_attribute11 , /* global_attribute11 */ null global_attribute12, /* global_attribute12 */ null global_attribute13, /* global_attribute13 */ null global_attribute14, /* global_attribute14 */ null global_attribute15, /* global_attribute15 */ null global_attribute16, /* global_attribute16 */ null global_attribute17, /* global_attribute17 */ null global_attribute18, /* global_attribute18 */ null global_attribute19, /* global_attribute19 */ null global_attribute20, /* global_attribute20 */ hz.last_update_date last_update_date, /* last_update_date */ hz.last_updated_by last_updated_by, /* last_updated_by */ hz.last_update_login last_update_login, /* last_update_login */ hz.created_by created_by, /* created_by */ hz.creation_date creation_date, /* creation_date */ hz.created_by entered_by, /* entered_by */ to_number(null) tp_header_id, /* tp_header_id */ null ece_tp_location_code, /* ece_tp_location_code */ 1 object_version_number /* object_version_number */ from hz_locations hz

View Text - HTML Formatted

SELECT 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.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
FROM HR_LOCATIONS_ALL LOC
, HR_LOCATIONS_ALL_TL LOT
WHERE NVL (LOC.BUSINESS_GROUP_ID
, NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99) ) = NVL (HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99)
AND LOC.LOCATION_ID = LOT.LOCATION_ID
AND LOT.LANGUAGE = USERENV('LANG') UNION ALL SELECT HZ.LOCATION_ID LOCATION_ID
, NULL LOCATION_CODE
, 'TCA' LOCATION_USE
, TO_NUMBER(NULL) BUSINESS_GROUP_ID
, /* BUSINESS_GROUP_ID */ SUBSTR(HZ.ADDRESS1
, 1
, 50) DESCRIPTION
, /* DESCRIPTION */ HZ.LOCATION_ID SHIP_TO_LOCATION_ID
, /* SHIP_TO_LOCATION_ID */ 'Y' SHIP_TO_SITE_FLAG
, /* SHIP_TO_SITE_FLAG */ 'Y' RECEIVING_SITE_FLAG
, /* RECEIVING_SITE_FLAG */ 'N' BILL_TO_SITE_FLAG
, /* BILL_TO_SITE_FLAG */ 'N' IN_ORGANIZATION_FLAG
, /* IN_ORGANIZATION_FLAG */ 'N' OFFICE_SITE_FLAG
, /* OFFICE_SITE_FLAG */ TO_NUMBER(NULL) DESIGNATED_RECEIVER_ID
, /* DESIGNATED_RECEIVER_ID */ TO_NUMBER(NULL) INVENTORY_ORGANIZATION_ID
, /* INVENTORY_ORGANIZATION_ID */ NULL TAX_NAME
, /* TAX_NAME */ HZ.ADDRESS_EXPIRATION_DATE INACTIVE_DATE
, /* INACTIVE_DATE */ DECODE (HZ.ADDRESS_STYLE
, 'US'
, 'US'
, 'GENERIC') STYLE
, /* STYLE */ HZ.ADDRESS1 ADDRESS_LINE_1
, /* ADDRESS_LINE_1 */ HZ.ADDRESS2 ADDRESS_LINE_2
, /* ADDRESS_LINE_2 */ HZ.ADDRESS3 ADDRESS_LINE_3
, /* ADDRESS_LINE_3 */ HZ.CITY TOWN_OR_CITY
, /* TOWN_OR_CITY */ HZ.COUNTRY COUNTRY
, /* COUNTRY */ HZ.POSTAL_CODE POSTAL_CODE
, /* POSTAL_CODE */ HZ.COUNTY REGION_1
, /* REGION_1 */ HZ.STATE REGION_2
, /* REGION_2 */ HZ.PROVINCE REGION_3
, /* REGION_3 */ NULL TELEPHONE_NUMBER_1
, /* TELEPHONE_NUMBER_1 */ NULL TELEPHONE_NUMBER_2
, /* TELEPHONE_NUMBER_2 */ NULL TELEPHONE_NUMBER_3
, /* TELEPHONE_NUMBER_3 */ HZ.ADDRESS4 LOC_INFORMATION13
, /* LOC_INFORMATION13 */ NULL LOC_INFORMATION14
, /* LOC_INFORMATION14 */ NULL LOC_INFORMATION15
, /* LOC_INFORMATION15 */ NULL LOC_INFORMATION16
, /* LOC_INFORMATION16 */ NULL LOC_INFORMATION17
, /* LOC_INFORMATION17 */ NULL LOC_INFORMATION18
, /* LOC_INFORMATION18 */ NULL LOC_INFORMATION19
, /* LOC_INFORMATION19 */ NULL LOC_INFORMATION20
, /* LOC_INFORMATION20 */ NULL ATTRIBUTE_CATEGORY
, /* ATTRIBUTE_CATEGORY */ NULL ATTRIBUTE1
, /* ATTRIBUTE1 */ NULL ATTRIBUTE2
, /* ATTRIBUTE2 */ NULL ATTRIBUTE3
, /* ATTRIBUTE3 */ NULL ATTRIBUTE4
, /* ATTRIBUTE4 */ NULL ATTRIBUTE5
, /* ATTRIBUTE5 */ NULL ATTRIBUTE6
, /* ATTRIBUTE6 */ NULL ATTRIBUTE7
, /* ATTRIBUTE7 */ NULL ATTRIBUTE8
, /* ATTRIBUTE8 */ NULL ATTRIBUTE9
, /* ATTRIBUTE9 */ NULL ATTRIBUTE10
, /* ATTRIBUTE10 */ NULL ATTRIBUTE11
, /* ATTRIBUTE11 */ NULL ATTRIBUTE12
, /* ATTRIBUTE12 */ NULL ATTRIBUTE13
, /* ATTRIBUTE13 */ NULL ATTRIBUTE14
, /* ATTRIBUTE14 */ NULL ATTRIBUTE15
, /* ATTRIBUTE15 */ NULL ATTRIBUTE16
, /* ATTRIBUTE16 */ NULL ATTRIBUTE17
, /* ATTRIBUTE17 */ NULL ATTRIBUTE18
, /* ATTRIBUTE18 */ NULL ATTRIBUTE19
, /* ATTRIBUTE19 */ NULL ATTRIBUTE20
, /* ATTRIBUTE20 */ NULL GLOBAL_ATTRIBUTE_CATEGORY
, /* GLOBAL_ATTRIBUTE_CATEGORY */ NULL GLOBAL_ATTRIBUTE1
, /* GLOBAL_ATTRIBUTE1 */ NULL GLOBAL_ATTRIBUTE2
, /* GLOBAL_ATTRIBUTE2 */ NULL GLOBAL_ATTRIBUTE3
, /* GLOBAL_ATTRIBUTE3 */ NULL GLOBAL_ATTRIBUTE4
, /* GLOBAL_ATTRIBUTE4 */ NULL GLOBAL_ATTRIBUTE5
, /* GLOBAL_ATTRIBUTE5 */ NULL GLOBAL_ATTRIBUTE6
, /* GLOBAL_ATTRIBUTE6 */ NULL GLOBAL_ATTRIBUTE7
, /* GLOBAL_ATTRIBUTE7 */ NULL GLOBAL_ATTRIBUTE8
, /* GLOBAL_ATTRIBUTE8 */ NULL GLOBAL_ATTRIBUTE9
, /* GLOBAL_ATTRIBUTE9 */ NULL GLOBAL_ATTRIBUTE10
, /* GLOBAL_ATTRIBUTE10 */ NULL GLOBAL_ATTRIBUTE11
, /* GLOBAL_ATTRIBUTE11 */ NULL GLOBAL_ATTRIBUTE12
, /* GLOBAL_ATTRIBUTE12 */ NULL GLOBAL_ATTRIBUTE13
, /* GLOBAL_ATTRIBUTE13 */ NULL GLOBAL_ATTRIBUTE14
, /* GLOBAL_ATTRIBUTE14 */ NULL GLOBAL_ATTRIBUTE15
, /* GLOBAL_ATTRIBUTE15 */ NULL GLOBAL_ATTRIBUTE16
, /* GLOBAL_ATTRIBUTE16 */ NULL GLOBAL_ATTRIBUTE17
, /* GLOBAL_ATTRIBUTE17 */ NULL GLOBAL_ATTRIBUTE18
, /* GLOBAL_ATTRIBUTE18 */ NULL GLOBAL_ATTRIBUTE19
, /* GLOBAL_ATTRIBUTE19 */ NULL GLOBAL_ATTRIBUTE20
, /* GLOBAL_ATTRIBUTE20 */ HZ.LAST_UPDATE_DATE LAST_UPDATE_DATE
, /* LAST_UPDATE_DATE */ HZ.LAST_UPDATED_BY LAST_UPDATED_BY
, /* LAST_UPDATED_BY */ HZ.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, /* LAST_UPDATE_LOGIN */ HZ.CREATED_BY CREATED_BY
, /* CREATED_BY */ HZ.CREATION_DATE CREATION_DATE
, /* CREATION_DATE */ HZ.CREATED_BY ENTERED_BY
, /* ENTERED_BY */ TO_NUMBER(NULL) TP_HEADER_ID
, /* TP_HEADER_ID */ NULL ECE_TP_LOCATION_CODE
, /* ECE_TP_LOCATION_CODE */ 1 OBJECT_VERSION_NUMBER /* OBJECT_VERSION_NUMBER */
FROM HZ_LOCATIONS HZ