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 - GMI Tables and Views

TABLE - GMI.GMI_AUTO_ALLOCATION_BATCH
TABLE - GMI.GMI_CATEGORY_SETS
TABLE - GMI.GMI_CLOS_WAREHOUSES
TABLE - GMI.GMI_DISCRETE_TRANSFERS
TABLE - GMI.GMI_DISCRETE_TRANSFER_LINES
TABLE - GMI.GMI_DISCRETE_TRANSFER_LOTS
TABLE - GMI.GMI_ITEMS_XML_INTERFACE
TABLE - GMI.GMI_ITEM_CATEGORIES
TABLE - GMI.GMI_ITEM_CONV_AUDIT
TABLE - GMI.GMI_ITEM_CONV_AUDIT_DETAILS
TABLE - GMI.GMI_ITEM_ORGANIZATIONS
TABLE - GMI.GMI_LOTS_CONV_XML_INTERFACE
TABLE - GMI.GMI_LOTS_XML_INTERFACE
TABLE - GMI.GMI_LOT_TRACE
TABLE - GMI.GMI_MASSTRANS_CTL
TABLE - GMI.GMI_MIGRATION_PARAMETERS
TABLE - GMI.GMI_OBSOLETE_ITEM_COLUMNS
TABLE - GMI.GMI_QUANTITY_XML_INTERFACE
TABLE - GMI.GMI_SUBLOT_GENERATE
TABLE - GMI.GMI_TRAN_TMP
TABLE - GMI.IC_ADJS_JNL
TABLE - GMI.IC_ALOT_PRM
TABLE - GMI.IC_CLDR_DTL
TABLE - GMI.IC_CLDR_HDR_B
TABLE - GMI.IC_CLDR_HDR_TL
TABLE - GMI.IC_COMD_CDS
TABLE - GMI.IC_CRUL_CLS
TABLE - GMI.IC_CYCL_ADT
TABLE - GMI.IC_CYCL_DTL
TABLE - GMI.IC_CYCL_ERR
TABLE - GMI.IC_CYCL_HDR
TABLE - GMI.IC_CYCL_MSC
TABLE - GMI.IC_DECM_MST
TABLE - GMI.IC_INVN_TYP
TABLE - GMI.IC_ITEM_CDT
TABLE - GMI.IC_ITEM_CNV
TABLE - GMI.IC_ITEM_CPG
TABLE - GMI.IC_ITEM_HIERARCHY
TABLE - GMI.IC_ITEM_MST_B
TABLE - GMI.IC_ITEM_MST_B_MIG
TABLE - GMI.IC_ITEM_MST_TL
TABLE - GMI.IC_ITEM_WHS
TABLE - GMI.IC_JRNL_MST
TABLE - GMI.IC_LOCT_INV
TABLE - GMI.IC_LOCT_MST
TABLE - GMI.IC_LOTS_CPG
TABLE - GMI.IC_LOTS_MST
TABLE - GMI.IC_LOTS_MST_MIG
TABLE - GMI.IC_LOTS_STS
TABLE - GMI.IC_PERD_BAL
TABLE - GMI.IC_PHYS_CNT
TABLE - GMI.IC_PHYS_ERR
TABLE - GMI.IC_PKGS_MST
TABLE - GMI.IC_PLNT_INV
TABLE - GMI.IC_PURG_PRM
TABLE - GMI.IC_RANK_MST
TABLE - GMI.IC_STAT_RPT
TABLE - GMI.IC_TAXN_ASC
TABLE - GMI.IC_TEXT_HDR
TABLE - GMI.IC_TEXT_TBL_TL
TABLE - GMI.IC_TRAN_ARC
TABLE - GMI.IC_TRAN_CMP
TABLE - GMI.IC_TRAN_PND
TABLE - GMI.IC_TXN_REQUEST_HEADERS
TABLE - GMI.IC_TXN_REQUEST_LINES
TABLE - GMI.IC_WHSE_INV
TABLE - GMI.IC_WHSE_MST
TABLE - GMI.IC_WHSE_REL
TABLE - GMI.IC_WHSE_STS
TABLE - GMI.IC_XFER_MST
TABLE - GMI.IN_ADDR_MST
TABLE - GMI.IN_CTRY_MST
TABLE - GMI.IN_ITEM_MST
TABLE - GMI.IN_REGN_MST
TABLE - GMI.IN_STAT_CTL
TABLE - GMI.IN_STAT_DTL
TABLE - GMI.IN_STAT_HDR
TABLE - GMI.IN_STAT_MSG
TABLE - GMI.IN_TEXT_HDR
TABLE - GMI.IN_TEXT_TBL_TL
TABLE - GMI.IN_TOFD_MST
TABLE - GMI.SY_WF_ITEM_ROLES
VIEW - APPS.GL_BUSINESS_CLS_VW
VIEW - APPS.GL_PROD_LINE_VW
VIEW - APPS.GMI_AAC_CUST_NUM_V
VIEW - APPS.GMI_AAC_ORDER_NUM_V
VIEW - APPS.GMI_ITEM_CATEGORIES_V1
VIEW - APPS.GMI_ITEM_ORGANIZATIONS_V1
VIEW - APPS.GMI_LOTS_BOM_V
VIEW - APPS.GMI_LOTS_COMP_V
VIEW - APPS.GMI_LOTS_DEST_BOM_V
VIEW - APPS.GMI_LOTS_DEST_LIST_V
VIEW - APPS.GMI_LOTS_DEST_V
VIEW - APPS.GMI_LOTS_EVENT_V
VIEW - APPS.GMI_LOTS_LIST_V
VIEW - APPS.GMI_LOTS_SOURCE_BOM_V
VIEW - APPS.GMI_LOTS_SOURCE_LIST_V
VIEW - APPS.GMI_PICK_LOTS_V
VIEW - APPS.GMI_PICK_SLIP_NUMBER_V
VIEW - APPS.GMI_PICK_SLIP_VW
VIEW - APPS.GMI_WSH_PICK_SLIP_V
VIEW - APPS.GMI_XFER_MST_V
VIEW - APPS.IC_ADJS_JNL_VW
VIEW - APPS.IC_ALLC_CLS_VW
VIEW - APPS.IC_CLDR_HDR_VL
VIEW - APPS.IC_COST_CLS_VW
VIEW - APPS.IC_CTMS_CLS_VW
VIEW - APPS.IC_FRGT_CLS_VW
VIEW - APPS.IC_GLED_CLS_VW
VIEW - APPS.IC_INVN_CLS_VW
VIEW - APPS.IC_ITEM_HIERARCHY_V
VIEW - APPS.IC_ITEM_INV_V
VIEW - APPS.IC_ITEM_MST_VL
VIEW - APPS.IC_LOCT_INV_RPTVW1
VIEW - APPS.IC_LOCT_INV_RPTVW2
VIEW - APPS.IC_LOCT_INV_RPTVW3
VIEW - APPS.IC_LOCT_INV_RPTVW4
VIEW - APPS.IC_LOCT_INV_UNALLOC
VIEW - APPS.IC_LOCT_MST_V1
VIEW - APPS.IC_LOTS_MST_V
VIEW - APPS.IC_LOTS_MST_V1
VIEW - APPS.IC_LOTS_MST_V2
VIEW - APPS.IC_MOVE_ORDER_LINES_V
VIEW - APPS.IC_PERD_BAL_VW1
VIEW - APPS.IC_PRCE_CLS_VW
VIEW - APPS.IC_PRCH_CLS_VW
VIEW - APPS.IC_PURG_VW1
VIEW - APPS.IC_SALE_CLS_VW
VIEW - APPS.IC_SHIP_CLS_VW
VIEW - APPS.IC_STOR_CLS_VW
VIEW - APPS.IC_SUMM_INV_INT_V
VIEW - APPS.IC_SUMM_INV_ONHAND_V
VIEW - APPS.IC_SUMM_INV_PENDING_V
VIEW - APPS.IC_SUMM_INV_V
VIEW - APPS.IC_TAXN_CLS_VW
VIEW - APPS.IC_TEXT_TBL_VL
VIEW - APPS.IC_TRAN_CMP_VW1
VIEW - APPS.IC_TRAN_PND_VW2
VIEW - APPS.IC_TRAN_PND_VW3
VIEW - APPS.IC_TRAN_VW1
VIEW - APPS.IC_TXN_REQUEST_LINES_V
VIEW - APPS.IC_WHSE_MST_VW
VIEW - APPS.INV_CALENDAR_VIEW
VIEW - APPS.IN_TEXT_TBL_VL
VIEW - APPS.SUB_STD_ITEM_CLS_VW
VIEW - APPS.TECH_CLS_SUBCLS_VW

Table: GMI_AUTO_ALLOCATION_BATCH

Description: auto allocation batch parameter table

[top of page]

GMI.GMI_AUTO_ALLOCATION_BATCH does not reference any database object

GMI.GMI_AUTO_ALLOCATION_BATCH is referenced by following:

APPS
SYNONYM - GMI_AUTO_ALLOCATION_BATCH

[top of page]

Table: GMI_CATEGORY_SETS

Description: Stores the association between the OPM Classifications and the Category Sets. Any defined Category Set can be assigned to an OPM Classification and the Category from that Category Set will be used in OPM for displaying and validating the v
Primary Key: GMI_CATEGORY_SETS_PK
  1. OPM_CLASS
Primary Key: GMI_CATEGORY_SETS_U1
  1. USER_OPM_CLASS

[top of page]

GMI.GMI_CATEGORY_SETS does not reference any database object

GMI.GMI_CATEGORY_SETS is referenced by following:

APPS
SYNONYM - GMI_CATEGORY_SETS

[top of page]

Table: GMI_CLOS_WAREHOUSES

Description: Warehouses to be closed for a year/period

[top of page]

GMI.GMI_CLOS_WAREHOUSES does not reference any database object

GMI.GMI_CLOS_WAREHOUSES is referenced by following:

APPS
SYNONYM - GMI_CLOS_WAREHOUSES

[top of page]

Table: GMI_DISCRETE_TRANSFERS

Description: Process to/from Discrete inventory transfer table. Holds transfer header information
Primary Key: GMI_DISCRETE_TRANSFERS_PK
  1. TRANSFER_ID

[top of page]

GMI.GMI_DISCRETE_TRANSFERS does not reference any database object

GMI.GMI_DISCRETE_TRANSFERS is referenced by following:

APPS
SYNONYM - GMI_DISCRETE_TRANSFERS

[top of page]

Table: GMI_DISCRETE_TRANSFER_LINES

Description: Process to/from Discrete inventory transfer lines table. Holds transfer lines information
Primary Key: GMI_DISCRETE_TRANSFER_LINES_PK
  1. TRANSFER_ID
  2. LINE_ID

[top of page]

GMI.GMI_DISCRETE_TRANSFER_LINES does not reference any database object

GMI.GMI_DISCRETE_TRANSFER_LINES is referenced by following:

APPS
SYNONYM - GMI_DISCRETE_TRANSFER_LINES

[top of page]

Table: GMI_DISCRETE_TRANSFER_LOTS

Description: Process to/from Discrete inventory transfer lots table. Holds transfer lots information belonging to transfer lines
Primary Key: GMI_DISCRETE_TRANSFER_LOTS_PK
  1. TRANSFER_ID
  2. LINE_ID
  3. LINE_DETAIL_ID

[top of page]

GMI.GMI_DISCRETE_TRANSFER_LOTS does not reference any database object

GMI.GMI_DISCRETE_TRANSFER_LOTS is referenced by following:

APPS
SYNONYM - GMI_DISCRETE_TRANSFER_LOTS

[top of page]

Table: GMI_ITEMS_XML_INTERFACE

Description: This table holds the xml gateway api request to add an Item to OPM
Primary Key: GMI_ITEMS_XML_INTERFACE_PK
  1. ITEM_INTERFACE_ID

[top of page]

GMI.GMI_ITEMS_XML_INTERFACE does not reference any database object

GMI.GMI_ITEMS_XML_INTERFACE is referenced by following:

APPS
SYNONYM - GMI_ITEMS_XML_INTERFACE

[top of page]

Table: GMI_ITEM_CATEGORIES

Description: Stores the category assigned to OPM Items. Note that for existing OPM Classifications, the categories assigned are maintained both in this table and the ic_item_mst table. For the new OPM Classifications, this is the only table where they a
Primary Key: GMI_ITEM_CATEGORIES_PK
  1. ITEM_ID
  2. CATEGORY_SET_ID
  3. CATEGORY_ID

[top of page]

GMI.GMI_ITEM_CATEGORIES does not reference any database object

GMI.GMI_ITEM_CATEGORIES is referenced by following:

APPS
SYNONYM - GMI_ITEM_CATEGORIES

[top of page]

Table: GMI_ITEM_CONV_AUDIT

Description: Contains history of all lot conversions holding old and new values and date of change
Primary Key: GMI_ITEM_CONV_AUDIT_PK
  1. CONV_AUDIT_ID

[top of page]

GMI.GMI_ITEM_CONV_AUDIT does not reference any database object

