Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - IBE Tables and Views

TABLE - IBE.IBE_ACTIVE_QUOTES_ALL
TABLE - IBE.IBE_CT_IMEDIA_SEARCH
TABLE - IBE.IBE_CT_RELATED_ITEMS
TABLE - IBE.IBE_CT_RELATION_RULES
TABLE - IBE.IBE_CT_REL_EXCLUSIONS
TABLE - IBE.IBE_DSP_CONTEXT_B
TABLE - IBE.IBE_DSP_CONTEXT_TL
TABLE - IBE.IBE_DSP_LGL_PHYS_MAP
TABLE - IBE.IBE_DSP_MSITE_SCT_ITEMS
TABLE - IBE.IBE_DSP_MSITE_SCT_SECTS
TABLE - IBE.IBE_DSP_OBJ_LGL_CTNT
TABLE - IBE.IBE_DSP_SECTIONS_B
TABLE - IBE.IBE_DSP_SECTIONS_TL
TABLE - IBE.IBE_DSP_SECTION_ITEMS
TABLE - IBE.IBE_DSP_TPL_CTG
TABLE - IBE.IBE_ECR_MVLOG
TABLE - IBE.IBE_ECR_ORDERS_FACT
TABLE - IBE.IBE_ECR_ORDER_HEADERS_FACT
TABLE - IBE.IBE_ECR_QUOTES_FACT
TABLE - IBE.IBE_LEAD_IMPORT_DETAILS
TABLE - IBE.IBE_LEAD_IMPORT_LOG
TABLE - IBE.IBE_MIGRATION_HISTORY
TABLE - IBE.IBE_MIGRATION_LOG
TABLE - IBE.IBE_MSITES_B
TABLE - IBE.IBE_MSITES_TL
TABLE - IBE.IBE_MSITE_CURRENCIES
TABLE - IBE.IBE_MSITE_INFORMATION
TABLE - IBE.IBE_MSITE_LANGUAGES
TABLE - IBE.IBE_MSITE_ORGS
TABLE - IBE.IBE_MSITE_PRTY_ACCSS
TABLE - IBE.IBE_MSITE_RESPS_B
TABLE - IBE.IBE_MSITE_RESPS_TL
TABLE - IBE.IBE_ORD_ONECLICK_ALL
TABLE - IBE.IBE_SECTION_SEARCH
TABLE - IBE.IBE_SECTION_SEARCH_PART
TABLE - IBE.IBE_SHP_LIST_ITEMS_ALL
TABLE - IBE.IBE_SH_QUOTE_ACCESS
TABLE - IBE.IBE_SH_SHLITEM_RELS
TABLE - IBE.IBE_SH_SHP_LISTS_ALL
TABLE - IBE.IBE_WF_NOTIF_MSG_MAPS
TABLE - IBE.IBE_WF_NOTIF_SETUP
VIEW - APPS.IBE_BIS_LIST_MSITES_V
VIEW - APPS.IBE_BI_CURRENCY_V
VIEW - APPS.IBE_BI_MSITES_V
VIEW - APPS.IBE_BI_MSITE_DIMN_V
VIEW - APPS.IBE_CT_RELATED_ITEMS_V
VIEW - APPS.IBE_DSP_AMV_ITEMS_V
VIEW - APPS.IBE_DSP_ATTACHMENTS_V
VIEW - APPS.IBE_DSP_CONTEXT_V
VIEW - APPS.IBE_DSP_CONTEXT_VL
VIEW - APPS.IBE_DSP_FEATURED_MEDIA_V
VIEW - APPS.IBE_DSP_LGL_CTNT_V
VIEW - APPS.IBE_DSP_LGL_PHYS_MAP_V
VIEW - APPS.IBE_DSP_LGL_TEMPLATES_V
VIEW - APPS.IBE_DSP_OBJ_LGL_CTNT_V
VIEW - APPS.IBE_DSP_SECTIONS_VL
VIEW - APPS.IBE_DSP_TPL_CONTEXT_V
VIEW - APPS.IBE_DSP_TPL_CTG_V
VIEW - APPS.IBE_DSP_TPL_ITEM_CTG_V
VIEW - APPS.IBE_INVOICE_DETAIL_V
VIEW - APPS.IBE_INVOICE_HEADER_V
VIEW - APPS.IBE_MSITES_VL
VIEW - APPS.IBE_MSITE_RESPS_VL
VIEW - APPS.IBE_OE_CONTACTS_V
VIEW - APPS.IBE_ORDER_DETAIL_V
VIEW - APPS.IBE_ORDER_HEADER_ADV_V
VIEW - APPS.IBE_ORDER_HEADER_V
VIEW - APPS.IBE_ORDER_ITEMS_ADV_V
VIEW - APPS.IBE_ORDER_LINE_DTL_V
VIEW - APPS.IBE_ORDER_SUM_V
VIEW - APPS.IBE_PAYMENT_DETAIL_V
VIEW - APPS.IBE_PAYMENT_HEADER_V
VIEW - APPS.IBE_QUOTE_HEADERS_V
VIEW - APPS.IBE_RETURNABLE_LINES_V
VIEW - APPS.IBE_RETURNABLE_SERIAL_V
VIEW - APPS.IBE_RETURN_DETAIL_V
VIEW - APPS.IBE_RETURN_SUM_V
VIEW - APPS.IBE_SHIP_DETAIL_V
VIEW - APPS.IBE_SHIP_DLVY_DTL_V
VIEW - APPS.IBE_SHIP_DLVY_V

Table: IBE_ACTIVE_QUOTES_ALL

Description: Table to track the active carts for a given party and cust account.
Primary Key: IBE_ACTIVE_QUOTES_ALL_PK
  1. ACTIVE_QUOTE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_ACTIVE_QUOTES_ALL.PARTY_ID HZ_PARTIES
IBE_ACTIVE_QUOTES_ALL.CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
IBE_ACTIVE_QUOTES_ALL.QUOTE_HEADER_ID ASO_QUOTE_HEADERS_ALL

[top of page]

IBE.IBE_ACTIVE_QUOTES_ALL does not reference any database object

IBE.IBE_ACTIVE_QUOTES_ALL is referenced by following:

IBE
VIEW - IBE_ACTIVE_QUOTES_ALL#

[top of page]

Table: IBE_CT_IMEDIA_SEARCH

Description: This table is used by iStore for searching products
Primary Key: IBE_CT_IMEDIA_SEARCH_PK
  1. IBE_CT_IMEDIA_SEARCH_ID
Primary Key: IBE_CT_IMEDIA_SEARCH_UK
  1. ORGANIZATION_ID
  2. INVENTORY_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_CT_IMEDIA_SEARCH.INVENTORY_ITEM_ID
