[Home] [Help]
View: HR_LOCATIONS_LOV_V
Product: | PER - Human Resources |
Description: | HR Web Offers list of values view. |
Implementation/DBA Data: |
APPS.HR_LOCATIONS_LOV_V
|
View Text
SELECT LOCATION_ID
, LOCATION_CODE
, ADDRESS_LINE_1||'.'|| ADDRESS_LINE_2||'.'|| ADDRESS_LINE_3||'.'||TOWN_OR_CITY ||'.'||REGION_1||'.'||REGION_2||'.'||REGION_3||'.'||POSTAL_CODE||'.'||COUNTRY ADDRESS
, DESCRIPTION
, INACTIVE_DATE
FROM HR_LOCATIONS
WHERE LOCATION_USE = 'HR'
Columns
Name |
LOCATION_ID |
LOCATION_CODE |
ADDRESS |
DESCRIPTION |
INACTIVE_DATE |