GMI.GMI_ITEM_CONV_AUDIT is referenced by following:

APPS
SYNONYM - GMI_ITEM_CONV_AUDIT

[top of page]

Table: GMI_ITEM_CONV_AUDIT_DETAILS

Description: Contains inventory transaction details for a conversion record in gmi_item_conversion_audit table
Primary Key: GMI_ITEM_CONV_AUDIT_DETAILS_PK
  1. CONV_AUDIT_DETAIL_ID

[top of page]

GMI.GMI_ITEM_CONV_AUDIT_DETAILS does not reference any database object

GMI.GMI_ITEM_CONV_AUDIT_DETAILS is referenced by following:

APPS
SYNONYM - GMI_ITEM_CONV_AUDIT_DETAILS

[top of page]

Table: GMI_ITEM_ORGANIZATIONS

Description: Relates OPM to Apps Organization Definitions
Primary Key: GMI_ITEM_ORGANIZATION_PK
  1. ORGANIZATION_ID

[top of page]

GMI.GMI_ITEM_ORGANIZATIONS does not reference any database object

GMI.GMI_ITEM_ORGANIZATIONS is referenced by following:

APPS
SYNONYM - GMI_ITEM_ORGANIZATIONS

[top of page]

Table: GMI_LOTS_CONV_XML_INTERFACE

Description: This table contains the Item/lot conversion xml api request.
Primary Key: GMI_LOTS_CONV_XML_INTERFACE_PK
  1. CONV_INTERFACE_ID

[top of page]

GMI.GMI_LOTS_CONV_XML_INTERFACE does not reference any database object

GMI.GMI_LOTS_CONV_XML_INTERFACE is referenced by following:

APPS
SYNONYM - GMI_LOTS_CONV_XML_INTERFACE

[top of page]

Table: GMI_LOTS_XML_INTERFACE

Description: This is the XML Lot API Interface table. This table stores data about individual xml lot api requests.
Primary Key: GMI_LOTS_XML_INTERFACE_PK
  1. LOT_INTERFACE_ID

[top of page]

GMI.GMI_LOTS_XML_INTERFACE does not reference any database object

GMI.GMI_LOTS_XML_INTERFACE is referenced by following:

APPS
SYNONYM - GMI_LOTS_XML_INTERFACE

[top of page]

Table: GMI_LOT_TRACE

Description: GMI Lot Trace

[top of page]

GMI.GMI_LOT_TRACE does not reference any database object

GMI.GMI_LOT_TRACE is referenced by following:

APPS
SYNONYM - GMI_LOT_TRACE

[top of page]

Table: GMI_MASSTRANS_CTL

Description: Contains record of mass move transaction created.

[top of page]

GMI.GMI_MASSTRANS_CTL does not reference any database object

GMI.GMI_MASSTRANS_CTL is referenced by following:

APPS
SYNONYM - GMI_MASSTRANS_CTL

[top of page]

Table: GMI_MIGRATION_PARAMETERS

Description: This is a single row table that contains the values for the migration populated via the pre-migration form.

[top of page]

GMI.GMI_MIGRATION_PARAMETERS does not reference any database object

GMI.GMI_MIGRATION_PARAMETERS is referenced by following:

APPS
SYNONYM - GMI_MIGRATION_PARAMETERS

[top of page]

Table: GMI_OBSOLETE_ITEM_COLUMNS

Description: This is table to store the reference to all OPM item master obsolete columns mapped to the discrete item master flexfield

[top of page]

GMI.GMI_OBSOLETE_ITEM_COLUMNS does not reference any database object

GMI.GMI_OBSOLETE_ITEM_COLUMNS is referenced by following:

APPS
SYNONYM - GMI_OBSOLETE_ITEM_COLUMNS

[top of page]

Table: GMI_QUANTITY_XML_INTERFACE

Description: This table entries for the XML Gateway Inventory Quantity API requests.
Primary Key: GMI_QUANTITY_XML_INTERFACE_PK
  1. QUANTITY_INTERFACE_ID

[top of page]

GMI.GMI_QUANTITY_XML_INTERFACE does not reference any database object

GMI.GMI_QUANTITY_XML_INTERFACE is referenced by following:

APPS
SYNONYM - GMI_QUANTITY_XML_INTERFACE

[top of page]

Table: GMI_SUBLOT_GENERATE

Description: Holds values for next sublot to be generated for a Lot
Primary Key: GMI_SUBLOT_GENERATE_PK
  1. ITEM_ID
  2. LOT_NO

[top of page]

GMI.GMI_SUBLOT_GENERATE does not reference any database object

GMI.GMI_SUBLOT_GENERATE is referenced by following:

APPS
SYNONYM - GMI_SUBLOT_GENERATE

[top of page]

Table: GMI_TRAN_TMP

Description: Stores data temporarily for Pick Lots Screen

[top of page]

GMI.GMI_TRAN_TMP does not reference any database object

GMI.GMI_TRAN_TMP is referenced by following:

APPS
SYNONYM - GMI_TRAN_TMP

[top of page]

Table: IC_ADJS_JNL

Description: Inventory adjustment detail
Primary Key: IC_ADJS_JNL_PK
  1. TRANS_TYPE
  2. TRANS_FLAG
  3. DOC_ID
  4. DOC_LINE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_ADJS_JNL.QC_GRADE GMD_GRADES_B
IC_ADJS_JNL.ITEM_ID IC_ITEM_MST_B
IC_ADJS_JNL.ITEM_ID IC_ITEM_MST
IC_ADJS_JNL.JOURNAL_ID IC_JRNL_MST
IC_ADJS_JNL.ITEM_ID
IC_ADJS_JNL.LOT_ID 		IC_LOTS_MST
IC_ADJS_JNL.LOT_STATUS IC_LOTS_STS
IC_ADJS_JNL.WHSE_CODE IC_WHSE_MST
IC_ADJS_JNL.QC_GRADE QC_GRAD_MST
IC_ADJS_JNL.TRANS_TYPE SY_DOCS_MST
IC_ADJS_JNL.ORGN_CODE SY_ORGN_MST_B
IC_ADJS_JNL.CO_CODE SY_ORGN_MST_B
IC_ADJS_JNL.ORGN_CODE SY_ORGN_MST
IC_ADJS_JNL.CO_CODE SY_ORGN_MST
IC_ADJS_JNL.REASON_CODE SY_REAS_CDS_B
IC_ADJS_JNL.REASON_CODE SY_REAS_CDS
IC_ADJS_JNL.ITEM_UM SY_UOMS_MST
IC_ADJS_JNL.ITEM_UM2 SY_UOMS_MST

[top of page]

GMI.IC_ADJS_JNL does not reference any database object

GMI.IC_ADJS_JNL is referenced by following:

APPS
SYNONYM - IC_ADJS_JNL

[top of page]

Table: IC_ALOT_PRM

Description: Automatic lot allocation parameters
Primary Key: IC_ALOT_PRM_PK
  1. ALLOC_CLASS
  2. WHSE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_ALOT_PRM.WHSE_CODE IC_WHSE_MST
IC_ALOT_PRM.ALLOC_CLASS IC_ALLC_CLS
IC_ALOT_PRM.TEXT_CODE IC_TEXT_HDR

[top of page]

GMI.IC_ALOT_PRM does not reference any database object

GMI.IC_ALOT_PRM is referenced by following:

APPS
SYNONYM - IC_ALOT_PRM

[top of page]

Table: IC_CLDR_DTL

Description: Inventory calendar detail
Primary Key: IC_CLDR_DTL_PK
  1. PERIOD_ID
Primary Key: IC_CLDR_DTL_U1
  1. ORGN_CODE
  2. FISCAL_YEAR
  3. PERIOD
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_CLDR_DTL.ORGN_CODE
IC_CLDR_DTL.FISCAL_YEAR 		IC_CLDR_HDR_B
IC_CLDR_DTL.ORGN_CODE
IC_CLDR_DTL.FISCAL_YEAR 		IC_CLDR_HDR
IC_CLDR_DTL.TEXT_CODE IC_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_WHSE_STS.PERIOD_ID IC_CLDR_DTL

[top of page]

GMI.IC_CLDR_DTL does not reference any database object

GMI.IC_CLDR_DTL is referenced by following:

APPS
SYNONYM - IC_CLDR_DTL

[top of page]

Table: IC_CLDR_HDR_B

Description: This table contains header information for the inventory calendar. The fiscal year is defined, calendar periods will be setup in the IC_CLDR_DTL table.
Primary Key: IC_CLDR_HDR_B_PK
  1. ORGN_CODE
  2. FISCAL_YEAR
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_CLDR_HDR_B.TEXT_CODE IC_TEXT_HDR
IC_CLDR_HDR_B.ORGN_CODE SY_ORGN_MST_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_CLDR_DTL.ORGN_CODE
IC_CLDR_DTL.FISCAL_YEAR 		IC_CLDR_HDR_B

[top of page]

GMI.IC_CLDR_HDR_B does not reference any database object

GMI.IC_CLDR_HDR_B is referenced by following:

APPS
SYNONYM - IC_CLDR_HDR_B

[top of page]

Table: IC_CLDR_HDR_TL

Description: Translations table table holding OPM inventory calendar descriptions in multiple languages
Primary Key: IC_CLDR_HDR_TL_PK
  1. ORGN_CODE
  2. FISCAL_YEAR
  3. LANGUAGE

[top of page]

GMI.IC_CLDR_HDR_TL does not reference any database object

GMI.IC_CLDR_HDR_TL is referenced by following:

APPS
SYNONYM - IC_CLDR_HDR_TL

[top of page]

Table: IC_COMD_CDS

Description: Commodity Codes Table. This table contains information about the commodity codes which are used by the Intrastat Module.
Primary Key: IC_COMD_CDS_PK
  1. COMMODITY_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_COMD_CDS.TEXT_CODE IC_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_ITEM_MST_B.COMMODITY_CODE IC_COMD_CDS
IC_ITEM_MST.COMMODITY_CODE IC_COMD_CDS

[top of page]

GMI.IC_COMD_CDS does not reference any database object

GMI.IC_COMD_CDS is referenced by following:

APPS
SYNONYM - IC_COMD_CDS

[top of page]

Table: IC_CRUL_CLS

Description: Count class table
Primary Key: IC_CRUL_CLS_PK
  1. COUNT_CLASS
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_CRUL_CLS.TEXT_CODE IC_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_WHSE_INV.COUNT_CLASS IC_CRUL_CLS

[top of page]

GMI.IC_CRUL_CLS does not reference any database object

GMI.IC_CRUL_CLS is referenced by following:

APPS
SYNONYM - IC_CRUL_CLS

[top of page]

Table: IC_CYCL_ADT

Description: Cycle audit
Primary Key: IC_CYCL_ADT_PK
  1. CYCLE_ID
  2. SEQ_NO
Primary Key: IC_CYCL_ADT_U1
  1. SEQ_NO
  2. CYCLE_ID
  3. ITEM_ID
  4. WHSE_CODE
  5. LOCATION
  6. LOT_NO
  7. SUBLOT_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_CYCL_ADT.DOC_TYPE SY_DOCS_MST
IC_CYCL_ADT.UOM1 SY_UOMS_MST
IC_CYCL_ADT.UOM2 SY_UOMS_MST

[top of page]

GMI.IC_CYCL_ADT does not reference any database object

GMI.IC_CYCL_ADT is referenced by following:

APPS
SYNONYM - IC_CYCL_ADT

[top of page]

Table: IC_CYCL_DTL

Description: Cycle detail
Primary Key: IC_CYCL_DTL_PK
  1. ITEM_ID
  2. WHSE_CODE
  3. LOT_ID
  4. LOCATION
  5. CYCLE_ID
  6. COUNT_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_CYCL_DTL.CYCLE_ID IC_CYCL_HDR
IC_CYCL_DTL.ITEM_ID
IC_CYCL_DTL.LOT_ID 		IC_LOTS_MST

[top of page]

GMI.IC_CYCL_DTL does not reference any database object

GMI.IC_CYCL_DTL is referenced by following:

APPS
SYNONYM - IC_CYCL_DTL

[top of page]

Table: IC_CYCL_ERR

Description: Cycle Count Error Table.
Primary Key: IC_CYCL_ERR_PK
  1. CYCLE_ID
  2. ITEM_ID
  3. WHSE_CODE
  4. LOT_ID
  5. LOCATION

[top of page]

GMI.IC_CYCL_ERR does not reference any database object

GMI.IC_CYCL_ERR is referenced by following:

APPS
SYNONYM - IC_CYCL_ERR

[top of page]

Table: IC_CYCL_HDR

Description: This table contains the cycle header information. It will define the warehouse for which the count is taking place.
Primary Key: IC_CYCL_HDR_PK
  1. CYCLE_ID
Primary Key: IC_CYCL_HDR_U1
  1. ORGN_CODE
  2. CYCLE_NO
  3. CYCLE_SOURCE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_CYCL_HDR.TEXT_CODE IC_TEXT_HDR
