[Home] [Help]
[Dependency Information]
| Object Name: | PA_RES_ADDRESSES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PA.PA_RES_ADDRESSES_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 |
|---|---|---|---|---|
| RESOURCE_SOURCE_ID | NUMBER | (10) | Yes | |
| RESOURCE_NAME | VARCHAR2 | (240) | ||
| ADDRESS_TYPE | VARCHAR2 | (30) | ||
| COUNTRY | VARCHAR2 | (80) | Yes | |
| STATE | VARCHAR2 | (120) | ||
| PROVINCE | VARCHAR2 | (120) | ||
| CITY | VARCHAR2 | (30) | ||
| PRIMARY_ADDRESS_FLAG | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_SOURCE_ID
, RESOURCE_NAME
, ADDRESS_TYPE
, COUNTRY
, STATE
, PROVINCE
, CITY
, PRIMARY_ADDRESS_FLAG
FROM APPS.PA_RES_ADDRESSES_V;
APPS
FND_TERRITORIES_TL
HR_GENERAL
- show dependent code
HR_PERSON_NAME
- show dependent code
HR_SECURITY
- show dependent code
PER_ADDRESSES
PER_PEOPLE_F
APPS.PA_RES_ADDRESSES_V is not referenced by any database object
|
|
|
|