IBE_CT_IMEDIA_SEARCH.ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B
IBE_CT_IMEDIA_SEARCH.CATEGORY_ID MTL_CATEGORIES_B
IBE_CT_IMEDIA_SEARCH.CATEGORY_SET_ID MTL_CATEGORY_SETS_B

[top of page]

IBE.IBE_CT_IMEDIA_SEARCH does not reference any database object

IBE.IBE_CT_IMEDIA_SEARCH is referenced by following:

IBE
VIEW - IBE_CT_IMEDIA_SEARCH#

[top of page]

Table: IBE_CT_RELATED_ITEMS

Description: Precomputed product relationships derived from mapping relationship rules
Primary Key: IBE_CT_RELATED_ITEMS_PK
  1. INVENTORY_ITEM_ID
  2. RELATED_ITEM_ID
  3. RELATION_TYPE_CODE
  4. ORGANIZATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_CT_RELATED_ITEMS.INVENTORY_ITEM_ID
IBE_CT_RELATED_ITEMS.ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B
IBE_CT_RELATED_ITEMS.RELATED_ITEM_ID
IBE_CT_RELATED_ITEMS.ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B
IBE_CT_RELATED_ITEMS.RELATION_RULE_ID IBE_CT_RELATION_RULES

[top of page]

IBE.IBE_CT_RELATED_ITEMS does not reference any database object

IBE.IBE_CT_RELATED_ITEMS is referenced by following:

IBE
VIEW - IBE_CT_RELATED_ITEMS#

[top of page]

Table: IBE_CT_RELATION_RULES

Description: Mapping or SQL rules that define product relationships
Primary Key: IBE_CT_RELATION_RULES_PK
  1. RELATION_RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_CT_RELATION_RULES.ORIGIN_OBJECT_ID IBE_DSP_SECTIONS_B
IBE_CT_RELATION_RULES.DEST_OBJECT_ID IBE_DSP_SECTIONS_B
IBE_CT_RELATION_RULES.ORIGIN_OBJECT_ID MTL_CATEGORIES_B
IBE_CT_RELATION_RULES.DEST_OBJECT_ID MTL_CATEGORIES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
IBE_CT_RELATED_ITEMS.RELATION_RULE_ID IBE_CT_RELATION_RULES

[top of page]

IBE.IBE_CT_RELATION_RULES does not reference any database object

IBE.IBE_CT_RELATION_RULES is referenced by following:

IBE
VIEW - IBE_CT_RELATION_RULES#

[top of page]

Table: IBE_CT_REL_EXCLUSIONS

Description: Exclusion of precomputed product relationships generated from mapping relationship rules
Primary Key: IBE_CT_REL_EXCLUSIONS_PK
  1. ORGANIZATION_ID
  2. RELATION_TYPE_CODE
  3. INVENTORY_ITEM_ID
  4. RELATED_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_CT_REL_EXCLUSIONS.INVENTORY_ITEM_ID
IBE_CT_REL_EXCLUSIONS.ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B
IBE_CT_REL_EXCLUSIONS.RELATED_ITEM_ID
IBE_CT_REL_EXCLUSIONS.ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B

[top of page]

IBE.IBE_CT_REL_EXCLUSIONS does not reference any database object

IBE.IBE_CT_REL_EXCLUSIONS is referenced by following:

IBE
VIEW - IBE_CT_REL_EXCLUSIONS#

[top of page]

Table: IBE_DSP_CONTEXT_B

Description: Stores the display contexts associated with templates and media attributes for media.
Primary Key: IBE_DSP_CONTEXT_B_PK
  1. CONTEXT_ID
Primary Key: IBE_DSP_CONTEXT_B_UK1
  1. ACCESS_NAME
  2. CONTEXT_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_DSP_CONTEXT_B.ITEM_ID JTF_AMV_ITEMS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
IBE_DSP_CONTEXT_TL.CONTEXT_ID IBE_DSP_CONTEXT_B
IBE_DSP_OBJ_LGL_CTNT.CONTEXT_ID IBE_DSP_CONTEXT_B
IBE_DSP_SECTIONS_B.DISPLAY_CONTEXT_ID IBE_DSP_CONTEXT_B

[top of page]

IBE.IBE_DSP_CONTEXT_B does not reference any database object

IBE.IBE_DSP_CONTEXT_B is referenced by following:

IBE
VIEW - IBE_DSP_CONTEXT_B#

[top of page]

Table: IBE_DSP_CONTEXT_TL

Description: Translations for IBE_DSP_CONTEXT_B.
Primary Key: IBE_DSP_CONTEXT_TL_PK
  1. CONTEXT_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_DSP_CONTEXT_TL.CONTEXT_ID IBE_DSP_CONTEXT_B

[top of page]

IBE.IBE_DSP_CONTEXT_TL does not reference any database object

IBE.IBE_DSP_CONTEXT_TL is referenced by following:

IBE
VIEW - IBE_DSP_CONTEXT_TL#

[top of page]

Table: IBE_DSP_LGL_PHYS_MAP

Description: Stores the logical to physical media mapping based on site and language
Primary Key: OCO_38364745
  1. LGL_PHYS_MAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_DSP_LGL_PHYS_MAP.MSITE_ID IBE_MSITES_B
IBE_DSP_LGL_PHYS_MAP.ATTACHMENT_ID JTF_AMV_ATTACHMENTS
IBE_DSP_LGL_PHYS_MAP.ITEM_ID JTF_AMV_ITEMS_B

[top of page]

IBE.IBE_DSP_LGL_PHYS_MAP does not reference any database object

IBE.IBE_DSP_LGL_PHYS_MAP is referenced by following:

IBE
VIEW - IBE_DSP_LGL_PHYS_MAP#

[top of page]

Table: IBE_DSP_MSITE_SCT_ITEMS

Description: This table stores the assocation between mini-site and items.
Primary Key: IBE_DSP_MSITE_SCT_ITEMS_PK
  1. MINI_SITE_SECTION_ITEM_ID
Primary Key: IBE_DSP_MSITE_SCT_ITEMS_UK1
  1. MINI_SITE_ID
  2. SECTION_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_DSP_MSITE_SCT_ITEMS.SECTION_ITEM_ID IBE_DSP_SECTION_ITEMS
IBE_DSP_MSITE_SCT_ITEMS.MINI_SITE_ID IBE_MSITES_B

[top of page]

IBE.IBE_DSP_MSITE_SCT_ITEMS does not reference any database object

IBE.IBE_DSP_MSITE_SCT_ITEMS is referenced by following:

IBE
VIEW - IBE_DSP_MSITE_SCT_ITEMS#

[top of page]

Table: IBE_DSP_MSITE_SCT_SECTS

Description: This table stores the association between mini-site and sections.
Primary Key: IBE_DSP_MSITE_SCT_SECTS_PK
  1. MINI_SITE_SECTION_SECTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_DSP_MSITE_SCT_SECTS.MINI_SITE_ID IBE_MSITES_B