IC_CYCL_HDR.WHSE_CODE IC_WHSE_MST
IC_CYCL_HDR.ORGN_CODE SY_ORGN_MST_B
IC_CYCL_HDR.ORGN_CODE SY_ORGN_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_CYCL_DTL.CYCLE_ID IC_CYCL_HDR
IC_CYCL_MSC.CYCLE_ID IC_CYCL_HDR

[top of page]

GMI.IC_CYCL_HDR does not reference any database object

GMI.IC_CYCL_HDR is referenced by following:

APPS
SYNONYM - IC_CYCL_HDR

[top of page]

Table: IC_CYCL_MSC

Description: This table contains the additional items added to a cycle count.
Primary Key: IC_CYCL_MSC_PK
  1. CYCL_MSC_ID
Primary Key: IC_CYCL_MSC_U1
  1. CYCLE_ID
  2. ENTRY_TYPE
  3. ITEM_ID
  4. ABC_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_CYCL_MSC.CYCLE_ID IC_CYCL_HDR
IC_CYCL_MSC.ITEM_ID IC_ITEM_MST_B
IC_CYCL_MSC.ITEM_ID IC_ITEM_MST
IC_CYCL_MSC.TEXT_CODE IC_TEXT_HDR

[top of page]

GMI.IC_CYCL_MSC does not reference any database object

GMI.IC_CYCL_MSC is referenced by following:

APPS
SYNONYM - IC_CYCL_MSC

[top of page]

Table: IC_DECM_MST

Description: Store information about records in IC_LOCT_INV whose decimal quantities have been reset to tolerance levels.
Primary Key: IC_DECM_MST_PK
  1. LOG_ID

[top of page]

GMI.IC_DECM_MST does not reference any database object

GMI.IC_DECM_MST is referenced by following:

APPS
SYNONYM - IC_DECM_MST

[top of page]

Table: IC_INVN_TYP

Description: This table contains the definition of the Inventory Types that can be used throughout OPM.
Primary Key: IC_INVN_TYP_PK
  1. INV_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_INVN_TYP.TEXT_CODE IC_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_ITEM_MST_B.INV_TYPE IC_INVN_TYP
IC_ITEM_MST.INV_TYPE IC_INVN_TYP

[top of page]

GMI.IC_INVN_TYP does not reference any database object

GMI.IC_INVN_TYP is referenced by following:

APPS
SYNONYM - IC_INVN_TYP

[top of page]

Table: IC_ITEM_CDT

Description: Scheduled count date
Primary Key: IC_ITEM_CDT_PK
  1. ITEM_CDT_ID
Primary Key: IC_ITEM_CDT_U1
  1. WHSE_CODE
  2. ITEM_ID
  3. SCHED_DT
  4. CYCLE_TYPE
  5. CYCLE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_ITEM_CDT.TEXT_CODE IC_TEXT_HDR
IC_ITEM_CDT.ITEM_ID
IC_ITEM_CDT.WHSE_CODE 		IC_WHSE_INV

[top of page]

GMI.IC_ITEM_CDT does not reference any database object

GMI.IC_ITEM_CDT is referenced by following:

APPS
SYNONYM - IC_ITEM_CDT

[top of page]

Table: IC_ITEM_CNV

Description: This table contains the Item/lot conversion factors.
Primary Key: IC_ITEM_CNV_PK
  1. CONVERSION_ID
Primary Key: IC_ITEM_CNV_U1
  1. ITEM_ID
  2. LOT_ID
  3. UM_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_ITEM_CNV.ITEM_ID
IC_ITEM_CNV.LOT_ID 		IC_LOTS_MST
IC_ITEM_CNV.TEXT_CODE IC_TEXT_HDR
IC_ITEM_CNV.UM_TYPE SY_UOMS_TYP

[top of page]

GMI.IC_ITEM_CNV does not reference any database object

GMI.IC_ITEM_CNV is referenced by following:

APPS
SYNONYM - IC_ITEM_CNV

[top of page]

Table: IC_ITEM_CPG

Description: This table contains item information that is specific to a CPG installation.
Primary Key: IC_ITEM_CPG_PK
  1. ITEM_ID

[top of page]

GMI.IC_ITEM_CPG does not reference any database object

GMI.IC_ITEM_CPG is referenced by following:

APPS
SYNONYM - IC_ITEM_CPG

[top of page]

Table: IC_ITEM_HIERARCHY

Description: This table contains hierarchical information defined for the Item Activation Workflow. Use this table to setup users to approve the creation of items.
Primary Key: IC_ITEM_HIERARCHY_PK
  1. CREATOR_USER_NAME

[top of page]

GMI.IC_ITEM_HIERARCHY does not reference any database object

GMI.IC_ITEM_HIERARCHY is referenced by following:

APPS
SYNONYM - IC_ITEM_HIERARCHY

[top of page]

Table: IC_ITEM_MST_B

Description: This is the Item definition table. It contains all information relating to an item, such as lot/sublot control, unit of measure information, and all class and type designations.
Primary Key: IC_ITEM_MST_B_PK
  1. ITEM_ID
Primary Key: IC_ITEM_MST_B_UNQ1
  1. ITEM_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_ITEM_MST_B.COMMODITY_CODE IC_COMD_CDS
IC_ITEM_MST_B.QC_GRADE GMD_GRADES_B
IC_ITEM_MST_B.INV_TYPE IC_INVN_TYP
IC_ITEM_MST_B.LOT_STATUS IC_LOTS_STS
IC_ITEM_MST_B.PKG_ID IC_PKGS_MST
IC_ITEM_MST_B.TEXT_CODE IC_TEXT_HDR
IC_ITEM_MST_B.EXPACTION_CODE QC_ACTN_MST
IC_ITEM_MST_B.QC_GRADE QC_GRAD_MST
IC_ITEM_MST_B.QCHOLD_RES_CODE QC_HRES_MST
IC_ITEM_MST_B.WHSE_ITEM_ID IC_ITEM_MST_B
IC_ITEM_MST_B.BULK_ID IC_ITEM_MST_B
IC_ITEM_MST_B.QCITEM_ID IC_ITEM_MST_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
CM_ACST_LED.ITEM_ID IC_ITEM_MST_B
CM_ADJS_DTL.ITEM_ID IC_ITEM_MST_B
CM_BRDN_DTL.ITEM_ID IC_ITEM_MST_B
CM_CMPT_DTL.ITEM_ID IC_ITEM_MST_B
CM_CMPT_MTL.ITEM_ID IC_ITEM_MST_B
CM_SCST_LED.ITEM_ID IC_ITEM_MST_B
CM_WHSE_EFF.ITEM_ID IC_ITEM_MST_B
CM_WHSE_SRC.ITEM_ID IC_ITEM_MST_B
CR_SQDS_TBL.FROM_ITEM_ID IC_ITEM_MST_B
CR_SQDS_TBL.TO_ITEM_ID IC_ITEM_MST_B
FC_FCST_DTL.ITEM_ID IC_ITEM_MST_B
FM_MATL_DTL.ITEM_ID IC_ITEM_MST_B
GL_ACCT_MAP.ITEM_ID IC_ITEM_MST_B
GL_ALOC_BAS.ITEM_ID IC_ITEM_MST_B
GL_ITEM_CST.ITEM_ID IC_ITEM_MST_B
GMF_BURDEN_PERCENTAGES.ITEM_ID IC_ITEM_MST_B
GMP_ITEM_APS.ITEM_ID IC_ITEM_MST_B
GMP_ITEM_APS.ITEM_NO IC_ITEM_MST_B
GMP_ITEM_WPS.ITEM_ID IC_ITEM_MST_B
GMP_ITEM_WPS.ITEM_NO IC_ITEM_MST_B
GR_GENERIC_ITEMS_B.ITEM_NO IC_ITEM_MST_B
IC_ADJS_JNL.ITEM_ID IC_ITEM_MST_B
IC_CYCL_MSC.ITEM_ID IC_ITEM_MST_B
IC_ITEM_MST_B.WHSE_ITEM_ID IC_ITEM_MST_B
IC_ITEM_MST_B.BULK_ID IC_ITEM_MST_B
IC_ITEM_MST_B.QCITEM_ID IC_ITEM_MST_B
IC_ITEM_WHS.ITEM_ID IC_ITEM_MST_B
IC_LOTS_MST.ITEM_ID IC_ITEM_MST_B
IC_PLNT_INV.ITEM_ID IC_ITEM_MST_B
IC_STAT_RPT.ITEM_ID IC_ITEM_MST_B
IC_TAXN_ASC.ITEM_ID IC_ITEM_MST_B
IC_TRAN_ARC.ITEM_ID IC_ITEM_MST_B
IC_TRAN_CMP.ITEM_ID IC_ITEM_MST_B
IC_TRAN_PND.ITEM_ID IC_ITEM_MST_B
IC_WHSE_INV.ITEM_ID IC_ITEM_MST_B
IC_WHSE_REL.ITEM_ID IC_ITEM_MST_B
IC_XFER_MST.ITEM_ID IC_ITEM_MST_B
LM_ITEM_DAT.ITEM_ID IC_ITEM_MST_B
LM_SPRD_DTL.ITEM_ID IC_ITEM_MST_B
MR_ACTN_TBL.ITEM_ID IC_ITEM_MST_B
MR_MESG_TBL.ITEM_ID1 IC_ITEM_MST_B
MR_MESG_TBL.ITEM_ID2 IC_ITEM_MST_B
MR_TRAN_TBL.ITEM_ID IC_ITEM_MST_B
OP_CHRG_ITM.ITEM_ID IC_ITEM_MST_B
OP_CNTR_DTL.ITEM_ID IC_ITEM_MST_B
OP_CUST_ITM.ITEM_ID IC_ITEM_MST_B
OP_GNRC_ITM.ITEM_ID IC_ITEM_MST_B
OP_ORDR_DTL.ITEM_ID IC_ITEM_MST_B
OP_PKGD_ITM.BULK_ITEM_ID IC_ITEM_MST_B
OP_PRCE_ITM.ITEM_ID IC_ITEM_MST_B
OP_PRSL_DTL.ITEM_ID IC_ITEM_MST_B
PO_BPOS_DTL.ITEM_ID IC_ITEM_MST_B
PO_DIST_DTL.ITEM_ID IC_ITEM_MST_B
PO_ORDR_DTL.ITEM_ID IC_ITEM_MST_B
PO_RECV_DTL.ITEM_ID IC_ITEM_MST_B
PO_RTRN_DTL.ITEM_ID IC_ITEM_MST_B
PO_VNIT_MST.ITEM_ID IC_ITEM_MST_B
PS_WHSE_EFF.WHSE_ITEM_ID IC_ITEM_MST_B
QC_RSLT_MST.ITEM_ID IC_ITEM_MST_B
QC_SMPL_MST.ITEM_ID IC_ITEM_MST_B
QC_SPEC_MST.ITEM_ID IC_ITEM_MST_B

[top of page]

GMI.IC_ITEM_MST_B does not reference any database object

GMI.IC_ITEM_MST_B is referenced by following:

APPS
SYNONYM - IC_ITEM_MST_B

[top of page]

Table: IC_ITEM_MST_B_MIG

Description: This is table to store the reference to all successfully migrated OPM items. A separate table is need because the OPM item can be migrated to multiple discrete organizations.

[top of page]

GMI.IC_ITEM_MST_B_MIG does not reference any database object

GMI.IC_ITEM_MST_B_MIG is referenced by following:

APPS
SYNONYM - IC_ITEM_MST_B_MIG

[top of page]

Table: IC_ITEM_MST_TL

Description: Translations table table holding OPM item descriptions in multiple languages
Primary Key: IC_ITEM_MST_TL_PK
  1. ITEM_ID
  2. LANGUAGE

[top of page]

GMI.IC_ITEM_MST_TL does not reference any database object

GMI.IC_ITEM_MST_TL is referenced by following:

APPS
SYNONYM - IC_ITEM_MST_TL

[top of page]

Table: IC_ITEM_WHS

Description: *NOT USED*
Primary Key: IC_ITEM_WHS_PK
  1. ITEM_ID
  2. WHSE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_ITEM_WHS.ITEM_ID IC_ITEM_MST_B
IC_ITEM_WHS.ITEM_ID IC_ITEM_MST
IC_ITEM_WHS.WHSE_CODE IC_WHSE_MST

[top of page]

GMI.IC_ITEM_WHS does not reference any database object

GMI.IC_ITEM_WHS is referenced by following:

APPS
SYNONYM - IC_ITEM_WHS

[top of page]

Table: IC_JRNL_MST

Description: Journal master header table
Primary Key: IC_JRNL_MST_I1
  1. JOURNAL_NO
  2. ORGN_CODE
Primary Key: IC_JRNL_MST_PK
  1. JOURNAL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_JRNL_MST.TEXT_CODE IC_TEXT_HDR
IC_JRNL_MST.ORGN_CODE SY_ORGN_MST_B
IC_JRNL_MST.ORGN_CODE SY_ORGN_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_ADJS_JNL.JOURNAL_ID IC_JRNL_MST

