DBA Data[Home] [Help]

VIEW: APPS.PA_ONLINE_LOCATIONS_V

Source

View Text - Preformatted

SELECT l.location_id, l.location_code location_code, l.description location_description, l.inactive_date from hr_locations l WHERE l.location_use = 'HR'
View Text - HTML Formatted

SELECT L.LOCATION_ID
, L.LOCATION_CODE LOCATION_CODE
, L.DESCRIPTION LOCATION_DESCRIPTION
, L.INACTIVE_DATE
FROM HR_LOCATIONS L
WHERE L.LOCATION_USE = 'HR'