IBE_DSP_MSITE_SCT_SECTS.PARENT_SECTION_ID IBE_DSP_SECTIONS_B
IBE_DSP_MSITE_SCT_SECTS.CHILD_SECTION_ID IBE_DSP_SECTIONS_B

[top of page]

IBE.IBE_DSP_MSITE_SCT_SECTS does not reference any database object

IBE.IBE_DSP_MSITE_SCT_SECTS is referenced by following:

IBE
VIEW - IBE_DSP_MSITE_SCT_SECTS#

[top of page]

Table: IBE_DSP_OBJ_LGL_CTNT

Description: This table Contains the default logical items for selected display context labels and objects
Primary Key: IBE_DSP_OBJ_LGL_CTNT_PK
  1. OBJ_LGL_CTNT_ID
Primary Key: IBE_DSP_OBJ_LGL_CTNT_UK1
  1. ITEM_ID
  2. CONTEXT_ID
  3. OBJECT_ID
  4. OBJECT_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_DSP_OBJ_LGL_CTNT.CONTEXT_ID IBE_DSP_CONTEXT_B
IBE_DSP_OBJ_LGL_CTNT.OBJECT_ID MTL_CATEGORIES_B
IBE_DSP_OBJ_LGL_CTNT.OBJECT_ID IBE_DSP_SECTIONS_B
IBE_DSP_OBJ_LGL_CTNT.ITEM_ID JTF_AMV_ITEMS_B

[top of page]

IBE.IBE_DSP_OBJ_LGL_CTNT does not reference any database object

IBE.IBE_DSP_OBJ_LGL_CTNT is referenced by following:

IBE
VIEW - IBE_DSP_OBJ_LGL_CTNT#

[top of page]

Table: IBE_DSP_SECTIONS_B

Description: This table stores information about the sections.
Primary Key: IBE_DSP_SECTIONS_B_PK
  1. SECTION_ID
Primary Key: IBE_DSP_SECTIONS_B_UK1
  1. ACCESS_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_DSP_SECTIONS_B.DISPLAY_CONTEXT_ID IBE_DSP_CONTEXT_B
IBE_DSP_SECTIONS_B.DELIVERABLE_ID JTF_AMV_ITEMS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
IBE_CT_RELATION_RULES.ORIGIN_OBJECT_ID IBE_DSP_SECTIONS_B
IBE_CT_RELATION_RULES.DEST_OBJECT_ID IBE_DSP_SECTIONS_B
IBE_DSP_MSITE_SCT_SECTS.PARENT_SECTION_ID IBE_DSP_SECTIONS_B
IBE_DSP_MSITE_SCT_SECTS.CHILD_SECTION_ID IBE_DSP_SECTIONS_B
IBE_DSP_OBJ_LGL_CTNT.OBJECT_ID IBE_DSP_SECTIONS_B
IBE_DSP_SECTIONS_TL.SECTION_ID IBE_DSP_SECTIONS_B
IBE_DSP_SECTION_ITEMS.SECTION_ID IBE_DSP_SECTIONS_B
IBE_ECR_ORDERS_FACT.SECTION_ID IBE_DSP_SECTIONS_B
IBE_ECR_QUOTES_FACT.SECTION_ID IBE_DSP_SECTIONS_B
IBE_MSITES_B.MSITE_ROOT_SECTION_ID IBE_DSP_SECTIONS_B
IBE_SECTION_SEARCH.SECTION_ID IBE_DSP_SECTIONS_B

[top of page]

IBE.IBE_DSP_SECTIONS_B does not reference any database object

IBE.IBE_DSP_SECTIONS_B is referenced by following:

IBE
VIEW - IBE_DSP_SECTIONS_B#

[top of page]

Table: IBE_DSP_SECTIONS_TL

Description: This table stores the translatable information about the sections.
Primary Key: IBE_DSP_SECTIONS_TL_PK
  1. SECTION_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_DSP_SECTIONS_TL.SECTION_ID IBE_DSP_SECTIONS_B

[top of page]

IBE.IBE_DSP_SECTIONS_TL does not reference any database object

IBE.IBE_DSP_SECTIONS_TL is referenced by following:

IBE
VIEW - IBE_DSP_SECTIONS_TL#

[top of page]

Table: IBE_DSP_SECTION_ITEMS

Description: This table stores the association between sections and items.
Primary Key: IBE_DSP_SECTION_ITEMS_PK
  1. SECTION_ITEM_ID
Primary Key: IBE_DSP_SECTION_ITEMS_UK1
  1. SECTION_ID
  2. INVENTORY_ITEM_ID
  3. ORGANIZATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_DSP_SECTION_ITEMS.INVENTORY_ITEM_ID
IBE_DSP_SECTION_ITEMS.ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B
IBE_DSP_SECTION_ITEMS.SECTION_ID IBE_DSP_SECTIONS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
IBE_DSP_MSITE_SCT_ITEMS.SECTION_ITEM_ID IBE_DSP_SECTION_ITEMS

[top of page]

IBE.IBE_DSP_SECTION_ITEMS does not reference any database object

IBE.IBE_DSP_SECTION_ITEMS is referenced by following:

IBE
VIEW - IBE_DSP_SECTION_ITEMS#

[top of page]

Table: IBE_DSP_TPL_CTG

Description: This table stores the category to logical template mappings
Primary Key: IBE_DSP_TPL_CTG_PK
  1. TPL_CTG_ID
Primary Key: IBE_DSP_TPL_CTG_UK1
  1. ITEM_ID
  2. CATEGORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_DSP_TPL_CTG.CATEGORY_ID MTL_CATEGORIES_B
IBE_DSP_TPL_CTG.ITEM_ID JTF_AMV_ITEMS_B

[top of page]

IBE.IBE_DSP_TPL_CTG does not reference any database object

IBE.IBE_DSP_TPL_CTG is referenced by following:

IBE
VIEW - IBE_DSP_TPL_CTG#

[top of page]

Table: IBE_ECR_MVLOG

Description: Materialized view refresh history log table.
Primary Key: IBE_ECR_MVLOG_PK
  1. MVLOG_ID

[top of page]

IBE.IBE_ECR_MVLOG does not reference any database object

IBE.IBE_ECR_MVLOG is referenced by following:

IBE
VIEW - IBE_ECR_MVLOG#

[top of page]

Table: IBE_ECR_ORDERS_FACT

Description: Granular aggregate information of Orders for a given period.
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_ECR_ORDERS_FACT.MSITE_ID IBE_MSITES_B
IBE_ECR_ORDERS_FACT.SECTION_ID IBE_DSP_SECTIONS_B
IBE_ECR_ORDERS_FACT.INVENTORY_ITEM_ID
IBE_ECR_ORDERS_FACT.ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B

[top of page]

IBE.IBE_ECR_ORDERS_FACT does not reference any database object