[top of page]

GMI.IC_JRNL_MST does not reference any database object

GMI.IC_JRNL_MST is referenced by following:

APPS
SYNONYM - IC_JRNL_MST

[top of page]

Table: IC_LOCT_INV

Description: Location inventory table.
Primary Key: IC_LOCT_INV_PK
  1. ITEM_ID
  2. WHSE_CODE
  3. LOT_ID
  4. LOCATION
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_LOCT_INV.ITEM_ID
IC_LOCT_INV.LOT_ID 		IC_LOTS_MST
IC_LOCT_INV.LOT_STATUS IC_LOTS_STS
IC_LOCT_INV.TEXT_CODE IC_TEXT_HDR
IC_LOCT_INV.WHSE_CODE IC_WHSE_MST
IC_LOCT_INV.QCHOLD_RES_CODE QC_HRES_MST

[top of page]

GMI.IC_LOCT_INV does not reference any database object

GMI.IC_LOCT_INV is referenced by following:

APPS
SYNONYM - IC_LOCT_INV

[top of page]

Table: IC_LOCT_MST

Description: This table contains location information for location controlled warehouses.
Primary Key: IC_LOCT_MST_PK
  1. WHSE_CODE
  2. LOCATION
Primary Key: IC_LOCT_MST_U1
  1. INVENTORY_LOCATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_LOCT_MST.TEXT_CODE IC_TEXT_HDR
IC_LOCT_MST.WHSE_CODE IC_WHSE_MST
IC_LOCT_MST.CAPACITY_UM SY_UOMS_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_TRAN_ARC.WHSE_CODE
IC_TRAN_ARC.LOCATION 		IC_LOCT_MST
QC_RSLT_MST.WHSE_CODE
QC_RSLT_MST.LOCATION 		IC_LOCT_MST
QC_SPEC_MST.WHSE_CODE
QC_SPEC_MST.LOCATION 		IC_LOCT_MST

[top of page]

GMI.IC_LOCT_MST does not reference any database object

GMI.IC_LOCT_MST is referenced by following:

APPS
SYNONYM - IC_LOCT_MST

[top of page]

Table: IC_LOTS_CPG

Description: This table contains lot information that is specific to a CPG installation.
Primary Key: IC_LOTS_CPG_PK
  1. ITEM_ID
  2. LOT_ID

[top of page]

GMI.IC_LOTS_CPG does not reference any database object

GMI.IC_LOTS_CPG is referenced by following:

APPS
SYNONYM - IC_LOTS_CPG

[top of page]

Table: IC_LOTS_MST

Description: This is the lot master table. This table stores data about individual lots for an item.
Primary Key: IC_LOTS_MST_I1
  1. LOT_NO
  2. SUBLOT_NO
  3. ITEM_ID
Primary Key: IC_LOTS_MST_PK
  1. ITEM_ID
  2. LOT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_LOTS_MST.QC_GRADE GMD_GRADES_B
IC_LOTS_MST.ITEM_ID IC_ITEM_MST_B
IC_LOTS_MST.ITEM_ID IC_ITEM_MST
IC_LOTS_MST.TEXT_CODE IC_TEXT_HDR
IC_LOTS_MST.SHIPVEND_ID PO_VEND_MST
IC_LOTS_MST.EXPACTION_CODE QC_ACTN_MST
IC_LOTS_MST.QC_GRADE QC_GRAD_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_ADJS_JNL.ITEM_ID
IC_ADJS_JNL.LOT_ID 		IC_LOTS_MST
IC_CYCL_DTL.ITEM_ID
IC_CYCL_DTL.LOT_ID 		IC_LOTS_MST
IC_ITEM_CNV.ITEM_ID
IC_ITEM_CNV.LOT_ID 		IC_LOTS_MST
IC_LOCT_INV.ITEM_ID
IC_LOCT_INV.LOT_ID 		IC_LOTS_MST
IC_PERD_BAL.ITEM_ID
IC_PERD_BAL.LOT_ID 		IC_LOTS_MST
IC_STAT_RPT.ITEM_ID
IC_STAT_RPT.LOT_ID 		IC_LOTS_MST
IC_TRAN_ARC.ITEM_ID
IC_TRAN_ARC.LOT_ID 		IC_LOTS_MST
IC_TRAN_CMP.ITEM_ID
IC_TRAN_CMP.LOT_ID 		IC_LOTS_MST
IC_TRAN_PND.ITEM_ID
IC_TRAN_PND.LOT_ID 		IC_LOTS_MST
IC_XFER_MST.ITEM_ID
IC_XFER_MST.LOT_ID 		IC_LOTS_MST
LM_ITEM_DAT.ITEM_ID
LM_ITEM_DAT.LOT_ID 		IC_LOTS_MST
QC_RSLT_MST.ITEM_ID
QC_RSLT_MST.LOT_ID 		IC_LOTS_MST
QC_SMPL_MST.ITEM_ID
QC_SMPL_MST.LOT_ID 		IC_LOTS_MST
QC_SPEC_MST.ITEM_ID
QC_SPEC_MST.LOT_ID 		IC_LOTS_MST

[top of page]

GMI.IC_LOTS_MST does not reference any database object

GMI.IC_LOTS_MST is referenced by following:

APPS
SYNONYM - IC_LOTS_MST

[top of page]

Table: IC_LOTS_MST_MIG

Description: This is table to store the reference to all successfully migrated OPM items. A separate table is need because the OPM lots can be migrated to multiple discrete organizations.

[top of page]

GMI.IC_LOTS_MST_MIG does not reference any database object

GMI.IC_LOTS_MST_MIG is referenced by following:

APPS
SYNONYM - IC_LOTS_MST_MIG

[top of page]

Table: IC_LOTS_STS

Description: Lot status table.
Primary Key: IC_LOTS_STS_PK
  1. LOT_STATUS
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_LOTS_STS.TEXT_CODE IC_TEXT_HDR
IC_LOTS_STS.QCHOLD_RES_CODE QC_HRES_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_ADJS_JNL.LOT_STATUS IC_LOTS_STS
IC_ITEM_MST_B.LOT_STATUS IC_LOTS_STS
IC_ITEM_MST.LOT_STATUS IC_LOTS_STS
IC_LOCT_INV.LOT_STATUS IC_LOTS_STS
IC_PERD_BAL.LOT_STATUS IC_LOTS_STS
IC_TRAN_ARC.LOT_STATUS IC_LOTS_STS
IC_TRAN_CMP.LOT_STATUS IC_LOTS_STS
IC_TRAN_PND.LOT_STATUS IC_LOTS_STS
IC_XFER_MST.LOT_STATUS IC_LOTS_STS

[top of page]

GMI.IC_LOTS_STS does not reference any database object

GMI.IC_LOTS_STS is referenced by following:

APPS
SYNONYM - IC_LOTS_STS

[top of page]

Table: IC_PERD_BAL

Description: Inventory period balances
Primary Key: IC_PERD_BAL_PK
  1. PERIOD_ID
  2. WHSE_CODE
  3. ITEM_ID
  4. LOT_ID
  5. LOCATION
Primary Key: IC_PERD_BAL_U1
  1. FISCAL_YEAR
  2. PERIOD
  3. WHSE_CODE
  4. ITEM_ID
  5. LOT_ID
  6. LOCATION
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_PERD_BAL.ITEM_ID
IC_PERD_BAL.LOT_ID 		IC_LOTS_MST
IC_PERD_BAL.LOT_STATUS IC_LOTS_STS
IC_PERD_BAL.PERIOD_ID
IC_PERD_BAL.WHSE_CODE 		IC_WHSE_STS
IC_PERD_BAL.QCHOLD_RES_CODE QC_HRES_MST

[top of page]

GMI.IC_PERD_BAL does not reference any database object

GMI.IC_PERD_BAL is referenced by following:

APPS
SYNONYM - IC_PERD_BAL

[top of page]

Table: IC_PHYS_CNT

Description: Physical inventory and cycle counts
Primary Key: IC_PHYS_CNT_PK
  1. CYCLE_ID
  2. COUNT_NO
  3. ITEM_ID
  4. WHSE_CODE
  5. LOT_ID
  6. LOCATION
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_PHYS_CNT.GRADE_CODE GMD_GRADES_B
IC_PHYS_CNT.TEXT_CODE IC_TEXT_HDR
IC_PHYS_CNT.GRADE_CODE QC_GRAD_MST
IC_PHYS_CNT.REASON_CODE SY_REAS_CDS_B
IC_PHYS_CNT.REASON_CODE SY_REAS_CDS

[top of page]

GMI.IC_PHYS_CNT does not reference any database object

GMI.IC_PHYS_CNT is referenced by following:

APPS
SYNONYM - IC_PHYS_CNT

[top of page]

Table: IC_PHYS_ERR

Description: Physical Inventory Posting Error Table.
Primary Key: IC_PHYS_ERR_PK
  1. CYCLE_ID
  2. ITEM_ID
  3. WHSE_CODE
  4. LOT_ID
  5. LOCATION

[top of page]

GMI.IC_PHYS_ERR does not reference any database object

GMI.IC_PHYS_ERR is referenced by following:

APPS
SYNONYM - IC_PHYS_ERR

[top of page]

Table: IC_PKGS_MST

Description: *NOT USED*
Primary Key: IC_PKGS_MST_PK
  1. PKG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_PKGS_MST.TEXT_CODE IC_TEXT_HDR
IC_PKGS_MST.FILL_UM SY_UOMS_MST
IC_PKGS_MST.TARE_UM SY_UOMS_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_ITEM_MST_B.PKG_ID IC_PKGS_MST
IC_ITEM_MST.PKG_ID IC_PKGS_MST

[top of page]

GMI.IC_PKGS_MST does not reference any database object

GMI.IC_PKGS_MST is referenced by following:

APPS
SYNONYM - IC_PKGS_MST

[top of page]

Table: IC_PLNT_INV

Description: Production rules, by item and plant. These rules are used by MRP and supply defaults for Production Batch creation.
Primary Key: IC_PLNT_INV_PK
  1. PLNTINV_ID
Primary Key: IC_PLNT_INV_U1
  1. ITEM_ID
  2. ORGN_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_PLNT_INV.ITEM_ID IC_ITEM_MST_B
IC_PLNT_INV.ITEM_ID IC_ITEM_MST
IC_PLNT_INV.TEXT_CODE IC_TEXT_HDR
IC_PLNT_INV.ORGN_CODE SY_ORGN_MST_B
IC_PLNT_INV.ORGN_CODE SY_ORGN_MST

[top of page]

GMI.IC_PLNT_INV does not reference any database object

GMI.IC_PLNT_INV is referenced by following:

APPS
SYNONYM - IC_PLNT_INV

[top of page]

Table: IC_PURG_PRM

Description: Inventory purge parameters
Primary Key: IC_PURG_PRM_PK
  1. CRITERIA_NO
  2. VERSION_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_PURG_PRM.INV_CLASS IC_INVN_CLS

[top of page]

GMI.IC_PURG_PRM does not reference any database object

GMI.IC_PURG_PRM is referenced by following:

APPS
SYNONYM - IC_PURG_PRM

[top of page]

Table: IC_RANK_MST

Description: Inventory rank master. This table defines rank information for use in determining the cycle count schedule.
Primary Key: IC_RANK_MST_PK
  1. WHSE_CODE
  2. ABC_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_RANK_MST.TEXT_CODE IC_TEXT_HDR
IC_RANK_MST.WHSE_CODE IC_WHSE_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_WHSE_INV.WHSE_CODE
IC_WHSE_INV.WHSE_ABCCODE 		IC_RANK_MST

[top of page]

GMI.IC_RANK_MST does not reference any database object

GMI.IC_RANK_MST is referenced by following:

APPS
SYNONYM - IC_RANK_MST

[top of page]

Table: IC_STAT_RPT

Description: Intrastat reporting table.
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_STAT_RPT.ITEM_ID IC_ITEM_MST_B
IC_STAT_RPT.ITEM_ID IC_ITEM_MST
IC_STAT_RPT.ITEM_ID
IC_STAT_RPT.LOT_ID 		IC_LOTS_MST
IC_STAT_RPT.TRANS_ID IC_TRAN_CMP
IC_STAT_RPT.TRANS_ID IC_TRAN_PND

[top of page]

GMI.IC_STAT_RPT does not reference any database object

GMI.IC_STAT_RPT is referenced by following:

APPS
SYNONYM - IC_STAT_RPT

[top of page]

Table: IC_TAXN_ASC

Description: Item tax class association. This table associates items to item tax classes.
Primary Key: IC_TAXN_ASC_PK
  1. ICTAX_CLASS
  2. ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_TAXN_ASC.ITEM_ID IC_ITEM_MST_B
IC_TAXN_ASC.ITEM_ID IC_ITEM_MST
IC_TAXN_ASC.ICTAX_CLASS IC_TAXN_CLS
IC_TAXN_ASC.TEXT_CODE IC_TEXT_HDR

