[Home] [Help]
[Dependency Information]
| Object Name: | HXC_TK_PAY_LOCATIONS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | HXC.HXC_TK_PAY_LOCATIONS
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LOCATION | VARCHAR2 | (105) | ||
| STATE_ID | VARCHAR2 | (2) | Yes | |
| STATE | VARCHAR2 | (25) | Yes | |
| COUNTY | VARCHAR2 | (30) | Yes | |
| CITY | VARCHAR2 | (30) | Yes | |
| ZIP | VARCHAR2 | (10) | Yes | |
| ZIP_END | VARCHAR2 | (10) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT LOCATION
, STATE_ID
, STATE
, COUNTY
, CITY
, ZIP
, ZIP_END
FROM APPS.HXC_TK_PAY_LOCATIONS;
APPS
PAY_US_CITY_NAMES
PAY_US_COUNTIES
PAY_US_STATES
PAY_US_ZIP_CODES
APPS.HXC_TK_PAY_LOCATIONS is not referenced by any database object
|
|
|
|