IBE.IBE_ECR_ORDERS_FACT is referenced by following:

IBE
VIEW - IBE_ECR_ORDERS_FACT#

[top of page]

Table: IBE_ECR_ORDER_HEADERS_FACT

Description: Fact table to collect data for Booked Orders.
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_ECR_ORDER_HEADERS_FACT.PARTY_ID HZ_PARTIES

[top of page]

IBE.IBE_ECR_ORDER_HEADERS_FACT does not reference any database object

IBE.IBE_ECR_ORDER_HEADERS_FACT is referenced by following:

IBE
VIEW - IBE_ECR_ORDER_HEADERS_FACT#

[top of page]

Table: IBE_ECR_QUOTES_FACT

Description: Granular aggregate information about quotes for a given period.
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_ECR_QUOTES_FACT.MSITE_ID IBE_MSITES_B
IBE_ECR_QUOTES_FACT.SECTION_ID IBE_DSP_SECTIONS_B
IBE_ECR_QUOTES_FACT.INVENTORY_ITEM_ID
IBE_ECR_QUOTES_FACT.ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B
IBE_ECR_QUOTES_FACT.CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS

[top of page]

IBE.IBE_ECR_QUOTES_FACT does not reference any database object

IBE.IBE_ECR_QUOTES_FACT is referenced by following:

IBE
VIEW - IBE_ECR_QUOTES_FACT#

[top of page]

Table: IBE_LEAD_IMPORT_DETAILS

Description: This table contains the details of the Leads Imported.
Primary Key: IBE_LEAD_IMPORT_DETAILS_PK
  1. DETAIL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_LEAD_IMPORT_DETAILS.QUOTE_HEADER_ID ASO_QUOTE_HEADERS_ALL
IBE_LEAD_IMPORT_DETAILS.LOG_ID %

[top of page]

IBE.IBE_LEAD_IMPORT_DETAILS does not reference any database object

IBE.IBE_LEAD_IMPORT_DETAILS is referenced by following:

IBE
VIEW - IBE_LEAD_IMPORT_DETAILS#

[top of page]

Table: IBE_LEAD_IMPORT_LOG

Description: This table contains the log information for Leads that are imported.
Primary Key: IBE_LEAD_IMPORT_LOG_PK
  1. LOG_ID

[top of page]

IBE.IBE_LEAD_IMPORT_LOG does not reference any database object

IBE.IBE_LEAD_IMPORT_LOG is referenced by following:

IBE
VIEW - IBE_LEAD_IMPORT_LOG#

[top of page]

Table: IBE_MIGRATION_HISTORY

Description: Table to Keep track of migration History.

[top of page]

IBE.IBE_MIGRATION_HISTORY does not reference any database object

IBE.IBE_MIGRATION_HISTORY is referenced by following:

IBE
VIEW - IBE_MIGRATION_HISTORY#

[top of page]

Table: IBE_MIGRATION_LOG

Description: Table to Keep track of migration data for Recovery Purposes
Primary Key: IBE_MIGRATION_LOG_PK
  1. MGLOG_ID

[top of page]

IBE.IBE_MIGRATION_LOG does not reference any database object

IBE.IBE_MIGRATION_LOG is referenced by following:

IBE
VIEW - IBE_MIGRATION_LOG#

[top of page]

Table: IBE_MSITES_B

Description: Stores Mini Site (Specialty Stores) Information.
Primary Key: IBE_MSITES_B_PK
  1. MSITE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_MSITES_B.DEFAULT_LANGUAGE_CODE FND_LANGUAGES
IBE_MSITES_B.DEFAULT_CURRENCY_CODE FND_CURRENCIES
IBE_MSITES_B.MSITE_ROOT_SECTION_ID IBE_DSP_SECTIONS_B
IBE_MSITES_B.STORE_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
IBE_DSP_LGL_PHYS_MAP.MSITE_ID IBE_MSITES_B
IBE_DSP_MSITE_SCT_ITEMS.MINI_SITE_ID IBE_MSITES_B
IBE_DSP_MSITE_SCT_SECTS.MINI_SITE_ID IBE_MSITES_B
IBE_ECR_ORDERS_FACT.MSITE_ID IBE_MSITES_B
IBE_ECR_QUOTES_FACT.MSITE_ID IBE_MSITES_B
IBE_MSITES_TL.MSITE_ID IBE_MSITES_B
IBE_MSITE_CURRENCIES.MSITE_ID IBE_MSITES_B
IBE_MSITE_INFORMATION.MSITE_ID IBE_MSITES_B
IBE_MSITE_LANGUAGES.MSITE_ID IBE_MSITES_B
IBE_MSITE_ORGS.MSITE_ID IBE_MSITES_B
IBE_MSITE_PRTY_ACCSS.MSITE_ID IBE_MSITES_B
IBE_MSITE_RESPS_B.MSITE_ID IBE_MSITES_B
IBE_SECTION_SEARCH.MINISITE_ID IBE_MSITES_B
IBE_WF_NOTIF_MSG_MAPS.MSITE_ID IBE_MSITES_B
OE_ORDER_HEADER_HISTORY.MINISITE_ID IBE_MSITES_B
OE_ORDER_LINES_ALL.MINISITE_ID IBE_MSITES_B
OE_ORDER_LINES_HISTORY.MINISITE_ID IBE_MSITES_B

[top of page]

IBE.IBE_MSITES_B does not reference any database object

IBE.IBE_MSITES_B is referenced by following:

IBE
VIEW - IBE_MSITES_B#

[top of page]

Table: IBE_MSITES_TL

Description: Translations for IBE_MSITES_B
Primary Key: OCO_38364962
  1. MSITE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_MSITES_TL.MSITE_ID IBE_MSITES_B

[top of page]

IBE.IBE_MSITES_TL does not reference any database object

IBE.IBE_MSITES_TL is referenced by following:

IBE
VIEW - IBE_MSITES_TL#

[top of page]

Table: IBE_MSITE_CURRENCIES

Description: Stores the currencies supported by the mini-sites
Primary Key: IBE_MSITE_CURRENCIES_PK
  1. MSITE_CURRENCY_ID
Primary Key: IBE_MSITE_CURRENCIES_UK1
  1. CURRENCY_CODE
  2. MSITE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_MSITE_CURRENCIES.MSITE_ID IBE_MSITES_B
IBE_MSITE_CURRENCIES.CURRENCY_CODE FND_CURRENCIES

[top of page]

IBE.IBE_MSITE_CURRENCIES does not reference any database object

IBE.IBE_MSITE_CURRENCIES is referenced by following:

IBE
VIEW - IBE_MSITE_CURRENCIES#

[top of page]

Table: IBE_MSITE_INFORMATION

