[Home] [Help]
View: POS_PO_LOCATION_DETAIL_V
View Text
SELECT HRL.LOCATION_ID
, HRL.LOCATION_CODE
, HRL.ADDRESS_LINE_1
, HRL.ADDRESS_LINE_2
, HRL.ADDRESS_LINE_3
, (HRL.TOWN_OR_CITY ||'
, '|| DECODE(HRL.STYLE
, 'US'
, HRL.REGION_2
, HRL.REGION_1) ||'
, '||POSTAL_CODE)
, HRL.COUNTRY
FROM HR_LOCATIONS_ALL HRL
Columns
Name |
LOCATION_ID |
LOCATION_CODE |
ADDRESS_LINE1 |
ADDRESS_LINE2 |
ADDRESS_LINE3 |
CITY_STATE_ZIP |
COUNTRY |