[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:
|
|
|