Description: This Table Stores Additional Information about Specialty Stores
Primary Key: IBE_MSITE_INFORMATION_PK
  1. MSITE_INFORMATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_MSITE_INFORMATION.MSITE_ID IBE_MSITES_B

[top of page]

IBE.IBE_MSITE_INFORMATION does not reference any database object

IBE.IBE_MSITE_INFORMATION is referenced by following:

IBE
VIEW - IBE_MSITE_INFORMATION#

[top of page]

Table: IBE_MSITE_LANGUAGES

Description: Stores the languages supported by the mini-sites
Primary Key: IBE_MSITE_LANGUAGES_PK
  1. MSITE_LANGUAGE_ID
Primary Key: IBE_MSITE_LANGUAGES_UK1
  1. MSITE_ID
  2. LANGUAGE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_MSITE_LANGUAGES.MSITE_ID IBE_MSITES_B
IBE_MSITE_LANGUAGES.LANGUAGE_CODE FND_LANGUAGES

[top of page]

IBE.IBE_MSITE_LANGUAGES does not reference any database object

IBE.IBE_MSITE_LANGUAGES is referenced by following:

IBE
VIEW - IBE_MSITE_LANGUAGES#

[top of page]

Table: IBE_MSITE_ORGS

Description: Define the organizations supported by the mini-sites
Primary Key: OCO_38365034
  1. MSITE_ORG_ID
Primary Key: OCO_38365036
  1. MSITE_ID
  2. ORG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_MSITE_ORGS.MSITE_ID IBE_MSITES_B

[top of page]

IBE.IBE_MSITE_ORGS does not reference any database object

IBE.IBE_MSITE_ORGS is referenced by following:

IBE
VIEW - IBE_MSITE_ORGS#

[top of page]

Table: IBE_MSITE_PRTY_ACCSS

Description: Defines the parties supported by the Specialty Stores
Primary Key: IBE_MSITE_PRTY_ACCSS_PK
  1. MSITE_PRTY_ACCSS_ID
Primary Key: IBE_MSITE_PRTY_ACCSS_UK1
  1. PARTY_ID
  2. MSITE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_MSITE_PRTY_ACCSS.MSITE_ID IBE_MSITES_B
IBE_MSITE_PRTY_ACCSS.PARTY_ID HZ_PARTIES

[top of page]

IBE.IBE_MSITE_PRTY_ACCSS does not reference any database object

IBE.IBE_MSITE_PRTY_ACCSS is referenced by following:

IBE
VIEW - IBE_MSITE_PRTY_ACCSS#

[top of page]

Table: IBE_MSITE_RESPS_B

Description: Defines the responsibilities supported by the Specialty Store.
Primary Key: IBE_MSITE_RESPS_B_PK
  1. MSITE_RESP_ID
Primary Key: IBE_MSITE_RESPS_B_UK1
  1. MSITE_ID
  2. RESPONSIBILITY_ID
  3. APPLICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_MSITE_RESPS_B.MSITE_ID IBE_MSITES_B
IBE_MSITE_RESPS_B.APPLICATION_ID
IBE_MSITE_RESPS_B.RESPONSIBILITY_ID 		FND_RESPONSIBILITY
Foreign Keys to this table:
Foreign Key Column Foreign Table
IBE_MSITE_RESPS_TL.MSITE_RESP_ID IBE_MSITE_RESPS_B

[top of page]

IBE.IBE_MSITE_RESPS_B does not reference any database object

IBE.IBE_MSITE_RESPS_B is referenced by following:

IBE
VIEW - IBE_MSITE_RESPS_B#

[top of page]

Table: IBE_MSITE_RESPS_TL

Description: Translations for JTF_MSITE_RESPS_B
Primary Key: IBE_MSITE_RESPS_TL_PK
  1. MSITE_RESP_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_MSITE_RESPS_TL.MSITE_RESP_ID IBE_MSITE_RESPS_B

[top of page]

IBE.IBE_MSITE_RESPS_TL does not reference any database object

IBE.IBE_MSITE_RESPS_TL is referenced by following:

IBE
VIEW - IBE_MSITE_RESPS_TL#

[top of page]

Table: IBE_ORD_ONECLICK_ALL

Description: Express checkout settings for registered customers
Primary Key: IBE_ORD_ONECLICK_PK
  1. ORD_ONECLICK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_ORD_ONECLICK_ALL.BILL_TO_PTY_SITE_ID HZ_PARTY_SITES
IBE_ORD_ONECLICK_ALL.SHIP_TO_PTY_SITE_ID HZ_PARTY_SITES
IBE_ORD_ONECLICK_ALL.CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
IBE_ORD_ONECLICK_ALL.PARTY_ID HZ_PARTIES

[top of page]

IBE.IBE_ORD_ONECLICK_ALL does not reference any database object

IBE.IBE_ORD_ONECLICK_ALL is referenced by following:

IBE
VIEW - IBE_ORD_ONECLICK_ALL#

[top of page]

Table: IBE_SECTION_SEARCH

Description: The search table for restricting search to section(s).
Primary Key: IBE_SECTION_SEARCH_UK1
  1. INVENTORY_ITEM_ID
  2. MINISITE_ID
  3. ORGANIZATION_ID
  4. SECTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_SECTION_SEARCH.MINISITE_ID IBE_MSITES_B
IBE_SECTION_SEARCH.SECTION_ID IBE_DSP_SECTIONS_B
IBE_SECTION_SEARCH.INVENTORY_ITEM_ID
IBE_SECTION_SEARCH.ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B

[top of page]

IBE.IBE_SECTION_SEARCH does not reference any database object

IBE.IBE_SECTION_SEARCH is referenced by following:

IBE
VIEW - IBE_SECTION_SEARCH#

[top of page]

Table: IBE_SECTION_SEARCH_PART

Description:

[top of page]

IBE.IBE_SECTION_SEARCH_PART does not reference any database object

IBE.IBE_SECTION_SEARCH_PART is referenced by following:

IBE
VIEW - IBE_SECTION_SEARCH_PART#

[top of page]

Table: IBE_SHP_LIST_ITEMS_ALL

Description: Stores Shopping List Items details.
Primary Key: IBE_SHP_LIST_ITEMS_ALL_PK
  1. SHP_LIST_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_SHP_LIST_ITEMS_ALL.SHP_LIST_ID IBE_SH_SHP_LISTS_ALL
IBE_SHP_LIST_ITEMS_ALL.INVENTORY_ITEM_ID
IBE_SHP_LIST_ITEMS_ALL.ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
IBE_SH_SHLITEM_RELS.SHP_LIST_ITEM_ID IBE_SHP_LIST_ITEMS_ALL
IBE_SH_SHLITEM_RELS.RELATED_SHP_LIST_ITEM_ID IBE_SHP_LIST_ITEMS_ALL

[top of page]

IBE.IBE_SHP_LIST_ITEMS_ALL does not reference any database object