[top of page]

GMI.IC_TAXN_ASC does not reference any database object

GMI.IC_TAXN_ASC is referenced by following:

APPS
SYNONYM - IC_TAXN_ASC

[top of page]

Table: IC_TEXT_HDR

Description: Master table for creation and storage of text codes associated with GMI tables.
Primary Key: IC_TEXT_HDR_PK
  1. TEXT_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_ALLC_CLS.TEXT_CODE IC_TEXT_HDR
IC_ALOT_PRM.TEXT_CODE IC_TEXT_HDR
IC_CLDR_DTL.TEXT_CODE IC_TEXT_HDR
IC_CLDR_HDR_B.TEXT_CODE IC_TEXT_HDR
IC_CLDR_HDR.TEXT_CODE IC_TEXT_HDR
IC_COMD_CDS.TEXT_CODE IC_TEXT_HDR
IC_COST_CLS.TEXT_CODE IC_TEXT_HDR
IC_CRUL_CLS.TEXT_CODE IC_TEXT_HDR
IC_CTMS_CLS.TEXT_CODE IC_TEXT_HDR
IC_CYCL_HDR.TEXT_CODE IC_TEXT_HDR
IC_CYCL_MSC.TEXT_CODE IC_TEXT_HDR
IC_FRGT_CLS.TEXT_CODE IC_TEXT_HDR
IC_GLED_CLS.TEXT_CODE IC_TEXT_HDR
IC_INVN_CLS.TEXT_CODE IC_TEXT_HDR
IC_INVN_TYP.TEXT_CODE IC_TEXT_HDR
IC_ITEM_CDT.TEXT_CODE IC_TEXT_HDR
IC_ITEM_CNV.TEXT_CODE IC_TEXT_HDR
IC_ITEM_MST_B.TEXT_CODE IC_TEXT_HDR
IC_ITEM_MST.TEXT_CODE IC_TEXT_HDR
IC_JRNL_MST.TEXT_CODE IC_TEXT_HDR
IC_LOCT_INV.TEXT_CODE IC_TEXT_HDR
IC_LOCT_MST.TEXT_CODE IC_TEXT_HDR
IC_LOTS_MST.TEXT_CODE IC_TEXT_HDR
IC_LOTS_STS.TEXT_CODE IC_TEXT_HDR
IC_PHYS_CNT.TEXT_CODE IC_TEXT_HDR
IC_PKGS_MST.TEXT_CODE IC_TEXT_HDR
IC_PLNT_INV.TEXT_CODE IC_TEXT_HDR
IC_PRCE_CLS.TEXT_CODE IC_TEXT_HDR
IC_PRCH_CLS.TEXT_CODE IC_TEXT_HDR
IC_RANK_MST.TEXT_CODE IC_TEXT_HDR
IC_SALE_CLS.TEXT_CODE IC_TEXT_HDR
IC_SHIP_CLS.TEXT_CODE IC_TEXT_HDR
IC_STOR_CLS.TEXT_CODE IC_TEXT_HDR
IC_TAXN_ASC.TEXT_CODE IC_TEXT_HDR
IC_TAXN_CLS.TEXT_CODE IC_TEXT_HDR
IC_TRAN_ARC.TEXT_CODE IC_TEXT_HDR
IC_TRAN_CMP.TEXT_CODE IC_TEXT_HDR
IC_TRAN_PND.TEXT_CODE IC_TEXT_HDR
IC_WHSE_INV.TEXT_CODE IC_TEXT_HDR
IC_WHSE_MST.TEXT_CODE IC_TEXT_HDR
IC_WHSE_REL.TEXT_CODE IC_TEXT_HDR
IC_XFER_MST.TEXT_CODE IC_TEXT_HDR
PS_PLNG_CLS.TEXT_CODE IC_TEXT_HDR

[top of page]

GMI.IC_TEXT_HDR does not reference any database object

GMI.IC_TEXT_HDR is referenced by following:

APPS
SYNONYM - IC_TEXT_HDR

[top of page]

Table: IC_TEXT_TBL_TL

Description: IC Module Text Lines. Descriptive text for all tables in this module.
Primary Key: IC_TEXT_TBL_TL_PK
  1. TEXT_CODE
  2. LANG_CODE
  3. PARAGRAPH_CODE
  4. SUB_PARACODE
  5. LINE_NO
  6. LANGUAGE

[top of page]

GMI.IC_TEXT_TBL_TL does not reference any database object

GMI.IC_TEXT_TBL_TL is referenced by following:

APPS
SYNONYM - IC_TEXT_TBL_TL

[top of page]

Table: IC_TRAN_ARC

Description: Inventory transaction archive
Primary Key: IC_TRAN_ARC_PK
  1. TRANS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_TRAN_ARC.QC_GRADE GMD_GRADES_B
IC_TRAN_ARC.ITEM_ID IC_ITEM_MST_B
IC_TRAN_ARC.ITEM_ID IC_ITEM_MST
IC_TRAN_ARC.WHSE_CODE
IC_TRAN_ARC.LOCATION 		IC_LOCT_MST
IC_TRAN_ARC.ITEM_ID
IC_TRAN_ARC.LOT_ID 		IC_LOTS_MST
IC_TRAN_ARC.LOT_STATUS IC_LOTS_STS
IC_TRAN_ARC.TEXT_CODE IC_TEXT_HDR
IC_TRAN_ARC.WHSE_CODE IC_WHSE_MST
IC_TRAN_ARC.QC_GRADE QC_GRAD_MST
IC_TRAN_ARC.DOC_TYPE SY_DOCS_MST
IC_TRAN_ARC.ORGN_CODE SY_ORGN_MST_B
IC_TRAN_ARC.CO_CODE SY_ORGN_MST_B
IC_TRAN_ARC.ORGN_CODE SY_ORGN_MST
IC_TRAN_ARC.CO_CODE SY_ORGN_MST
IC_TRAN_ARC.REASON_CODE SY_REAS_CDS_B
IC_TRAN_ARC.REASON_CODE SY_REAS_CDS
IC_TRAN_ARC.TRANS_UM SY_UOMS_MST
IC_TRAN_ARC.TRANS_UM2 SY_UOMS_MST

[top of page]

GMI.IC_TRAN_ARC does not reference any database object

GMI.IC_TRAN_ARC is referenced by following:

APPS
SYNONYM - IC_TRAN_ARC

[top of page]

Table: IC_TRAN_CMP

Description: Completed inventory transactions
Primary Key: IC_TRAN_CMP_PK
  1. TRANS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_TRAN_CMP.QC_GRADE GMD_GRADES_B
IC_TRAN_CMP.ITEM_ID IC_ITEM_MST_B
IC_TRAN_CMP.ITEM_ID IC_ITEM_MST
IC_TRAN_CMP.ITEM_ID
IC_TRAN_CMP.LOT_ID 		IC_LOTS_MST
IC_TRAN_CMP.LOT_STATUS IC_LOTS_STS
IC_TRAN_CMP.TEXT_CODE IC_TEXT_HDR
IC_TRAN_CMP.WHSE_CODE IC_WHSE_MST
IC_TRAN_CMP.QC_GRADE QC_GRAD_MST
IC_TRAN_CMP.DOC_TYPE SY_DOCS_MST
IC_TRAN_CMP.ORGN_CODE SY_ORGN_MST_B
IC_TRAN_CMP.CO_CODE SY_ORGN_MST_B
IC_TRAN_CMP.ORGN_CODE SY_ORGN_MST
IC_TRAN_CMP.CO_CODE SY_ORGN_MST
IC_TRAN_CMP.REASON_CODE SY_REAS_CDS_B
IC_TRAN_CMP.REASON_CODE SY_REAS_CDS
IC_TRAN_CMP.TRANS_UM SY_UOMS_MST
IC_TRAN_CMP.TRANS_UM2 SY_UOMS_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_STAT_RPT.TRANS_ID IC_TRAN_CMP

[top of page]

GMI.IC_TRAN_CMP does not reference any database object

GMI.IC_TRAN_CMP is referenced by following:

APPS
SYNONYM - IC_TRAN_CMP

[top of page]

Table: IC_TRAN_PND

Description: Pending inventory transactions
Primary Key: IC_TRAN_PND_PK
  1. TRANS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_TRAN_PND.QC_GRADE GMD_GRADES_B
IC_TRAN_PND.ITEM_ID IC_ITEM_MST_B
IC_TRAN_PND.ITEM_ID IC_ITEM_MST
IC_TRAN_PND.ITEM_ID
IC_TRAN_PND.LOT_ID 		IC_LOTS_MST
IC_TRAN_PND.LOT_STATUS IC_LOTS_STS
IC_TRAN_PND.TEXT_CODE IC_TEXT_HDR
IC_TRAN_PND.WHSE_CODE IC_WHSE_MST
IC_TRAN_PND.QC_GRADE QC_GRAD_MST
IC_TRAN_PND.DOC_TYPE SY_DOCS_MST
IC_TRAN_PND.ORGN_CODE SY_ORGN_MST_B
IC_TRAN_PND.CO_CODE SY_ORGN_MST_B
IC_TRAN_PND.ORGN_CODE SY_ORGN_MST
IC_TRAN_PND.CO_CODE SY_ORGN_MST
IC_TRAN_PND.REASON_CODE SY_REAS_CDS_B
IC_TRAN_PND.REASON_CODE SY_REAS_CDS
IC_TRAN_PND.TRANS_UM2 SY_UOMS_MST
IC_TRAN_PND.TRANS_UM SY_UOMS_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_STAT_RPT.TRANS_ID IC_TRAN_PND

[top of page]

GMI.IC_TRAN_PND does not reference any database object

GMI.IC_TRAN_PND is referenced by following:

APPS
SYNONYM - IC_TRAN_PND

[top of page]

Table: IC_TXN_REQUEST_HEADERS

Description: Move Order Headers
Primary Key: IC_TXN_REQUEST_HEADERS_PK
  1. HEADER_ID
Primary Key: IC_TXN_REQUEST_HEADERS_U1
  1. REQUEST_NUMBER
  2. ORGANIZATION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_TXN_REQUEST_LINES.HEADER_ID IC_TXN_REQUEST_HEADERS

[top of page]

GMI.IC_TXN_REQUEST_HEADERS does not reference any database object

GMI.IC_TXN_REQUEST_HEADERS is referenced by following:

APPS
SYNONYM - IC_TXN_REQUEST_HEADERS

[top of page]

Table: IC_TXN_REQUEST_LINES

Description: Move order lines
Primary Key: IC_TXN_REQUEST_LINES_PK
  1. LINE_ID
Primary Key: IC_TXN_REQUEST_LINES_U1
  1. HEADER_ID
  2. LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_TXN_REQUEST_LINES.HEADER_ID IC_TXN_REQUEST_HEADERS

[top of page]

GMI.IC_TXN_REQUEST_LINES does not reference any database object

GMI.IC_TXN_REQUEST_LINES is referenced by following:

APPS
SYNONYM - IC_TXN_REQUEST_LINES

[top of page]

Table: IC_WHSE_INV

Description: Warehouse rules
Primary Key: IC_WHSE_INV_PK
  1. WHSEINV_ID
Primary Key: IC_WHSE_INV_U1
  1. ITEM_ID
  2. WHSE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_WHSE_INV.COUNT_CLASS IC_CRUL_CLS
IC_WHSE_INV.FRT_CLASS IC_FRGT_CLS
IC_WHSE_INV.GL_CLASS IC_GLED_CLS
IC_WHSE_INV.ITEM_ID IC_ITEM_MST_B
IC_WHSE_INV.ITEM_ID IC_ITEM_MST
IC_WHSE_INV.WHSE_CODE
IC_WHSE_INV.WHSE_ABCCODE 		IC_RANK_MST
IC_WHSE_INV.SHIP_CLASS IC_SHIP_CLS
IC_WHSE_INV.TEXT_CODE IC_TEXT_HDR
IC_WHSE_INV.WHSE_CODE IC_WHSE_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_ITEM_CDT.ITEM_ID
IC_ITEM_CDT.WHSE_CODE 		IC_WHSE_INV

[top of page]

GMI.IC_WHSE_INV does not reference any database object

GMI.IC_WHSE_INV is referenced by following:

APPS
SYNONYM - IC_WHSE_INV

[top of page]

Table: IC_WHSE_MST

Description: Warehouse master.This table contains warehouse definition information.
Primary Key: IC_WHSE_MST_PK
  1. WHSE_CODE
Primary Key: IC_WHSE_MST_U1
  1. MTL_ORGANIZATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_WHSE_MST.TEXT_CODE IC_TEXT_HDR
