View: PO_HR_LOCATIONS

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PO_HR_LOCATIONS

View Text

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

Columns