FND Design Data [Home] [Help]

View: HR_LOCATIONS_NO_JOIN

Product: PER - Human Resources
Description: USed to support user interface.
Implementation/DBA Data: ViewAPPS.HR_LOCATIONS_NO_JOIN
View Text

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
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)

Columns

Name
LOCATION_ID
LOCATION_CODE
BUSINESS_GROUP_ID
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