[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IEC_VAL_ENTRY_CACHE |
|---|---|
| Object Type: | TABLE |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
APPS.IEC_VAL_ENTRY_CACHE is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
| Tablespace: |  |
|---|---|
| PCT Free: | 10 |
| PCT Used: | 40 |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LIST_ENTRY_ID | NUMBER | (15) | ||
| SUBSET_ID | NUMBER | (15) | ||
| POSTAL_CODE | VARCHAR2 | (100) | ||
| CALLBACK_FLAG | VARCHAR2 | (1) | ||
| NEXT_CALL_TIME | DATE | |||
| DO_NOT_USE_FLAG | VARCHAR2 | (1) | ||
| DO_NOT_USE_REASON | NUMBER | |||
| RECORD_OUT_FLAG | VARCHAR2 | (1) | ||
| RECORD_RELEASE_TIME | DATE | |||
| PREV_STATUS_CODE | VARCHAR2 | (32) | ||
| CURR_CP_INDEX | NUMBER | |||
| CURR_CP_ID | NUMBER | |||
| CURR_CP_TIME_ZONE | NUMBER | |||
| CURR_CP_COUNTRY_CODE | VARCHAR2 | (30) | ||
| CURR_CP_AREA_CODE | NUMBER | |||
| CURR_CP_PHONE_NUMBER | VARCHAR2 | (60) | ||
| CURR_CP_RAW_PHONE_NUMBER | VARCHAR2 | (60) | ||
| CURR_CP_TERRITORY_CODE | VARCHAR2 | (2) | ||
| CURR_CP_REGION_ID | NUMBER | (15) | ||
| CURR_CP_MKTG_ITEM_CC_TZS_ID | NUMBER | (15) | ||
| CURR_CP_PHONE_LINE_TYPE | VARCHAR2 | (30) | ||
| CURR_CP_CONTACT_POINT_PURPOSE | VARCHAR2 | (30) | ||
| CONTACT_POINT_ID_S1 | NUMBER | (15) | ||
| TIME_ZONE_S1 | VARCHAR2 | (500) | ||
| PHONE_COUNTRY_CODE_S1 | VARCHAR2 | (30) | ||
| PHONE_AREA_CODE_S1 | VARCHAR2 | (500) | ||
| PHONE_NUMBER_S1 | VARCHAR2 | (500) | ||
| RAW_PHONE_NUMBER_S1 | VARCHAR2 | (500) | ||
| TERRITORY_CODE_S1 | VARCHAR2 | (2) | ||
| REGION_ID_S1 | NUMBER | (15) | ||
| MKTG_ITEM_CC_TZS_ID_S1 | NUMBER | (15) | ||
| VALID_FLAG_S1 | VARCHAR2 | (1) | ||
| DO_NOT_USE_REASON_S1 | VARCHAR2 | (30) | ||
| PHONE_LINE_TYPE_S1 | VARCHAR2 | (30) | ||
| CONTACT_POINT_PURPOSE_S1 | VARCHAR2 | (30) | ||
| CONTACT_POINT_ID_S2 | NUMBER | (15) | ||
| TIME_ZONE_S2 | VARCHAR2 | (500) | ||
| PHONE_COUNTRY_CODE_S2 | VARCHAR2 | (30) | ||
| PHONE_AREA_CODE_S2 | VARCHAR2 | (500) | ||
| PHONE_NUMBER_S2 | VARCHAR2 | (500) | ||
| RAW_PHONE_NUMBER_S2 | VARCHAR2 | (500) | ||
| TERRITORY_CODE_S2 | VARCHAR2 | (2) | ||
| REGION_ID_S2 | NUMBER | (15) | ||
| MKTG_ITEM_CC_TZS_ID_S2 | NUMBER | (15) | ||
| VALID_FLAG_S2 | VARCHAR2 | (1) | ||
| DO_NOT_USE_REASON_S2 | VARCHAR2 | (30) | ||
| PHONE_LINE_TYPE_S2 | VARCHAR2 | (30) | ||
| CONTACT_POINT_PURPOSE_S2 | VARCHAR2 | (30) | ||
| CONTACT_POINT_ID_S3 | NUMBER | (15) | ||
| TIME_ZONE_S3 | VARCHAR2 | (500) | ||
| PHONE_COUNTRY_CODE_S3 | VARCHAR2 | (30) | ||
| PHONE_AREA_CODE_S3 | VARCHAR2 | (500) | ||
| PHONE_NUMBER_S3 | VARCHAR2 | (500) | ||
| RAW_PHONE_NUMBER_S3 | VARCHAR2 | (500) | ||
| TERRITORY_CODE_S3 | VARCHAR2 | (2) | ||
| REGION_ID_S3 | NUMBER | (15) | ||
| MKTG_ITEM_CC_TZS_ID_S3 | NUMBER | (15) | ||
| VALID_FLAG_S3 | VARCHAR2 | (1) | ||
| DO_NOT_USE_REASON_S3 | VARCHAR2 | (30) | ||
| PHONE_LINE_TYPE_S3 | VARCHAR2 | (30) | ||
| CONTACT_POINT_PURPOSE_S3 | VARCHAR2 | (30) | ||
| CONTACT_POINT_ID_S4 | NUMBER | (15) | ||
| TIME_ZONE_S4 | VARCHAR2 | (500) | ||
| PHONE_COUNTRY_CODE_S4 | VARCHAR2 | (30) | ||
| PHONE_AREA_CODE_S4 | VARCHAR2 | (500) | ||
| PHONE_NUMBER_S4 | VARCHAR2 | (500) | ||
| RAW_PHONE_NUMBER_S4 | VARCHAR2 | (500) | ||
| TERRITORY_CODE_S4 | VARCHAR2 | (2) | ||
| REGION_ID_S4 | NUMBER | (15) | ||
| MKTG_ITEM_CC_TZS_ID_S4 | NUMBER | (15) | ||
| VALID_FLAG_S4 | VARCHAR2 | (1) | ||
| DO_NOT_USE_REASON_S4 | VARCHAR2 | (30) | ||
| PHONE_LINE_TYPE_S4 | VARCHAR2 | (30) | ||
| CONTACT_POINT_PURPOSE_S4 | VARCHAR2 | (30) | ||
| CONTACT_POINT_ID_S5 | NUMBER | (15) | ||
| TIME_ZONE_S5 | VARCHAR2 | (500) | ||
| PHONE_COUNTRY_CODE_S5 | VARCHAR2 | (30) | ||
| PHONE_AREA_CODE_S5 | VARCHAR2 | (500) | ||
| PHONE_NUMBER_S5 | VARCHAR2 | (500) | ||
| RAW_PHONE_NUMBER_S5 | VARCHAR2 | (500) | ||
| TERRITORY_CODE_S5 | VARCHAR2 | (2) | ||
| REGION_ID_S5 | NUMBER | (15) | ||
| MKTG_ITEM_CC_TZS_ID_S5 | NUMBER | (15) | ||
| VALID_FLAG_S5 | VARCHAR2 | (1) | ||
| DO_NOT_USE_REASON_S5 | VARCHAR2 | (30) | ||
| PHONE_LINE_TYPE_S5 | VARCHAR2 | (30) | ||
| CONTACT_POINT_PURPOSE_S5 | VARCHAR2 | (30) | ||
| CONTACT_POINT_ID_S6 | NUMBER | (15) | ||
| TIME_ZONE_S6 | VARCHAR2 | (500) | ||
| PHONE_COUNTRY_CODE_S6 | VARCHAR2 | (30) | ||
| PHONE_AREA_CODE_S6 | VARCHAR2 | (500) | ||
| PHONE_NUMBER_S6 | VARCHAR2 | (500) | ||
| RAW_PHONE_NUMBER_S6 | VARCHAR2 | (500) | ||
| TERRITORY_CODE_S6 | VARCHAR2 | (2) | ||
| REGION_ID_S6 | NUMBER | (15) | ||
| MKTG_ITEM_CC_TZS_ID_S6 | NUMBER | (15) | ||
| VALID_FLAG_S6 | VARCHAR2 | (1) | ||
| DO_NOT_USE_REASON_S6 | VARCHAR2 | (30) | ||
| PHONE_LINE_TYPE_S6 | VARCHAR2 | (30) | ||
| CONTACT_POINT_PURPOSE_S6 | VARCHAR2 | (30) | ||
| SECURITY_GROUP_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT LIST_ENTRY_ID
, SUBSET_ID
, POSTAL_CODE
, CALLBACK_FLAG
, NEXT_CALL_TIME
, DO_NOT_USE_FLAG
, DO_NOT_USE_REASON
, RECORD_OUT_FLAG
, RECORD_RELEASE_TIME
, PREV_STATUS_CODE
, CURR_CP_INDEX
, CURR_CP_ID
, CURR_CP_TIME_ZONE
, CURR_CP_COUNTRY_CODE
, CURR_CP_AREA_CODE
, CURR_CP_PHONE_NUMBER
, CURR_CP_RAW_PHONE_NUMBER
, CURR_CP_TERRITORY_CODE
, CURR_CP_REGION_ID
, CURR_CP_MKTG_ITEM_CC_TZS_ID
, CURR_CP_PHONE_LINE_TYPE
, CURR_CP_CONTACT_POINT_PURPOSE
, CONTACT_POINT_ID_S1
, TIME_ZONE_S1
, PHONE_COUNTRY_CODE_S1
, PHONE_AREA_CODE_S1
, PHONE_NUMBER_S1
, RAW_PHONE_NUMBER_S1
, TERRITORY_CODE_S1
, REGION_ID_S1
, MKTG_ITEM_CC_TZS_ID_S1
, VALID_FLAG_S1
, DO_NOT_USE_REASON_S1
, PHONE_LINE_TYPE_S1
, CONTACT_POINT_PURPOSE_S1
, CONTACT_POINT_ID_S2
, TIME_ZONE_S2
, PHONE_COUNTRY_CODE_S2
, PHONE_AREA_CODE_S2
, PHONE_NUMBER_S2
, RAW_PHONE_NUMBER_S2
, TERRITORY_CODE_S2
, REGION_ID_S2
, MKTG_ITEM_CC_TZS_ID_S2
, VALID_FLAG_S2
, DO_NOT_USE_REASON_S2
, PHONE_LINE_TYPE_S2
, CONTACT_POINT_PURPOSE_S2
, CONTACT_POINT_ID_S3
, TIME_ZONE_S3
, PHONE_COUNTRY_CODE_S3
, PHONE_AREA_CODE_S3
, PHONE_NUMBER_S3
, RAW_PHONE_NUMBER_S3
, TERRITORY_CODE_S3
, REGION_ID_S3
, MKTG_ITEM_CC_TZS_ID_S3
, VALID_FLAG_S3
, DO_NOT_USE_REASON_S3
, PHONE_LINE_TYPE_S3
, CONTACT_POINT_PURPOSE_S3
, CONTACT_POINT_ID_S4
, TIME_ZONE_S4
, PHONE_COUNTRY_CODE_S4
, PHONE_AREA_CODE_S4
, PHONE_NUMBER_S4
, RAW_PHONE_NUMBER_S4
, TERRITORY_CODE_S4
, REGION_ID_S4
, MKTG_ITEM_CC_TZS_ID_S4
, VALID_FLAG_S4
, DO_NOT_USE_REASON_S4
, PHONE_LINE_TYPE_S4
, CONTACT_POINT_PURPOSE_S4
, CONTACT_POINT_ID_S5
, TIME_ZONE_S5
, PHONE_COUNTRY_CODE_S5
, PHONE_AREA_CODE_S5
, PHONE_NUMBER_S5
, RAW_PHONE_NUMBER_S5
, TERRITORY_CODE_S5
, REGION_ID_S5
, MKTG_ITEM_CC_TZS_ID_S5
, VALID_FLAG_S5
, DO_NOT_USE_REASON_S5
, PHONE_LINE_TYPE_S5
, CONTACT_POINT_PURPOSE_S5
, CONTACT_POINT_ID_S6
, TIME_ZONE_S6
, PHONE_COUNTRY_CODE_S6
, PHONE_AREA_CODE_S6
, PHONE_NUMBER_S6
, RAW_PHONE_NUMBER_S6
, TERRITORY_CODE_S6
, REGION_ID_S6
, MKTG_ITEM_CC_TZS_ID_S6
, VALID_FLAG_S6
, DO_NOT_USE_REASON_S6
, PHONE_LINE_TYPE_S6
, CONTACT_POINT_PURPOSE_S6
, SECURITY_GROUP_ID
FROM APPS.IEC_VAL_ENTRY_CACHE;
APPS.IEC_VAL_ENTRY_CACHE does not reference any database object
APPS.IEC_VAL_ENTRY_CACHE is referenced by following:
APPS
IEC_VALIDATE_PVT
- show dependent code
|
|
|
|