IBE.IBE_SHP_LIST_ITEMS_ALL is referenced by following:

IBE
VIEW - IBE_SHP_LIST_ITEMS_ALL#

[top of page]

Table: IBE_SH_QUOTE_ACCESS

Description: Stores shopping cart (quote) access details
Primary Key: IBE_SH_QUOTE_ACCESS_PK
  1. QUOTE_SHAREE_ID
Primary Key: IBE_SH_QUOTE_ACCESS_UK1
  1. QUOTE_HEADER_ID
  2. QUOTE_SHAREE_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_SH_QUOTE_ACCESS.QUOTE_HEADER_ID ASO_QUOTE_HEADERS_ALL
IBE_SH_QUOTE_ACCESS.PARTY_ID HZ_PARTIES
IBE_SH_QUOTE_ACCESS.CONTACT_POINT_ID HZ_CONTACT_POINTS

[top of page]

IBE.IBE_SH_QUOTE_ACCESS does not reference any database object

IBE.IBE_SH_QUOTE_ACCESS is referenced by following:

IBE
VIEW - IBE_SH_QUOTE_ACCESS#

[top of page]

Table: IBE_SH_SHLITEM_RELS

Description: Stores relationships between different Shopping List Items.
Primary Key: IBE_SH_SHLITEM_RELS_PK
  1. SHLITEM_REL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_SH_SHLITEM_RELS.SHP_LIST_ITEM_ID IBE_SHP_LIST_ITEMS_ALL
IBE_SH_SHLITEM_RELS.RELATED_SHP_LIST_ITEM_ID IBE_SHP_LIST_ITEMS_ALL

[top of page]

IBE.IBE_SH_SHLITEM_RELS does not reference any database object

IBE.IBE_SH_SHLITEM_RELS is referenced by following:

IBE
VIEW - IBE_SH_SHLITEM_RELS#

[top of page]

Table: IBE_SH_SHP_LISTS_ALL

Description: Stores Shopping Lists details.
Primary Key: IBE_SH_SHP_LISTS_ALL_PK
  1. SHP_LIST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_SH_SHP_LISTS_ALL.PARTY_ID HZ_PARTIES
IBE_SH_SHP_LISTS_ALL.CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IBE_SHP_LIST_ITEMS_ALL.SHP_LIST_ID IBE_SH_SHP_LISTS_ALL

[top of page]

IBE.IBE_SH_SHP_LISTS_ALL does not reference any database object

IBE.IBE_SH_SHP_LISTS_ALL is referenced by following:

IBE
VIEW - IBE_SH_SHP_LISTS_ALL#

[top of page]

Table: IBE_WF_NOTIF_MSG_MAPS

Description: This table contains information about message mappings for each notification.
Primary Key: IBE_WF_NOTIF_MSG_MAPS_PK
  1. NOTIF_MSG_MAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBE_WF_NOTIF_MSG_MAPS.MSITE_ID IBE_MSITES_B
IBE_WF_NOTIF_MSG_MAPS.ORG_ID HR_ALL_ORGANIZATION_UNITS
IBE_WF_NOTIF_MSG_MAPS.NOTIF_SETUP_ID IBE_WF_NOTIF_SETUP

[top of page]

IBE.IBE_WF_NOTIF_MSG_MAPS does not reference any database object

IBE.IBE_WF_NOTIF_MSG_MAPS is referenced by following:

IBE
VIEW - IBE_WF_NOTIF_MSG_MAPS#

[top of page]

Table: IBE_WF_NOTIF_SETUP

Description: This table stores information about supported Work Flow notifications in iStore.
Primary Key: IBE_WF_NOTIF_SETUP_PK
  1. NOTIF_SETUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IBE_WF_NOTIF_MSG_MAPS.NOTIF_SETUP_ID IBE_WF_NOTIF_SETUP

[top of page]

IBE.IBE_WF_NOTIF_SETUP does not reference any database object

IBE.IBE_WF_NOTIF_SETUP is referenced by following:

IBE
VIEW - IBE_WF_NOTIF_SETUP#

[top of page]

View: IBE_BIS_LIST_MSITES_V

[top of page]

APPS.IBE_BIS_LIST_MSITES_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.IBE_BIS_LIST_MSITES_V is not referenced by any database object

[top of page]

View: IBE_BI_CURRENCY_V

[top of page]

APPS.IBE_BI_CURRENCY_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.IBE_BI_CURRENCY_V is not referenced by any database object

[top of page]

View: IBE_BI_MSITES_V

[top of page]

APPS.IBE_BI_MSITES_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.IBE_BI_MSITES_V is not referenced by any database object

[top of page]

View: IBE_BI_MSITE_DIMN_V

[top of page]

APPS.IBE_BI_MSITE_DIMN_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.IBE_BI_MSITE_DIMN_V is not referenced by any database object

[top of page]

View: IBE_CT_RELATED_ITEMS_V

[top of page]

APPS.IBE_CT_RELATED_ITEMS_V references the following:

APPS
SYNONYM - IBE_CT_RELATED_ITEMS

APPS.IBE_CT_RELATED_ITEMS_V is not referenced by any database object

[top of page]

View: IBE_DSP_AMV_ITEMS_V

[top of page]

APPS.IBE_DSP_AMV_ITEMS_V references the following:

APPS
SYNONYM - IBE_DSP_LGL_PHYS_MAP
SYNONYM - JTF_AMV_ATTACHMENTS
- JTF_AMV_ITEM_KEYWORDS_V
- JTF_AMV_ITEMS_VL
APPS.IBE_DSP_AMV_ITEMS_V is referenced by following:

APPS
VIEW - IBE_DSP_CONTEXT_V
VIEW - IBE_DSP_TPL_CTG_V
VIEW - IBE_DSP_TPL_ITEM_CTG_V

[top of page]

View: IBE_DSP_ATTACHMENTS_V

[top of page]

APPS.IBE_DSP_ATTACHMENTS_V references the following:

APPS
SYNONYM - IBE_DSP_LGL_PHYS_MAP
SYNONYM - JTF_AMV_ATTACHMENTS
- JTF_AMV_ITEMS_VL

APPS.IBE_DSP_ATTACHMENTS_V is not referenced by any database object

[top of page]

View: IBE_DSP_CONTEXT_V

[top of page]

APPS.IBE_DSP_CONTEXT_V references the following:

APPS
VIEW - IBE_DSP_AMV_ITEMS_V
VIEW - IBE_DSP_CONTEXT_VL

APPS.IBE_DSP_CONTEXT_V is not referenced by any database object

[top of page]

View: IBE_DSP_CONTEXT_VL

[top of page]

APPS.IBE_DSP_CONTEXT_VL references the following:

APPS
SYNONYM - IBE_DSP_CONTEXT_B
SYNONYM - IBE_DSP_CONTEXT_TL
APPS.IBE_DSP_CONTEXT_VL is referenced by following:

