[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JTF_CAL_ADDRESSES |
|---|---|
| Object Type: | TABLE |
| Owner: | JTF |
| FND Design Data: |  JTF.JTF_CAL_ADDRESSES
|
| Subobject Name: | |
| Status: | VALID |
This table is used to store addresses of private contacts, the table is design to make Palm sync possible in the future.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| JTF_CAL_ADDRESSES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ADDRESS_ID
|
| JTF_CAL_ADDRESSES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RESOURCE_ID
|
| JTF_CAL_ADDRESSES_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LAST_NAME
|
| JTF_CAL_ADDRESSES_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FIRST_NAME
|
| JTF_CAL_ADDRESSES_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CATEGORY
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ADDRESS_ID | NUMBER | Yes | Unique Identifier for JTF_CAL_ADDRESSES record | |
| RESOURCE_ID | NUMBER | Yes | Resource ID of person that entered the address | |
| CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
| LAST_NAME | VARCHAR2 | (2000) | Last name of the contact | |
| FIRST_NAME | VARCHAR2 | (2000) | First name of the contact | |
| JOB_TITLE | VARCHAR2 | (2000) | Title of the contact | |
| COMPANY | VARCHAR2 | (2000) | Company the contact works for | |
| PRIMARY_CONTACT | NUMBER | Primary contact | ||
| CONTACT1_TYPE | VARCHAR2 | (2000) | First point of contact type | |
| CONTACT1 | VARCHAR2 | (2000) | First point of contact | |
| CONTACT2_TYPE | VARCHAR2 | (2000) | Second point of contact type | |
| CONTACT2 | VARCHAR2 | (2000) | Second point of contact | |
| CONTACT3_TYPE | VARCHAR2 | (2000) | Third point of contact type | |
| CONTACT3 | VARCHAR2 | (2000) | Third point of contact | |
| CONTACT4_TYPE | VARCHAR2 | (2000) | Fourth point of contact type | |
| CONTACT4 | VARCHAR2 | (2000) | Fourth point of contact | |
| CONTACT5_TYPE | VARCHAR2 | (2000) | Fifth point of contact type | |
| CONTACT5 | VARCHAR2 | (2000) | Fifth point of contact | |
| WWW_ADDRESS | VARCHAR2 | (2000) | Home page | |
| ASSISTANT_NAME | VARCHAR2 | (2000) | Contact's assistant name | |
| ASSISTANT_PHONE | VARCHAR2 | (2000) | Contact's assistant phone number | |
| CATEGORY | NUMBER | Search category for the address | ||
| ADDRESS1 | VARCHAR2 | (2000) | Street address line 1 | |
| ADDRESS2 | VARCHAR2 | (2000) | Street address line 2 | |
| ADDRESS3 | VARCHAR2 | (2000) | Street address line 3 | |
| ADDRESS4 | VARCHAR2 | (2000) | Street address line 4 | |
| CITY | VARCHAR2 | (2000) | City | |
| COUNTY | VARCHAR2 | (2000) | County | |
| STATE | VARCHAR2 | (2000) | State | |
| ZIP | VARCHAR2 | (2000) | Postal code | |
| COUNTRY | VARCHAR2 | (2000) | Country | |
| NOTE | VARCHAR2 | (4000) | Additional information | |
| PRIVATE_FLAG | VARCHAR2 | (1) | Indicates that it is a private address | |
| DELETED_AS_OF | DATE | Used for Palm Synch | ||
| APPLICATION_ID | NUMBER | Application ID | ||
| SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
| OBJECT_VERSION_NUMBER | NUMBER | Check for dirty data in stateless HTML applications |
Cut, paste (and edit) the following text to query this object:
SELECT ADDRESS_ID
, RESOURCE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_NAME
, FIRST_NAME
, JOB_TITLE
, COMPANY
, PRIMARY_CONTACT
, CONTACT1_TYPE
, CONTACT1
, CONTACT2_TYPE
, CONTACT2
, CONTACT3_TYPE
, CONTACT3
, CONTACT4_TYPE
, CONTACT4
, CONTACT5_TYPE
, CONTACT5
, WWW_ADDRESS
, ASSISTANT_NAME
, ASSISTANT_PHONE
, CATEGORY
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, COUNTY
, STATE
, ZIP
, COUNTRY
, NOTE
, PRIVATE_FLAG
, DELETED_AS_OF
, APPLICATION_ID
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM JTF.JTF_CAL_ADDRESSES;
JTF.JTF_CAL_ADDRESSES does not reference any database object
JTF.JTF_CAL_ADDRESSES is referenced by following:
JTF
JTF_CAL_ADDRESSES#
|
|
|
|