[Home] [Help]
[Dependency Information]
| Object Name: | PAY_US_LOCALITIES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PAY.PAY_US_LOCALITIES_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LOCALITY_NAME | VARCHAR2 | (30) | ||
| STATE_NAME | VARCHAR2 | (25) | ||
| COUNTY_NAME | VARCHAR2 | (30) | ||
| LOCALITY_TYPE | VARCHAR2 | (6) | ||
| LOCALITY_GEOCODE | VARCHAR2 | (11) | ||
| STATE_CODE | VARCHAR2 | (2) |
Cut, paste (and edit) the following text to query this object:
SELECT LOCALITY_NAME
, STATE_NAME
, COUNTY_NAME
, LOCALITY_TYPE
, LOCALITY_GEOCODE
, STATE_CODE
FROM APPS.PAY_US_LOCALITIES_V;
APPS
PAY_US_CITY_NAMES
PAY_US_COUNTIES
PAY_US_STATES
PUBLIC
PAY_US_LOCALITIES_V
|
|
|
|