[Home] [Help]
View: PA_LOCATIONS_V_R
Product: | PA - Projects |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT L.ROWID
, L.LOCATION_ID
, L.CITY
, L.REGION
, L.COUNTRY_CODE
, T.TERRITORY_SHORT_NAME
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.CREATED_BY
, L.LAST_UPDATE_LOGIN
FROM FND_TERRITORIES_VL T
, PA_LOCATIONS L
WHERE T.TERRITORY_CODE = L.COUNTRY_CODE
Columns
Name |
ROW_ID |
LOCATION_ID |
CITY |
REGION |
COUNTRY_CODE |
COUNTRY_NAME |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
LAST_UPDATE_LOGIN |