[Home] [Help] [Dependency Information]
Object Name: | CSP_RS_ADDRESS_UI_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
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 |
---|---|---|---|---|
RESOURCE_TYPE | VARCHAR2 | (30) | Yes | Resource type |
RESOURCE_ID | NUMBER | (35) | Yes | Resource identifier |
HR_LOC_ID | NUMBER | Yes | HR location identifier | |
HZ_LOC_ID | NUMBER | (15) | Yes | HZ location identifier |
TIME_ZONE | VARCHAR2 | (50) | Time zone | |
TIME_ZONE_NAME | VARCHAR2 | (80) | Time zone code | |
TIMEZONE_MODIFIED | CHAR | (1) | Time zone modified | |
PRIMARY_FLAG | VARCHAR2 | (1) | Primary address flag | |
PRIMARY_FLAG_MODIFIED | CHAR | (1) | Primary address flag modified | |
INACTIVE_FLAG | VARCHAR2 | (1) | Inactive flag | |
INACTIVE_MODIFIED | CHAR | (1) | Inactive flag modified | |
DEFAULT_TRIP_FLAG | VARCHAR2 | (1) | Trip starting address | |
DEFAULT_TRIP_MODIFIED | CHAR | (1) | Trip starting address modified | |
ADDRESS_LINE_1 | VARCHAR2 | (240) | Address line 1 | |
ADDRESS_LINE_2 | VARCHAR2 | (240) | Address line 2 | |
ADDRESS_LINE_3 | VARCHAR2 | (240) | Address line 3 | |
TOWN_OR_CITY | VARCHAR2 | (30) | City | |
POSTAL_CODE | VARCHAR2 | (30) | Postal code | |
COUNTRY | VARCHAR2 | (60) | Country code | |
COUNTRY_NAME | VARCHAR2 | (80) | Yes | Country name |
REGION_1 | VARCHAR2 | (120) | Region 1 | |
ORG_ID | NUMBER | Operating unit |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_TYPE
, RESOURCE_ID
, HR_LOC_ID
, HZ_LOC_ID
, TIME_ZONE
, TIME_ZONE_NAME
, TIMEZONE_MODIFIED
, PRIMARY_FLAG
, PRIMARY_FLAG_MODIFIED
, INACTIVE_FLAG
, INACTIVE_MODIFIED
, DEFAULT_TRIP_FLAG
, DEFAULT_TRIP_MODIFIED
, ADDRESS_LINE_1
, ADDRESS_LINE_2
, ADDRESS_LINE_3
, TOWN_OR_CITY
, POSTAL_CODE
, COUNTRY
, COUNTRY_NAME
, REGION_1
, ORG_ID
FROM APPS.CSP_RS_ADDRESS_UI_V;
APPS.CSP_RS_ADDRESS_UI_V is not referenced by any database object
|
|
|