[Home] [Help] [Dependency Information]

TABLE: APPS.IEC_VAL_ENTRY_CACHE

Object Details

Temporary Table Details

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.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Query Text

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;

Dependencies

[top of page]

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