[Home] [Help]
View: PA_ONLINE_LOCATIONS_V
Product: | PA - Projects |
Description: | Customizable view for projects used in Self Service Time application.
PA_ONLINE_LOCATIONS_V is a customizable view for Self Service Time application |
Implementation/DBA Data: |
APPS.PA_ONLINE_LOCATIONS_V
|
View Text
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'
Columns
Name |
LOCATION_ID |
LOCATION_CODE |
LOCATION_DESCRIPTION |
INACTIVE_DATE |