IBE Tables (41)
IBE - iStore — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
IBE_ACTIVE_QUOTES_ALL |
15 | Table to track the active carts for a given party and cust account. |
IBE_CT_IMEDIA_SEARCH |
17 | This table is used by iStore for searching products |
IBE_CT_RELATED_ITEMS |
16 | Precomputed product relationships derived from mapping relationship rules |
IBE_CT_RELATION_RULES |
31 | Mapping or SQL rules that define product relationships |
IBE_CT_REL_EXCLUSIONS |
11 | Exclusion of precomputed product relationships generated from mapping relationship rules |
IBE_DSP_CONTEXT_B |
13 | Stores the display contexts associated with templates and media attributes for media. |
IBE_DSP_CONTEXT_TL |
13 | Translations for IBE_DSP_CONTEXT_B. |
IBE_DSP_LGL_PHYS_MAP |
16 | Stores the logical to physical media mapping based on site and language |
IBE_DSP_MSITE_SCT_ITEMS |
12 | This table stores the assocation between mini-site and items. |
IBE_DSP_MSITE_SCT_SECTS |
17 | This table stores the association between mini-site and sections. |
IBE_DSP_OBJ_LGL_CTNT |
12 | This table Contains the default logical items for selected display context labels and objects |
IBE_DSP_SECTIONS_B |
36 | This table stores information about the sections. |
IBE_DSP_SECTIONS_TL |
15 | This table stores the translatable information about the sections. |
IBE_DSP_SECTION_ITEMS |
16 | This table stores the association between sections and items. |
IBE_DSP_TPL_CTG |
10 | This table stores the category to logical template mappings |
IBE_ECR_MVLOG |
27 | Materialized view refresh history log table. |
IBE_ECR_ORDERS_FACT |
24 | Granular aggregate information of Orders for a given period. |
IBE_ECR_ORDER_HEADERS_FACT |
25 | Fact table to collect data for Booked Orders. |
IBE_ECR_QUOTES_FACT |
21 | Granular aggregate information about quotes for a given period. |
IBE_LEAD_IMPORT_DETAILS |
27 | This table contains the details of the Leads Imported. |
IBE_LEAD_IMPORT_LOG |
17 | This table contains the log information for Leads that are imported. |
IBE_MIGRATION_HISTORY |
9 | Table to Keep track of migration History. |
IBE_MIGRATION_LOG |
31 | Table to Keep track of migration data for Recovery Purposes |
IBE_MSITES_B |
48 | Stores Mini Site (Specialty Stores) Information. |
IBE_MSITES_TL |
13 | Translations for IBE_MSITES_B |
IBE_MSITE_CURRENCIES |
16 | Stores the currencies supported by the mini-sites |
IBE_MSITE_INFORMATION |
46 | This Table Stores Additional Information about Specialty Stores |
IBE_MSITE_LANGUAGES |
11 | Stores the languages supported by the mini-sites |
IBE_MSITE_ORGS |
10 | Define the organizations supported by the mini-sites |
IBE_MSITE_PRTY_ACCSS |
12 | Defines the parties supported by the Specialty Stores |
IBE_MSITE_RESPS_B |
15 | Defines the responsibilities supported by the Specialty Store. |
IBE_MSITE_RESPS_TL |
11 | Translations for JTF_MSITE_RESPS_B |
IBE_ORD_ONECLICK_ALL |
36 | Express checkout settings for registered customers |
IBE_SECTION_SEARCH |
11 | The search table for restricting search to section(s). |
IBE_SECTION_SEARCH_PART |
11 | |
IBE_SHP_LIST_ITEMS_ALL |
39 | Stores Shopping List Items details. |
IBE_SH_QUOTE_ACCESS |
21 | Stores shopping cart (quote) access details |
IBE_SH_SHLITEM_RELS |
15 | Stores relationships between different Shopping List Items. |
IBE_SH_SHP_LISTS_ALL |
33 | Stores Shopping Lists details. |
IBE_WF_NOTIF_MSG_MAPS |
20 | This table contains information about message mappings for each notification. |
IBE_WF_NOTIF_SETUP |
17 | This table stores information about supported Work Flow notifications in iStore. |