SELECT HRL.LOCATION_CODE , HRL.DESCRIPTION , HRL.ADDRESS_LINE_1 , HRL.TOWN_OR_CITY , DECODE(HRL.STYLE,'US',HRL.REGION_2,HRL.REGION_1) REGION , HRL.INVENTORY_ORGANIZATION_ID , HRL.LOCATION_ID , HRL.TAX_NAME , HRL.RECEIVING_SITE_FLAG , HRL.SHIP_TO_SITE_FLAG , HRL.BILL_TO_SITE_FLAG , HRL.INACTIVE_DATE , HRL.TIMEZONE_CODE FROM HR_LOCATIONS HRL
SELECT HRL.LOCATION_CODE
, HRL.DESCRIPTION
, HRL.ADDRESS_LINE_1
, HRL.TOWN_OR_CITY
, DECODE(HRL.STYLE
, 'US'
, HRL.REGION_2
, HRL.REGION_1) REGION
, HRL.INVENTORY_ORGANIZATION_ID
, HRL.LOCATION_ID
, HRL.TAX_NAME
, HRL.RECEIVING_SITE_FLAG
, HRL.SHIP_TO_SITE_FLAG
, HRL.BILL_TO_SITE_FLAG
, HRL.INACTIVE_DATE
, HRL.TIMEZONE_CODE
FROM HR_LOCATIONS HRL
|
|
|