[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 |