APPS
VIEW - IBE_DSP_CONTEXT_V
VIEW - IBE_DSP_LGL_CTNT_V

[top of page]

View: IBE_DSP_FEATURED_MEDIA_V

[top of page]

APPS.IBE_DSP_FEATURED_MEDIA_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - IBE_DSP_CONTEXT_B
SYNONYM - IBE_DSP_MSITE_SCT_ITEMS
SYNONYM - IBE_DSP_OBJ_LGL_CTNT
SYNONYM - IBE_DSP_SECTIONS_B
SYNONYM - IBE_DSP_SECTION_ITEMS
SYNONYM - MTL_ITEM_CATEGORIES
- JTF_AMV_ITEMS_VL

APPS.IBE_DSP_FEATURED_MEDIA_V is not referenced by any database object

[top of page]

View: IBE_DSP_LGL_CTNT_V

[top of page]

APPS.IBE_DSP_LGL_CTNT_V references the following:

APPS
VIEW - IBE_DSP_CONTEXT_VL
SYNONYM - IBE_DSP_OBJ_LGL_CTNT
- JTF_AMV_ITEMS_VL

APPS.IBE_DSP_LGL_CTNT_V is not referenced by any database object

[top of page]

View: IBE_DSP_LGL_PHYS_MAP_V

[top of page]

APPS.IBE_DSP_LGL_PHYS_MAP_V references the following:

APPS
VIEW - FND_LANGUAGES_VL
SYNONYM - IBE_DSP_LGL_PHYS_MAP
VIEW - IBE_MSITES_VL

APPS.IBE_DSP_LGL_PHYS_MAP_V is not referenced by any database object

[top of page]

View: IBE_DSP_LGL_TEMPLATES_V

[top of page]

APPS.IBE_DSP_LGL_TEMPLATES_V references the following:

APPS
SYNONYM - IBE_DSP_CONTEXT_B
SYNONYM - IBE_DSP_OBJ_LGL_CTNT
- JTF_AMV_ITEMS_VL

APPS.IBE_DSP_LGL_TEMPLATES_V is not referenced by any database object

[top of page]

View: IBE_DSP_OBJ_LGL_CTNT_V

[top of page]

APPS.IBE_DSP_OBJ_LGL_CTNT_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - IBE_DSP_CONTEXT_B
SYNONYM - IBE_DSP_OBJ_LGL_CTNT
SYNONYM - MTL_CATEGORY_SETS_B
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
- JTF_AMV_ITEMS_VL

APPS.IBE_DSP_OBJ_LGL_CTNT_V is not referenced by any database object

[top of page]

View: IBE_DSP_SECTIONS_VL

[top of page]

APPS.IBE_DSP_SECTIONS_VL references the following:

APPS
SYNONYM - IBE_DSP_SECTIONS_B
SYNONYM - IBE_DSP_SECTIONS_TL

APPS.IBE_DSP_SECTIONS_VL is not referenced by any database object

[top of page]

View: IBE_DSP_TPL_CONTEXT_V

[top of page]

APPS.IBE_DSP_TPL_CONTEXT_V references the following:

APPS
SYNONYM - IBE_DSP_CONTEXT_B

APPS.IBE_DSP_TPL_CONTEXT_V is not referenced by any database object

[top of page]

View: IBE_DSP_TPL_CTG_V

[top of page]

APPS.IBE_DSP_TPL_CTG_V references the following:

APPS
VIEW - IBE_DSP_AMV_ITEMS_V
SYNONYM - IBE_DSP_TPL_CTG
VIEW - MTL_CATEGORIES_V

APPS.IBE_DSP_TPL_CTG_V is not referenced by any database object

[top of page]

View: IBE_DSP_TPL_ITEM_CTG_V

[top of page]

APPS.IBE_DSP_TPL_ITEM_CTG_V references the following:

APPS
VIEW - IBE_DSP_AMV_ITEMS_V
SYNONYM - IBE_DSP_TPL_CTG
SYNONYM - MTL_ITEM_CATEGORIES
- MTL_SYSTEM_ITEMS_VL
- MTL_CATEGORIES_VL

APPS.IBE_DSP_TPL_ITEM_CTG_V is not referenced by any database object

[top of page]

View: IBE_INVOICE_DETAIL_V

[top of page]

APPS.IBE_INVOICE_DETAIL_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - RA_CUSTOMER_TRX_LINES_ALL

APPS.IBE_INVOICE_DETAIL_V is not referenced by any database object

[top of page]

View: IBE_INVOICE_HEADER_V

[top of page]

APPS.IBE_INVOICE_HEADER_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - RA_CUSTOMER_TRX_ALL

APPS.IBE_INVOICE_HEADER_V is not referenced by any database object

[top of page]

View: IBE_MSITES_VL

[top of page]

APPS.IBE_MSITES_VL references the following:

APPS
SYNONYM - IBE_MSITES_B
SYNONYM - IBE_MSITES_TL
APPS.IBE_MSITES_VL is referenced by following:

APPS
VIEW - IBE_DSP_LGL_PHYS_MAP_V

[top of page]

View: IBE_MSITE_RESPS_VL

[top of page]

APPS.IBE_MSITE_RESPS_VL references the following:

APPS
SYNONYM - IBE_MSITE_RESPS_B
SYNONYM - IBE_MSITE_RESPS_TL

APPS.IBE_MSITE_RESPS_VL is not referenced by any database object

[top of page]

View: IBE_OE_CONTACTS_V

[top of page]

APPS.IBE_OE_CONTACTS_V references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS

APPS.IBE_OE_CONTACTS_V is not referenced by any database object

[top of page]

View: IBE_ORDER_DETAIL_V

[top of page]

APPS.IBE_ORDER_DETAIL_V references the following:

APPS
VIEW - CZ_CONFIG_DETAILS_V
PACKAGE - CZ_UTILS
PACKAGE - FND_PROFILE
SYNONYM - MTL_UNITS_OF_MEASURE_TL
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
PACKAGE - OE_PROFILE
PACKAGE - OE_TOTALS_GRP
SYNONYM - OE_TRANSACTION_TYPES_TL
- OE_LOOKUPS
- MTL_SYSTEM_ITEMS_VL

APPS.IBE_ORDER_DETAIL_V is not referenced by any database object

[top of page]

View: IBE_ORDER_HEADER_ADV_V

[top of page]

APPS.IBE_ORDER_HEADER_ADV_V references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_PARTIES
SYNONYM - OE_ORDER_HEADERS_ALL
- OE_LOOKUPS

APPS.IBE_ORDER_HEADER_ADV_V is not referenced by any database object

[top of page]

View: IBE_ORDER_HEADER_V

[top of page]

