VIEW: APPS.ICX_HR_LOCATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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