IC_WHSE_MST.ADDR_ID SY_ADDR_MST
IC_WHSE_MST.ORGN_CODE SY_ORGN_MST_B
IC_WHSE_MST.ORGN_CODE SY_ORGN_MST
IC_WHSE_MST.TAXLOC_CODE TX_TLOC_CDS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CM_ACST_LED.WHSE_CODE IC_WHSE_MST
CM_ADJS_DTL.WHSE_CODE IC_WHSE_MST
CM_BRDN_DTL.WHSE_CODE IC_WHSE_MST
CM_CMPT_DTL.WHSE_CODE IC_WHSE_MST
CM_SCST_LED.WHSE_CODE IC_WHSE_MST
CM_WHSE_ASC.COST_WHSE_CODE IC_WHSE_MST
CM_WHSE_ASC.WHSE_CODE IC_WHSE_MST
CM_WHSE_EFF.COSTING_WHSE IC_WHSE_MST
CM_WHSE_SRC.WHSE_CODE IC_WHSE_MST
FC_FCST_DTL.WHSE_CODE IC_WHSE_MST
GL_ACCT_MAP.WHSE_CODE IC_WHSE_MST
GL_ACCU_MAP.WHSE_CODE IC_WHSE_MST
GL_ALOC_BAS.WHSE_CODE IC_WHSE_MST
GL_ITEM_CST.WHSE_CODE IC_WHSE_MST
GMF_BURDEN_PERCENTAGES.WHSE_CODE IC_WHSE_MST
GMP_FORM_EFF.WHSE_CODE IC_WHSE_MST
GMP_ITEM_APS.WHSE_CODE IC_WHSE_MST
GMP_ITEM_WPS.WHSE_CODE IC_WHSE_MST
IC_ADJS_JNL.WHSE_CODE IC_WHSE_MST
IC_ALOT_PRM.WHSE_CODE IC_WHSE_MST
IC_CYCL_HDR.WHSE_CODE IC_WHSE_MST
IC_ITEM_WHS.WHSE_CODE IC_WHSE_MST
IC_LOCT_INV.WHSE_CODE IC_WHSE_MST
IC_LOCT_MST.WHSE_CODE IC_WHSE_MST
IC_RANK_MST.WHSE_CODE IC_WHSE_MST
IC_SUMM_INV.WHSE_CODE IC_WHSE_MST
IC_TRAN_ARC.WHSE_CODE IC_WHSE_MST
IC_TRAN_CMP.WHSE_CODE IC_WHSE_MST
IC_TRAN_PND.WHSE_CODE IC_WHSE_MST
IC_WHSE_INV.WHSE_CODE IC_WHSE_MST
IC_WHSE_REL.SOURCE_WHSE IC_WHSE_MST
IC_WHSE_REL.DEST_WHSE IC_WHSE_MST
IC_WHSE_STS.WHSE_CODE IC_WHSE_MST
IC_XFER_MST.FROM_WAREHOUSE IC_WHSE_MST
IC_XFER_MST.TO_WAREHOUSE IC_WHSE_MST
MR_ACTN_TBL.WHSE_CODE IC_WHSE_MST
MR_ACTN_TBL.WHSE_CODE_2 IC_WHSE_MST
MR_MESG_TBL.WHSE_CODE1 IC_WHSE_MST
MR_MESG_TBL.WHSE_CODE2 IC_WHSE_MST
MR_TRAN_TBL.WHSE_CODE IC_WHSE_MST
OP_CUST_ITM.WHSE_CODE IC_WHSE_MST
OP_CUST_MST_OPM.FROM_WHSE IC_WHSE_MST
OP_CUST_MST_OPM.TO_WHSE IC_WHSE_MST
OP_CUST_MST.FROM_WHSE IC_WHSE_MST
OP_CUST_MST.TO_WHSE IC_WHSE_MST
OP_CUST_SHP.WHSE_CODE IC_WHSE_MST
OP_ORDR_DTL.TO_WHSE IC_WHSE_MST
OP_ORDR_DTL.FROM_WHSE IC_WHSE_MST
OP_ORDR_HDR.FROM_WHSE IC_WHSE_MST
OP_ORDR_HDR.TO_WHSE IC_WHSE_MST
OP_PRCE_ITM.WHSE_CODE IC_WHSE_MST
OP_PRSL_DTL.FROM_WHSE IC_WHSE_MST
OP_PRSL_HDR.FROM_WHSE IC_WHSE_MST
OP_PRSL_HDR.TO_WHSE IC_WHSE_MST
OP_RELS_SCH.TO_WHSE IC_WHSE_MST
OP_RELS_SCH.FROM_WHSE IC_WHSE_MST
PM_BTCH_HDR.WIP_WHSE_CODE IC_WHSE_MST
PM_HIST_HDR.ORIG_WIP_WHSE IC_WHSE_MST
PM_HIST_HDR.NEW_WIP_WHSE IC_WHSE_MST
PO_BPOS_DTL.FROM_WHSE IC_WHSE_MST
PO_BPOS_DTL.TO_WHSE IC_WHSE_MST
PO_ORDR_DTL.FROM_WHSE IC_WHSE_MST
PO_ORDR_DTL.TO_WHSE IC_WHSE_MST
PO_ORDR_HDR.FROM_WHSE IC_WHSE_MST
PO_ORDR_HDR.TO_WHSE IC_WHSE_MST
PO_RECV_DTL.TO_WHSE IC_WHSE_MST
PO_RECV_DTL.FROM_WHSE IC_WHSE_MST
PO_RECV_HDR.TO_WHSE IC_WHSE_MST
PO_RECV_HST.TO_WHSE IC_WHSE_MST
PO_RELS_SCH.FROM_WHSE IC_WHSE_MST
PO_RELS_SCH.TO_WHSE IC_WHSE_MST
PO_VNIT_MST.WHSE_CODE IC_WHSE_MST
PS_WHSE_EFF.WHSE_CODE IC_WHSE_MST
QC_RSLT_MST.WHSE_CODE IC_WHSE_MST
QC_SMPL_MST.WHSE_CODE IC_WHSE_MST
QC_SPEC_MST.WHSE_CODE IC_WHSE_MST

[top of page]

GMI.IC_WHSE_MST does not reference any database object

GMI.IC_WHSE_MST is referenced by following:

APPS
SYNONYM - IC_WHSE_MST

[top of page]

Table: IC_WHSE_REL

Description: Warehouse transfer rules table. This table contains information on transfers between warehouses, it is used by MRP.
Primary Key: IC_WHSE_REL_PK
  1. WHSEREL_ID
Primary Key: IC_WHSE_REL_U1
  1. SOURCE_WHSE
  2. DEST_WHSE
  3. ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_WHSE_REL.ITEM_ID IC_ITEM_MST_B
IC_WHSE_REL.ITEM_ID IC_ITEM_MST
IC_WHSE_REL.TEXT_CODE IC_TEXT_HDR
IC_WHSE_REL.SOURCE_WHSE IC_WHSE_MST
IC_WHSE_REL.DEST_WHSE IC_WHSE_MST

[top of page]

GMI.IC_WHSE_REL does not reference any database object

GMI.IC_WHSE_REL is referenced by following:

APPS
SYNONYM - IC_WHSE_REL

[top of page]

Table: IC_WHSE_STS

Description: Warehouse close status
Primary Key: IC_WHSE_STS_PK
  1. PERIOD_ID
  2. WHSE_CODE
Primary Key: IC_WHSE_STS_U1
  1. FISCAL_YEAR
  2. PERIOD
  3. WHSE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_WHSE_STS.PERIOD_ID IC_CLDR_DTL
IC_WHSE_STS.WHSE_CODE IC_WHSE_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_PERD_BAL.PERIOD_ID
IC_PERD_BAL.WHSE_CODE 		IC_WHSE_STS

[top of page]

GMI.IC_WHSE_STS does not reference any database object

GMI.IC_WHSE_STS is referenced by following:

APPS
SYNONYM - IC_WHSE_STS

[top of page]

Table: IC_XFER_MST

Description: Inventory transfer master
Primary Key: IC_XFER_MST_I1
  1. TRANSFER_BATCH
  2. ORGN_CODE
  3. TRANSFER_NO
Primary Key: IC_XFER_MST_PK
  1. TRANSFER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IC_XFER_MST.ITEM_ID IC_ITEM_MST_B
IC_XFER_MST.ITEM_ID IC_ITEM_MST
IC_XFER_MST.ITEM_ID
IC_XFER_MST.LOT_ID 		IC_LOTS_MST
IC_XFER_MST.LOT_STATUS IC_LOTS_STS
IC_XFER_MST.TEXT_CODE IC_TEXT_HDR
IC_XFER_MST.FROM_WAREHOUSE IC_WHSE_MST
IC_XFER_MST.TO_WAREHOUSE IC_WHSE_MST
IC_XFER_MST.ORGN_CODE SY_ORGN_MST_B
IC_XFER_MST.ORGN_CODE SY_ORGN_MST
IC_XFER_MST.RELEASE_REASON_CODE SY_REAS_CDS_B
IC_XFER_MST.RECEIVE_REASON_CODE SY_REAS_CDS_B
IC_XFER_MST.CANCEL_REASON_CODE SY_REAS_CDS_B
IC_XFER_MST.RELEASE_REASON_CODE SY_REAS_CDS
IC_XFER_MST.RECEIVE_REASON_CODE SY_REAS_CDS
IC_XFER_MST.CANCEL_REASON_CODE SY_REAS_CDS
IC_XFER_MST.RELEASE_UOM1 SY_UOMS_MST
IC_XFER_MST.RELEASE_UOM2 SY_UOMS_MST

[top of page]

GMI.IC_XFER_MST does not reference any database object

GMI.IC_XFER_MST is referenced by following:

APPS
SYNONYM - IC_XFER_MST

[top of page]

Table: IN_ADDR_MST

Description: EC Address Supplemental Details. Intrastat details relevant to ship-to address.
Primary Key: IN_ADDR_MST_PK
  1. ADDR_ID

[top of page]

GMI.IN_ADDR_MST does not reference any database object

GMI.IN_ADDR_MST is referenced by following:

APPS
SYNONYM - IN_ADDR_MST

[top of page]

Table: IN_CTRY_MST

Description: Country Codes. Intrastat specific country codes.
Primary Key: IN_CTRY_MST_PK
  1. EC_COUNTRY_CODE

[top of page]

GMI.IN_CTRY_MST does not reference any database object

GMI.IN_CTRY_MST is referenced by following:

APPS
SYNONYM - IN_CTRY_MST

[top of page]

Table: IN_ITEM_MST

Description: EC Item Supplemental Details. Item related Intrastat details.
Primary Key: IN_ITEM_MST_PK
  1. ITEM_ID

[top of page]

GMI.IN_ITEM_MST does not reference any database object

GMI.IN_ITEM_MST is referenced by following:

APPS
SYNONYM - IN_ITEM_MST

[top of page]

Table: IN_REGN_MST

Description: EC Regions Code. Intrastat region codes.
Primary Key: IN_REGN_MST_PK
  1. EC_REGION_CODE

[top of page]

GMI.IN_REGN_MST does not reference any database object

GMI.IN_REGN_MST is referenced by following:

APPS
SYNONYM - IN_REGN_MST

[top of page]

Table: IN_STAT_CTL

Description: EC Statistics Control Table. Intrastat build run status by company code.
Primary Key: IN_STAT_CTL_PK
  1. CO_CODE

[top of page]

GMI.IN_STAT_CTL does not reference any database object

GMI.IN_STAT_CTL is referenced by following:

APPS
SYNONYM - IN_STAT_CTL

[top of page]

Table: IN_STAT_DTL

Description: EC Statistics Detail. Intrastat statistics detail file.
Primary Key: IN_STAT_DTL_PK
  1. STAT_ID
  2. STATLINE_ID

[top of page]

GMI.IN_STAT_DTL does not reference any database object

GMI.IN_STAT_DTL is referenced by following:

APPS
SYNONYM - IN_STAT_DTL

[top of page]

Table: IN_STAT_HDR

Description: EC Statistics Header. Intrastat statistics header file.
Primary Key: IN_STAT_HDR_PK
  1. DOC_TYPE
  2. DOC_ID
  3. ARRIVAL_DISPATCH_IND

[top of page]

GMI.IN_STAT_HDR does not reference any database object

GMI.IN_STAT_HDR is referenced by following:

APPS
SYNONYM - IN_STAT_HDR

[top of page]

Table: IN_STAT_MSG

Description: EC Statistics message table. Intrastat build error messages by company code.
Primary Key: IN_STAT_MSG_PK
  1. CO_CODE
  2. LINE_NO

[top of page]

GMI.IN_STAT_MSG does not reference any database object

GMI.IN_STAT_MSG is referenced by following:

APPS
SYNONYM - IN_STAT_MSG

[top of page]

Table: IN_TEXT_HDR

Description: Intrastat Text Header Table.
Primary Key: IN_TEXT_HDR_PK
  1. TEXT_CODE

[top of page]

GMI.IN_TEXT_HDR does not reference any database object

GMI.IN_TEXT_HDR is referenced by following:

APPS
SYNONYM - IN_TEXT_HDR

[top of page]

Table: IN_TEXT_TBL_TL

Description: IN Module Text Lines. Descriptive text for all tables in this module.
Primary Key: IN_TEXT_TBL_TL_PK
  1. TEXT_CODE
  2. LANG_CODE
  3. PARAGRAPH_CODE
  4. SUB_PARACODE
  5. LINE_NO
  6. LANGUAGE

