View: WSH_HR_LOCATIONS_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_HR_LOCATIONS_V

View Text

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

Columns