[Home] [Help] [Dependency Information]
Object Name: | PAY_US_TAX_LOCALITY_NAMES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is used for displaying locality details in SOE
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STATE_ABBREV | VARCHAR2 | (2) | Short name of the state in two character format. | |
STATE_CODE | VARCHAR2 | (2) | State code | |
COUNTY_NAME | VARCHAR2 | (30) | County name | |
SCHOOL_DISTRICT_NAME | VARCHAR2 | (15) | School district name | |
CITY_NAME | VARCHAR2 | (30) | City name | |
JURISDICTION_CODE | VARCHAR2 | (11) | Jurisdiction code, combination of State code, County code and City code. Displayed in STATE_CODE-COUNTY_CODE-CITY_CODE format | |
LOCALITY_TYPE | VARCHAR2 | (15) | Type of the locality, for ex : COUNTY or SCHOOL_DISTRICT or CITY |
Cut, paste (and edit) the following text to query this object:
SELECT STATE_ABBREV
, STATE_CODE
, COUNTY_NAME
, SCHOOL_DISTRICT_NAME
, CITY_NAME
, JURISDICTION_CODE
, LOCALITY_TYPE
FROM APPS.PAY_US_TAX_LOCALITY_NAMES_V;
APPS.PAY_US_TAX_LOCALITY_NAMES_V is not referenced by any database object
|
|
|