[top of page]

GMI.IN_TEXT_TBL_TL does not reference any database object

GMI.IN_TEXT_TBL_TL is referenced by following:

APPS
SYNONYM - IN_TEXT_TBL_TL

[top of page]

Table: IN_TOFD_MST

Description: EC Terms of Delivery Table. Intrastat specific terms of delivery codes.
Primary Key: IN_TOFD_MST_PK
  1. EC_DELIVERY_CODE

[top of page]

GMI.IN_TOFD_MST does not reference any database object

GMI.IN_TOFD_MST is referenced by following:

APPS
SYNONYM - IN_TOFD_MST

[top of page]

Table: SY_WF_ITEM_ROLES

Description: Table used to relate Item ID with Roles. If the Item ID is NULL, then Roles will be associated with the warehouse Item ID. This table will be used by the Lot Expiry/Retest Workflow.
Primary Key: SY_WF_ITEM_ROLES_UK
  1. ITEM_ID
  2. WHSE_ITEM_ID

[top of page]

GMI.SY_WF_ITEM_ROLES does not reference any database object

GMI.SY_WF_ITEM_ROLES is referenced by following:

APPS
SYNONYM - SY_WF_ITEM_ROLES

[top of page]

View: GL_BUSINESS_CLS_VW

[top of page]

APPS.GL_BUSINESS_CLS_VW references the following:

APPS
SYNONYM - GMI_CATEGORY_SETS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
APPS.GL_BUSINESS_CLS_VW is referenced by following:

APPS
PACKAGE BODY - GMIVITM

[top of page]

View: GL_PROD_LINE_VW

[top of page]

APPS.GL_PROD_LINE_VW references the following:

APPS
SYNONYM - GMI_CATEGORY_SETS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
APPS.GL_PROD_LINE_VW is referenced by following:

APPS
PACKAGE BODY - GMIVITM

[top of page]

View: GMI_AAC_CUST_NUM_V

[top of page]

APPS.GMI_AAC_CUST_NUM_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - IC_WHSE_MST
SYNONYM - OP_CUST_MST
SYNONYM - SY_ORGN_MST

APPS.GMI_AAC_CUST_NUM_V is not referenced by any database object

[top of page]

View: GMI_AAC_ORDER_NUM_V

[top of page]

APPS.GMI_AAC_ORDER_NUM_V references the following:

APPS
SYNONYM - IC_TXN_REQUEST_LINES
SYNONYM - IC_WHSE_MST
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
SYNONYM - WSH_DELIVERY_DETAILS

APPS.GMI_AAC_ORDER_NUM_V is not referenced by any database object

[top of page]

View: GMI_ITEM_CATEGORIES_V1

[top of page]

APPS.GMI_ITEM_CATEGORIES_V1 references the following:

APPS
SYNONYM - GMI_ITEM_CATEGORIES
VIEW - MTL_CATEGORY_SETS_VL

APPS.GMI_ITEM_CATEGORIES_V1 is not referenced by any database object

[top of page]

View: GMI_ITEM_ORGANIZATIONS_V1

[top of page]

APPS.GMI_ITEM_ORGANIZATIONS_V1 references the following:

APPS
SYNONYM - GMI_ITEM_ORGANIZATIONS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
VIEW - ORG_ORGANIZATION_DEFINITIONS

APPS.GMI_ITEM_ORGANIZATIONS_V1 is not referenced by any database object

[top of page]

View: GMI_LOTS_BOM_V

[top of page]

APPS.GMI_LOTS_BOM_V references the following:

APPS
SYNONYM - IC_TRAN_CMP
SYNONYM - IC_TRAN_PND
APPS.GMI_LOTS_BOM_V is referenced by following:

APPS
VIEW - GMI_LOTS_DEST_BOM_V
VIEW - GMI_LOTS_SOURCE_BOM_V

[top of page]

View: GMI_LOTS_COMP_V

[top of page]

APPS.GMI_LOTS_COMP_V references the following:

APPS
SYNONYM - FM_FORM_MST
SYNONYM - IC_ITEM_MST
SYNONYM - IC_LOTS_MST
SYNONYM - IC_TRAN_CMP
SYNONYM - IC_TRAN_PND
SYNONYM - PM_BTCH_HDR
APPS.GMI_LOTS_COMP_V is referenced by following:

APPS
PACKAGE BODY - GMI_GMILTGEN_XMLP_PKG

[top of page]

View: GMI_LOTS_DEST_BOM_V

[top of page]

APPS.GMI_LOTS_DEST_BOM_V references the following:

APPS
VIEW - GMI_LOTS_BOM_V
PACKAGE - GMI_LOT_TRACE_PKG

APPS.GMI_LOTS_DEST_BOM_V is not referenced by any database object

[top of page]

View: GMI_LOTS_DEST_LIST_V

[top of page]

APPS.GMI_LOTS_DEST_LIST_V references the following:

APPS
VIEW - GMI_LOTS_LIST_V
PACKAGE - GMI_LOT_TRACE_PKG

APPS.GMI_LOTS_DEST_LIST_V is not referenced by any database object

[top of page]

View: GMI_LOTS_DEST_V

[top of page]

APPS.GMI_LOTS_DEST_V references the following:

APPS
SYNONYM - FM_FORM_MST
SYNONYM - IC_ITEM_MST
SYNONYM - IC_LOTS_MST
SYNONYM - IC_TRAN_CMP
SYNONYM - IC_TRAN_PND
SYNONYM - PM_BTCH_HDR
APPS.GMI_LOTS_DEST_V is referenced by following:

APPS
PACKAGE BODY - GMI_GMILTGEN_XMLP_PKG

[top of page]

View: GMI_LOTS_EVENT_V

[top of page]

APPS.GMI_LOTS_EVENT_V references the following:

APPS
SYNONYM - IC_ITEM_MST
SYNONYM - IC_LOTS_MST
VIEW - IC_TRAN_VW1

APPS.GMI_LOTS_EVENT_V is not referenced by any database object

[top of page]

View: GMI_LOTS_LIST_V

[top of page]

APPS.GMI_LOTS_LIST_V references the following:

APPS
SYNONYM - IC_ITEM_MST
SYNONYM - IC_LOTS_MST
SYNONYM - IC_TRAN_CMP
SYNONYM - IC_TRAN_PND
SYNONYM - PO_RECV_DTL
SYNONYM - PO_VEND_MST
APPS.GMI_LOTS_LIST_V is referenced by following:

APPS
VIEW - GMI_LOTS_DEST_LIST_V
VIEW - GMI_LOTS_SOURCE_LIST_V

[top of page]

View: GMI_LOTS_SOURCE_BOM_V

[top of page]

APPS.GMI_LOTS_SOURCE_BOM_V references the following:

APPS
VIEW - GMI_LOTS_BOM_V
PACKAGE - GMI_LOT_TRACE_PKG

APPS.GMI_LOTS_SOURCE_BOM_V is not referenced by any database object

[top of page]

View: GMI_LOTS_SOURCE_LIST_V

[top of page]

APPS.GMI_LOTS_SOURCE_LIST_V references the following:

APPS
VIEW - GMI_LOTS_LIST_V
PACKAGE - GMI_LOT_TRACE_PKG

APPS.GMI_LOTS_SOURCE_LIST_V is not referenced by any database object

[top of page]

View: GMI_PICK_LOTS_V

[top of page]

APPS.GMI_PICK_LOTS_V references the following:

APPS
SYNONYM - GMI_TRAN_TMP
SYNONYM - IC_LOCT_INV
SYNONYM - IC_LOTS_STS

APPS.GMI_PICK_LOTS_V is not referenced by any database object

[top of page]

View: GMI_PICK_SLIP_NUMBER_V

[top of page]

APPS.GMI_PICK_SLIP_NUMBER_V references the following:

APPS
SYNONYM - IC_TRAN_PND

APPS.GMI_PICK_SLIP_NUMBER_V is not referenced by any database object

[top of page]

View: GMI_PICK_SLIP_VW

[top of page]

APPS.GMI_PICK_SLIP_VW references the following:

APPS
SYNONYM - IC_ITEM_MST
SYNONYM - IC_LOTS_MST
SYNONYM - IC_TRAN_PND
SYNONYM - IC_TXN_REQUEST_HEADERS
SYNONYM - IC_TXN_REQUEST_LINES
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WSH_DELIVERY_DETAILS

APPS.GMI_PICK_SLIP_VW is not referenced by any database object

[top of page]

View: GMI_WSH_PICK_SLIP_V

[top of page]

APPS.GMI_WSH_PICK_SLIP_V references the following:

APPS
SYNONYM - IC_ITEM_MST
SYNONYM - IC_ITEM_MST_B
SYNONYM - IC_LOTS_MST
SYNONYM - IC_TRAN_PND
SYNONYM - IC_TXN_REQUEST_HEADERS
SYNONYM - IC_TXN_REQUEST_LINES
SYNONYM - MTL_SYSTEM_ITEMS

APPS.GMI_WSH_PICK_SLIP_V is not referenced by any database object

[top of page]

View: GMI_XFER_MST_V

[top of page]

APPS.GMI_XFER_MST_V references the following:

APPS
SYNONYM - FND_USER
SYNONYM - IC_ITEM_MST
SYNONYM - IC_LOTS_MST
SYNONYM - IC_LOTS_STS
SYNONYM - IC_WHSE_MST
SYNONYM - IC_XFER_MST
SYNONYM - QC_GRAD_MST
SYNONYM - SY_REAS_CDS

APPS.GMI_XFER_MST_V is not referenced by any database object

[top of page]

View: IC_ADJS_JNL_VW

[top of page]

APPS.IC_ADJS_JNL_VW references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - GL_ACCT_MST
SYNONYM - GL_ACCU_MST
SYNONYM - GL_PLCY_MST
SYNONYM - IC_ADJS_JNL
SYNONYM - IC_ITEM_MST
SYNONYM - IC_JRNL_MST
SYNONYM - IC_LOCT_MST
SYNONYM - IC_LOTS_MST
SYNONYM - IC_LOTS_STS
SYNONYM - IC_WHSE_MST
SYNONYM - QC_GRAD_MST
SYNONYM - SY_DOCS_SEQ
SYNONYM - SY_ORGN_MST
SYNONYM - SY_REAS_CDS

APPS.IC_ADJS_JNL_VW is not referenced by any database object

[top of page]

View: IC_ALLC_CLS_VW

[top of page]

APPS.IC_ALLC_CLS_VW references the following:

APPS
SYNONYM - GMI_CATEGORY_SETS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
APPS.IC_ALLC_CLS_VW is referenced by following:

APPS
SYNONYM - IC_ALLC_CLS

[top of page]

View: IC_CLDR_HDR_VL

[top of page]

APPS.IC_CLDR_HDR_VL references the following:

APPS
SYNONYM - IC_CLDR_HDR_B
SYNONYM - IC_CLDR_HDR_TL
APPS.IC_CLDR_HDR_VL is referenced by following:

APPS
SYNONYM - IC_CLDR_HDR

[top of page]

View: IC_COST_CLS_VW

[top of page]

APPS.IC_COST_CLS_VW references the following:

APPS
SYNONYM - GMI_CATEGORY_SETS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
APPS.IC_COST_CLS_VW is referenced by following:

APPS
SYNONYM - IC_COST_CLS

[top of page]

View: IC_CTMS_CLS_VW

[top of page]

APPS.IC_CTMS_CLS_VW references the following:

APPS
SYNONYM - GMI_CATEGORY_SETS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
APPS.IC_CTMS_CLS_VW is referenced by following:

APPS
SYNONYM - IC_CTMS_CLS

[top of page]

View: IC_FRGT_CLS_VW

[top of page]

APPS.IC_FRGT_CLS_VW references the following:

APPS
SYNONYM - GMI_CATEGORY_SETS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
APPS.IC_FRGT_CLS_VW is referenced by following:

APPS
SYNONYM - IC_FRGT_CLS

[top of page]

View: IC_GLED_CLS_VW

[top of page]

APPS.IC_GLED_CLS_VW references the following:

APPS
SYNONYM - GMI_CATEGORY_SETS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
APPS.IC_GLED_CLS_VW is referenced by following:

APPS
SYNONYM - IC_GLED_CLS

[top of page]

View: IC_INVN_CLS_VW

[top of page]

APPS.IC_INVN_CLS_VW references the following:

APPS
SYNONYM - GMI_CATEGORY_SETS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
APPS.IC_INVN_CLS_VW is referenced by following:

APPS
SYNONYM - IC_INVN_CLS

[top of page]

View: IC_ITEM_HIERARCHY_V

[top of page]

APPS.IC_ITEM_HIERARCHY_V references the following:

APPS
SYNONYM - FND_USER
VIEW - GEM_LOOKUPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - IC_ITEM_HIERARCHY
VIEW - PER_ASSIGNMENTS_F

APPS.IC_ITEM_HIERARCHY_V is not referenced by any database object

