[Home] [Help]
View: HR_LOCATIONS_ALL_PO_V
View Text
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
FROM HR_LOCATIONS HRL
Columns
Name |
LOCATION_CODE |
DESCRIPTION |
ADDRESS_LINE_1 |
TOWN_OR_CITY |
REGION |
INVENTORY_ORGANIZATION_ID |
LOCATION_ID |
TAX_NAME |
RECEIVING_SITE_FLAG |
SHIP_TO_SITE_FLAG |
BILL_TO_SITE_FLAG |
INACTIVE_DATE |