VIEW: ICX.POR_LOCATION_LOADER_VALUES#

Source

View Text - Preformatted

select LOCATION_CODE LOCATION_CODE, BUSINESS_GROUP BUSINESS_GROUP, EFFECTIVE_DATE EFFECTIVE_DATE, DESCRIPTION DESCRIPTION, ADDRESS_STYLE ADDRESS_STYLE, ADDRESS_LINE_1 ADDRESS_LINE_1, ADDRESS_LINE_2 ADDRESS_LINE_2, ADDRESS_LINE_3 ADDRESS_LINE_3, CITY CITY, COUNTY COUNTY, STATE STATE, POSTAL_CODE POSTAL_CODE, COUNTRY COUNTRY, TELEPHONE TELEPHONE, FAX FAX, SHIP_TO_LOCATION SHIP_TO_LOCATION, SHIP_TO_FLAG SHIP_TO_FLAG, BILL_TO_FLAG BILL_TO_FLAG, RECEIVING_TO_FLAG RECEIVING_TO_FLAG, OFFICE_SITE OFFICE_SITE, INTERNAL_SITE INTERNAL_SITE, INVENTORY_ORG INVENTORY_ORG, TAX_NAME TAX_NAME, LOADER_STATUS LOADER_STATUS, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY from "ICX"."POR_LOCATION_LOADER_VALUES"

View Text - HTML Formatted

SELECT LOCATION_CODE LOCATION_CODE
, BUSINESS_GROUP BUSINESS_GROUP
, EFFECTIVE_DATE EFFECTIVE_DATE
, DESCRIPTION DESCRIPTION
, ADDRESS_STYLE ADDRESS_STYLE
, ADDRESS_LINE_1 ADDRESS_LINE_1
, ADDRESS_LINE_2 ADDRESS_LINE_2
, ADDRESS_LINE_3 ADDRESS_LINE_3
, CITY CITY
, COUNTY COUNTY
, STATE STATE
, POSTAL_CODE POSTAL_CODE
, COUNTRY COUNTRY
, TELEPHONE TELEPHONE
, FAX FAX
, SHIP_TO_LOCATION SHIP_TO_LOCATION
, SHIP_TO_FLAG SHIP_TO_FLAG
, BILL_TO_FLAG BILL_TO_FLAG
, RECEIVING_TO_FLAG RECEIVING_TO_FLAG
, OFFICE_SITE OFFICE_SITE
, INTERNAL_SITE INTERNAL_SITE
, INVENTORY_ORG INVENTORY_ORG
, TAX_NAME TAX_NAME
, LOADER_STATUS LOADER_STATUS
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
FROM "ICX"."POR_LOCATION_LOADER_VALUES"