[top of page]

View: IC_ITEM_INV_V

[top of page]

APPS.IC_ITEM_INV_V references the following:

APPS
SYNONYM - IC_ITEM_MST
SYNONYM - IC_LOCT_INV
SYNONYM - IC_LOTS_MST
SYNONYM - IC_LOTS_STS
SYNONYM - IC_TRAN_PND
APPS.IC_ITEM_INV_V is referenced by following:

APPS
PACKAGE BODY - GMI_MOVE_ORDER_LINE_UTIL

[top of page]

View: IC_ITEM_MST_VL

[top of page]

APPS.IC_ITEM_MST_VL references the following:

APPS
SYNONYM - IC_ITEM_MST_B
SYNONYM - IC_ITEM_MST_TL
APPS.IC_ITEM_MST_VL is referenced by following:

APPS
SYNONYM - IC_ITEM_MST
VIEW - PMITS_ITEM_MASTER_V

[top of page]

View: IC_LOCT_INV_RPTVW1

[top of page]

APPS.IC_LOCT_INV_RPTVW1 references the following:

APPS
SYNONYM - IC_ITEM_MST
SYNONYM - IC_LOCT_INV
SYNONYM - IC_LOTS_MST
SYNONYM - IC_WHSE_MST

APPS.IC_LOCT_INV_RPTVW1 is not referenced by any database object

[top of page]

View: IC_LOCT_INV_RPTVW2

[top of page]

APPS.IC_LOCT_INV_RPTVW2 references the following:

APPS
SYNONYM - IC_ITEM_MST
SYNONYM - IC_LOCT_INV

APPS.IC_LOCT_INV_RPTVW2 is not referenced by any database object

[top of page]

View: IC_LOCT_INV_RPTVW3

[top of page]

APPS.IC_LOCT_INV_RPTVW3 references the following:

APPS
SYNONYM - IC_ITEM_MST
SYNONYM - IC_LOCT_INV

APPS.IC_LOCT_INV_RPTVW3 is not referenced by any database object

[top of page]

View: IC_LOCT_INV_RPTVW4

[top of page]

APPS.IC_LOCT_INV_RPTVW4 references the following:

APPS
SYNONYM - IC_LOCT_INV

APPS.IC_LOCT_INV_RPTVW4 is not referenced by any database object

[top of page]

View: IC_LOCT_INV_UNALLOC

[top of page]

APPS.IC_LOCT_INV_UNALLOC references the following:

APPS
SYNONYM - IC_LOCT_INV
SYNONYM - IC_LOTS_MST
SYNONYM - IC_LOTS_STS

APPS.IC_LOCT_INV_UNALLOC is not referenced by any database object

[top of page]

View: IC_LOCT_MST_V1

[top of page]

APPS.IC_LOCT_MST_V1 references the following:

APPS
SYNONYM - IC_LOCT_MST

APPS.IC_LOCT_MST_V1 is not referenced by any database object

[top of page]

View: IC_LOTS_MST_V

[top of page]

APPS.IC_LOTS_MST_V references the following:

APPS
SYNONYM - IC_LOTS_MST

APPS.IC_LOTS_MST_V is not referenced by any database object

[top of page]

View: IC_LOTS_MST_V1

[top of page]

APPS.IC_LOTS_MST_V1 references the following:

APPS
SYNONYM - IC_LOTS_MST

APPS.IC_LOTS_MST_V1 is not referenced by any database object

[top of page]

View: IC_LOTS_MST_V2

[top of page]

APPS.IC_LOTS_MST_V2 references the following:

APPS
SYNONYM - IC_LOTS_MST

APPS.IC_LOTS_MST_V2 is not referenced by any database object

[top of page]

View: IC_MOVE_ORDER_LINES_V

[top of page]

APPS.IC_MOVE_ORDER_LINES_V references the following:

APPS
SYNONYM - IC_ITEM_MST
SYNONYM - IC_TXN_REQUEST_LINES
SYNONYM - IC_WHSE_MST
SYNONYM - MTL_SYSTEM_ITEMS

APPS.IC_MOVE_ORDER_LINES_V is not referenced by any database object

[top of page]

View: IC_PERD_BAL_VW1

[top of page]

APPS.IC_PERD_BAL_VW1 references the following:

APPS
SYNONYM - IC_PERD_BAL

APPS.IC_PERD_BAL_VW1 is not referenced by any database object

[top of page]

View: IC_PRCE_CLS_VW

[top of page]

APPS.IC_PRCE_CLS_VW references the following:

APPS
SYNONYM - GMI_CATEGORY_SETS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
APPS.IC_PRCE_CLS_VW is referenced by following:

APPS
SYNONYM - IC_PRCE_CLS

[top of page]

View: IC_PRCH_CLS_VW

[top of page]

APPS.IC_PRCH_CLS_VW references the following:

APPS
SYNONYM - GMI_CATEGORY_SETS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
APPS.IC_PRCH_CLS_VW is referenced by following:

APPS
SYNONYM - IC_PRCH_CLS

[top of page]

View: IC_PURG_VW1

[top of page]

APPS.IC_PURG_VW1 references the following:

APPS
SYNONYM - IC_TRAN_CMP
SYNONYM - OP_BILL_LAD
SYNONYM - OP_ORDR_DTL
SYNONYM - OP_ORDR_HDR
SYNONYM - PM_BTCH_HDR
SYNONYM - PO_ORDR_HDR
SYNONYM - PO_RECV_HDR

APPS.IC_PURG_VW1 is not referenced by any database object

[top of page]

View: IC_SALE_CLS_VW

[top of page]

APPS.IC_SALE_CLS_VW references the following:

APPS
SYNONYM - GMI_CATEGORY_SETS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
APPS.IC_SALE_CLS_VW is referenced by following:

APPS
SYNONYM - IC_SALE_CLS

[top of page]

View: IC_SHIP_CLS_VW

[top of page]

APPS.IC_SHIP_CLS_VW references the following:

APPS
SYNONYM - GMI_CATEGORY_SETS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
APPS.IC_SHIP_CLS_VW is referenced by following:

APPS
SYNONYM - IC_SHIP_CLS

[top of page]

View: IC_STOR_CLS_VW

[top of page]

APPS.IC_STOR_CLS_VW references the following:

APPS
SYNONYM - GMI_CATEGORY_SETS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
APPS.IC_STOR_CLS_VW is referenced by following:

APPS
SYNONYM - IC_STOR_CLS

[top of page]

View: IC_SUMM_INV_INT_V

[top of page]

APPS.IC_SUMM_INV_INT_V references the following:

APPS
SYNONYM - IC_ITEM_MST_B
SYNONYM - IC_LOCT_INV
SYNONYM - IC_LOTS_MST
SYNONYM - IC_LOTS_STS
SYNONYM - IC_TRAN_PND
APPS.IC_SUMM_INV_INT_V is referenced by following:

APPS
VIEW - IC_SUMM_INV_V

[top of page]

View: IC_SUMM_INV_ONHAND_V

[top of page]

APPS.IC_SUMM_INV_ONHAND_V references the following:

APPS
SYNONYM - IC_LOCT_INV
SYNONYM - IC_LOTS_MST
SYNONYM - IC_LOTS_STS

APPS.IC_SUMM_INV_ONHAND_V is not referenced by any database object

[top of page]

View: IC_SUMM_INV_PENDING_V

[top of page]

APPS.IC_SUMM_INV_PENDING_V references the following:

APPS
SYNONYM - IC_ITEM_MST
SYNONYM - IC_LOTS_MST
SYNONYM - IC_TRAN_PND

APPS.IC_SUMM_INV_PENDING_V is not referenced by any database object

[top of page]

View: IC_SUMM_INV_V

[top of page]

APPS.IC_SUMM_INV_V references the following:

APPS
VIEW - IC_SUMM_INV_INT_V
APPS.IC_SUMM_INV_V is referenced by following:

APPS
SYNONYM - IC_SUMM_INV

[top of page]

View: IC_TAXN_CLS_VW

[top of page]

APPS.IC_TAXN_CLS_VW references the following:

APPS
SYNONYM - GMI_CATEGORY_SETS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
APPS.IC_TAXN_CLS_VW is referenced by following:

APPS
SYNONYM - IC_TAXN_CLS

[top of page]

View: IC_TEXT_TBL_VL

[top of page]

APPS.IC_TEXT_TBL_VL references the following:

APPS
SYNONYM - IC_TEXT_TBL_TL
APPS.IC_TEXT_TBL_VL is referenced by following:

APPS
TRIGGER - GMA_IC_TEXT_TBL_T1
TRIGGER - GMA_IC_TEXT_TBL_T2
TRIGGER - GMA_IC_TEXT_TBL_T3
SYNONYM - IC_TEXT_TBL

[top of page]

View: IC_TRAN_CMP_VW1

[top of page]

APPS.IC_TRAN_CMP_VW1 references the following:

APPS
SYNONYM - IC_TRAN_CMP
SYNONYM - IC_TRAN_PND
APPS.IC_TRAN_CMP_VW1 is referenced by following:

APPS
PACKAGE BODY - OPI_EDW_OPM_PRD_PKG
VIEW - PMIFV_BATCH_TRANS_V
PACKAGE BODY - PMI_PRODUCTION_SUM

[top of page]

View: IC_TRAN_PND_VW2

[top of page]

APPS.IC_TRAN_PND_VW2 references the following:

APPS
SYNONYM - IC_LOTS_MST
SYNONYM - IC_TRAN_PND

APPS.IC_TRAN_PND_VW2 is not referenced by any database object

[top of page]

View: IC_TRAN_PND_VW3

[top of page]

APPS.IC_TRAN_PND_VW3 references the following:

APPS
SYNONYM - IC_LOTS_MST
SYNONYM - IC_TRAN_PND

APPS.IC_TRAN_PND_VW3 is not referenced by any database object

[top of page]

View: IC_TRAN_VW1

[top of page]

APPS.IC_TRAN_VW1 references the following:

APPS
SYNONYM - IC_TRAN_CMP
SYNONYM - IC_TRAN_PND
APPS.IC_TRAN_VW1 is referenced by following:

APPS
PACKAGE BODY - GMI_GMILTGEN_XMLP_PKG
VIEW - GMI_LOTS_EVENT_V
PACKAGE BODY - OPI_DBI_INV_VALUE_OPM_INIT_PKG
PACKAGE BODY - OPI_EDW_OPMCOGS_F_C
VIEW - PMITS_INV_LINE_SUMM_V
PACKAGE BODY - PMI_LOT_GENEALOGY_PKG
VIEW - QC_TRAN_VW1
VIEW - QC_TRAN_VW2

[top of page]

View: IC_TXN_REQUEST_LINES_V

[top of page]

APPS.IC_TXN_REQUEST_LINES_V references the following:

APPS
SYNONYM - IC_ITEM_MST
SYNONYM - IC_TXN_REQUEST_HEADERS
SYNONYM - IC_TXN_REQUEST_LINES
VIEW - MFG_LOOKUPS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - MTL_TRANSACTION_TYPES

APPS.IC_TXN_REQUEST_LINES_V is not referenced by any database object

[top of page]

View: IC_WHSE_MST_VW

[top of page]

APPS.IC_WHSE_MST_VW references the following:

APPS
SYNONYM - CM_WHSE_ASC
SYNONYM - IC_WHSE_MST
SYNONYM - SY_ORGN_MST
APPS.IC_WHSE_MST_VW is referenced by following:

APPS
PACKAGE BODY - INV_MIGRATE_PROCESS_ORG

[top of page]

View: INV_CALENDAR_VIEW

[top of page]

APPS.INV_CALENDAR_VIEW references the following:

APPS
SYNONYM - IC_CLDR_DTL
SYNONYM - IC_CLDR_HDR

APPS.INV_CALENDAR_VIEW is not referenced by any database object

[top of page]

View: IN_TEXT_TBL_VL

[top of page]

APPS.IN_TEXT_TBL_VL references the following:

APPS
SYNONYM - IN_TEXT_TBL_TL
APPS.IN_TEXT_TBL_VL is referenced by following:

APPS
TRIGGER - GMA_IN_TEXT_TBL_T1
TRIGGER - GMA_IN_TEXT_TBL_T2
TRIGGER - GMA_IN_TEXT_TBL_T3
SYNONYM - IN_TEXT_TBL

[top of page]

View: SUB_STD_ITEM_CLS_VW

[top of page]

APPS.SUB_STD_ITEM_CLS_VW references the following:

APPS
SYNONYM - GMI_CATEGORY_SETS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
APPS.SUB_STD_ITEM_CLS_VW is referenced by following:

APPS
PACKAGE BODY - GMIVITM

[top of page]

View: TECH_CLS_SUBCLS_VW

[top of page]

APPS.TECH_CLS_SUBCLS_VW references the following:

APPS
SYNONYM - GMI_CATEGORY_SETS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
APPS.TECH_CLS_SUBCLS_VW is referenced by following:

APPS
PACKAGE BODY - GMIVITM

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