[Home] [Help]
[Dependency Information]
| Object Name: | RRS_SITE_PHONE_REC |
|---|---|
| Object Type: | TYPE |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Type Code: | OBJECT |
|---|---|
| Predefined: | NO |
| Incomplete: | NO |
| Name | Datatype | Length | Prcn |
|---|---|---|---|
| CONTACT_POINT_ID | NUMBER |
|
|
| CONTACT_POINT_TYPE | VARCHAR2 | (30) | |
| STATUS | VARCHAR2 | (30) | |
| OWNER_TABLE_NAME | VARCHAR2 | (30) | |
| OWNER_TABLE_ID | NUMBER |
|
|
| PRIMARY_FLAG | VARCHAR2 | (30) | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | |
| PHONE_CALLING_CALENDAR | VARCHAR2 | (30) | |
| LAST_CONTACT_DT_TIME | DATE |
|
|
| PHONE_PREFERRED_ORDER | NUMBER |
|
|
| PRIORITY_OF_USE_CODE | VARCHAR2 | (30) | |
| TELEPHONE_TYPE | VARCHAR2 | (30) | |
| TIME_ZONE | NUMBER |
|
|
| PHONE_TOUCH_TONE_TYPE_FLAG | VARCHAR2 | (1) | |
| PHONE_AREA_CODE | VARCHAR2 | (10) | |
| PHONE_COUNTRY_CODE | VARCHAR2 | (10) | |
| PHONE_NUMBER | VARCHAR2 | (40) | |
| PHONE_EXTENSION | VARCHAR2 | (20) | |
| PHONE_LINE_TYPE | VARCHAR2 | (30) | |
| CONTENT_SOURCE_TYPE | VARCHAR2 | (30) | |
| RAW_PHONE_NUMBER | VARCHAR2 | (60) | |
| TIMEZONE_ID | NUMBER |
|
|
| TIMEZONE_NAME | VARCHAR2 | (80) | |
| CONTACT_POINT_PURPOSE | VARCHAR2 | (30) | |
| PRIMARY_BY_PURPOSE | VARCHAR2 | (30) | |
| TRANSPOSED_PHONE_NUMBER | VARCHAR2 | (60) | |
| ACTUAL_CONTENT_SOURCE | VARCHAR2 | (30) |
SYS
STANDARD
- show dependent code
APPS
RRS_SITE_INFO
- show dependent code
RRS_SITE_PHONE_TAB
|
|
|
|