Product: | ICX - Oracle iProcurement |
---|---|
Description: | Obsolete |
Implementation/DBA Data: | APPS.ICX_HR_LOCATIONS_V |
SELECT "LOCATION_ID"
, "ENTERED_BY"
, "LOCATION_CODE"
, "ADDRESS_LINE_1"
, "ADDRESS_LINE_2"
, "ADDRESS_LINE_3"
, "BILL_TO_SITE_FLAG"
, "COUNTRY"
, "DESCRIPTION"
, "DESIGNATED_RECEIVER_ID"
, "IN_ORGANIZATION_FLAG"
, "INACTIVE_DATE"
, "INVENTORY_ORGANIZATION_ID"
, "OFFICE_SITE_FLAG"
, "POSTAL_CODE"
, "RECEIVING_SITE_FLAG"
, "REGION_1"
, "REGION_2"
, "REGION_3"
, "SHIP_TO_LOCATION_ID"
, "SHIP_TO_SITE_FLAG"
, "STYLE"
, "TAX_NAME"
, "TELEPHONE_NUMBER_1"
, "TELEPHONE_NUMBER_2"
, "TELEPHONE_NUMBER_3"
, "TOWN_OR_CITY"
, "ATTRIBUTE_CATEGORY"
, "ATTRIBUTE1"
, "ATTRIBUTE2"
, "ATTRIBUTE3"
, "ATTRIBUTE4"
, "ATTRIBUTE5"
, "ATTRIBUTE6"
, "ATTRIBUTE7"
, "ATTRIBUTE8"
, "ATTRIBUTE9"
, "ATTRIBUTE10"
, "ATTRIBUTE11"
, "ATTRIBUTE12"
, "ATTRIBUTE13"
, "ATTRIBUTE14"
, "ATTRIBUTE15"
, "ATTRIBUTE16"
, "ATTRIBUTE17"
, "ATTRIBUTE18"
, "ATTRIBUTE19"
, "ATTRIBUTE20"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_LOGIN"
, "CREATED_BY"
, "CREATION_DATE"
FROM HR_LOCATIONS