APPS.IBE_ORDER_HEADER_V references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
PACKAGE - IBE_ORDER_UTIL_PVT
SYNONYM - OE_AGREEMENTS_TL
SYNONYM - OE_ORDER_HEADERS_ALL
PACKAGE - OE_SYS_PARAMETERS
PACKAGE - OE_TOTALS_GRP
SYNONYM - OE_TRANSACTION_TYPES_TL
SYNONYM - RA_TERMS_TL
- OE_SHIP_METHODS_V
- OE_LOOKUPS
- IBE_OE_CONTACTS_V

APPS.IBE_ORDER_HEADER_V is not referenced by any database object

[top of page]

View: IBE_ORDER_ITEMS_ADV_V

[top of page]

APPS.IBE_ORDER_ITEMS_ADV_V references the following:

APPS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - MTL_UNITS_OF_MEASURE_TL
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
PACKAGE - OE_PROFILE
- MTL_SYSTEM_ITEMS_VL
- OE_LOOKUPS

APPS.IBE_ORDER_ITEMS_ADV_V is not referenced by any database object

[top of page]

View: IBE_ORDER_LINE_DTL_V

[top of page]

APPS.IBE_ORDER_LINE_DTL_V references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
PACKAGE - IBE_ORDER_UTIL_PVT
SYNONYM - MTL_UNITS_OF_MEASURE_TL
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
PACKAGE - OE_PROFILE
SYNONYM - RA_CUSTOMER_TRX_ALL
SYNONYM - RA_TERMS_TL
- OE_SHIP_METHODS_V
- OE_AGREEMENTS_VL
- MTL_SYSTEM_ITEMS_VL
- IBE_OE_CONTACTS_V
- OE_LOOKUPS

APPS.IBE_ORDER_LINE_DTL_V is not referenced by any database object

[top of page]

View: IBE_ORDER_SUM_V

[top of page]

APPS.IBE_ORDER_SUM_V references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_PARTIES
SYNONYM - OE_ORDER_HEADERS_ALL
- OE_LOOKUPS

APPS.IBE_ORDER_SUM_V is not referenced by any database object

[top of page]

View: IBE_PAYMENT_DETAIL_V

[top of page]

APPS.IBE_PAYMENT_DETAIL_V references the following:

APPS
SYNONYM - AR_CASH_RECEIPTS_ALL
VIEW - AR_LOOKUPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
SYNONYM - HZ_CUST_ACCOUNTS

APPS.IBE_PAYMENT_DETAIL_V is not referenced by any database object

[top of page]

View: IBE_PAYMENT_HEADER_V

[top of page]

APPS.IBE_PAYMENT_HEADER_V references the following:

APPS
SYNONYM - AR_CASH_RECEIPTS_ALL
VIEW - AR_LOOKUPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES

APPS.IBE_PAYMENT_HEADER_V is not referenced by any database object

[top of page]

View: IBE_QUOTE_HEADERS_V

[top of page]

APPS.IBE_QUOTE_HEADERS_V references the following:

APPS
SYNONYM - ASO_QUOTE_HEADERS
VIEW - ASO_QUOTE_STATUSES_VL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS

APPS.IBE_QUOTE_HEADERS_V is not referenced by any database object

[top of page]

View: IBE_RETURNABLE_LINES_V

[top of page]

APPS.IBE_RETURNABLE_LINES_V references the following:

APPS
SYNONYM - MTL_UNITS_OF_MEASURE_TL
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
PACKAGE - OE_PROFILE
- MTL_SYSTEM_ITEMS_VL

APPS.IBE_RETURNABLE_LINES_V is not referenced by any database object

[top of page]

View: IBE_RETURNABLE_SERIAL_V

[top of page]

APPS.IBE_RETURNABLE_SERIAL_V references the following:

APPS
SYNONYM - MTL_MATERIAL_TRANSACTIONS
SYNONYM - MTL_SERIAL_NUMBERS
SYNONYM - MTL_UNITS_OF_MEASURE_TL
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
PACKAGE - OE_PROFILE
- MTL_SYSTEM_ITEMS_VL

APPS.IBE_RETURNABLE_SERIAL_V is not referenced by any database object

[top of page]

View: IBE_RETURN_DETAIL_V

[top of page]

APPS.IBE_RETURN_DETAIL_V references the following:

APPS
SYNONYM - MTL_UNITS_OF_MEASURE_TL
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
PACKAGE - OE_PROFILE
PACKAGE - OE_TOTALS_GRP
- MTL_SYSTEM_ITEMS_VL
- OE_LOOKUPS

APPS.IBE_RETURN_DETAIL_V is not referenced by any database object

[top of page]

View: IBE_RETURN_SUM_V

[top of page]

APPS.IBE_RETURN_SUM_V references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
- OE_LOOKUPS

APPS.IBE_RETURN_SUM_V is not referenced by any database object

[top of page]

View: IBE_SHIP_DETAIL_V

[top of page]

APPS.IBE_SHIP_DETAIL_V references the following:

APPS
SYNONYM - MTL_UNITS_OF_MEASURE_TL
SYNONYM - OE_ORDER_LINES_ALL
PACKAGE - OE_PROFILE
SYNONYM - WSH_DELIVERY_ASSIGNMENTS
SYNONYM - WSH_DELIVERY_DETAILS
SYNONYM - WSH_DELIVERY_LEGS
SYNONYM - WSH_NEW_DELIVERIES
SYNONYM - WSH_TRIPS
SYNONYM - WSH_TRIP_STOPS
- OE_SHIP_METHODS_V
- OE_LOOKUPS
- MTL_SYSTEM_ITEMS_VL
- WSH_LOOKUPS

APPS.IBE_SHIP_DETAIL_V is not referenced by any database object

[top of page]

View: IBE_SHIP_DLVY_DTL_V

[top of page]

APPS.IBE_SHIP_DLVY_DTL_V references the following:

APPS
SYNONYM - MTL_UNITS_OF_MEASURE_TL
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - WSH_DELIVERY_ASSIGNMENTS
SYNONYM - WSH_DELIVERY_DETAILS
SYNONYM - WSH_DELIVERY_LEGS
SYNONYM - WSH_NEW_DELIVERIES
SYNONYM - WSH_TRIPS
SYNONYM - WSH_TRIP_STOPS
- MTL_SYSTEM_ITEMS_VL
- OE_SHIP_METHODS_V
- WSH_LOOKUPS

APPS.IBE_SHIP_DLVY_DTL_V is not referenced by any database object

[top of page]

View: IBE_SHIP_DLVY_V

[top of page]

APPS.IBE_SHIP_DLVY_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - HZ_LOCATIONS
SYNONYM - MTL_UNITS_OF_MEASURE_TL
SYNONYM - WSH_NEW_DELIVERIES
- WSH_LOOKUPS
- OE_LOOKUPS
- OE_SHIP_METHODS_V

APPS.IBE_SHIP_DLVY_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract