GMI Views (64)

GMI - Process Manufacturing Inventory — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`GL_BUSINESS_CLS_VW`	GL Business Class view
`GL_PROD_LINE_VW`	GL Product Line view
`GMI_AAC_CUST_NUM_V`	View Of Process Customers By Name and Number Including the Ship to site information, company and whse.
`GMI_AAC_ORDER_NUM_V`	View Of Orders that have been BOOKED and PICK RELEASED which have open Move Order Lines.
`GMI_ITEM_CATEGORIES_V1`	View for OPM Item Master support for Eres catsets
`GMI_ITEM_ORGANIZATIONS_V1`	View of GMI_ITEM_ORGANIZATIONS plus organization name, code, and master org
`GMI_LOTS_BOM_V`	View of Product document id plus product and ingredient lot id and item id.
`GMI_LOTS_COMP_V`	This view is used to populate the Lot Source tab of the Lot Genealogy Inquiry when the navigation mode is Lot Source.
`GMI_LOTS_DEST_BOM_V`	This view is used to populate the Lot Genealogy Tree Navigator
`GMI_LOTS_DEST_LIST_V`	This view is used to populate the Lot Genealogy Tree Navigator (on the Lot Genealogy Inquiry) when the navigation mode is Where Used, and th
`GMI_LOTS_DEST_V`	This view is used to populate the Where Used tab of the Lot Genealogy Inquiry when the navigation mode is Where Used
`GMI_LOTS_EVENT_V`	This view is used to populate the Lot Events tab of the Lot Genealogy Inquiry.
`GMI_LOTS_LIST_V`	This view is the basis for the views GMI_LOTS_DEST_LIST_V and GMI_LOTS_SOURCE_LIST_V.
`GMI_LOTS_SOURCE_BOM_V`	This view is used to populate the Lot Genealogy Tree Navigator (on the Lot Genealogy Inquiry) when the navigation mode is Lot Source.
`GMI_LOTS_SOURCE_LIST_V`	This view is used to populate the Lot Genealogy Tree Navigator (on the Lot Genealogy Inquiry) when the navigation mode is Lot Source, and th
`GMI_PICK_LOTS_V`	View to populate pick lots screen from shipment form
`GMI_PICK_SLIP_NUMBER_V`	This is used in the definition of the Value Set GMI_PICK_SLIP_NUMBERS in order to get the list of the existing OPM Pick Slip Numbers.
`GMI_PICK_SLIP_VW`	This view is the basis of the OPM Pick Slip report (GMIRDPIK.rdf).
`GMI_WSH_PICK_SLIP_V`	This view is the basis of the OPM Pick Slip report (GMIRDPIK.rdf).
`GMI_XFER_MST_V`	This view is used to populate the Inventory Transfer form. Its primary base table is ic_xfer_mst.
`IC_ADJS_JNL_VW`	Inventory Adjustment Journal view
`IC_ALLC_CLS_VW`	This view is used for backward compatibility for allocation classes.
`IC_CLDR_HDR_VL`	MLS enabled view of OPM inventory calendar
`IC_COST_CLS_VW`	This view is used for backward compatibility for cost classes
`IC_CTMS_CLS_VW`	This view is used for backward compatibility for customs classes.
`IC_FRGT_CLS_VW`	This view is used for backward compatibility for freight classes.
`IC_GLED_CLS_VW`	This view is used for backward compatibility for GL classes.
`IC_INVN_CLS_VW`	This view is used for backward compatibility for inventory classes.
`IC_ITEM_HIERARCHY_V`	Used by Item Activation Workflow
`IC_ITEM_INV_V`	This is used in the OPM Allocation Engine in order to get the OnHand and Commit quantities for an item.
`IC_ITEM_MST_VL`	OPM Items MLS enabled View
`IC_LOCT_INV_RPTVW1`	Lot inventory report view.
`IC_LOCT_INV_RPTVW2`	Not currently used.
`IC_LOCT_INV_RPTVW3`	Not currently used.
`IC_LOCT_INV_RPTVW4`	Trial Picklist report view.
`IC_LOCT_INV_UNALLOC`	Not currently used
`IC_LOCT_MST_V1`	Not currently used
`IC_LOTS_MST_V`	Not currently used
`IC_LOTS_MST_V1`	Not currently used
`IC_LOTS_MST_V2`	Not currently used
`IC_MOVE_ORDER_LINES_V`	This view is used in the OPM Pick Lots form (ICPCKLOT.fmb), and gives the Move Order Lines information for the form.
`IC_PERD_BAL_VW1`	Period balance view.
`IC_PRCE_CLS_VW`	This view is used for backward compatibility for price classes.
`IC_PRCH_CLS_VW`	This view is used for backward compatibility for purchasing classes.
`IC_PURG_VW1`	Transaction purge view.
`IC_SALE_CLS_VW`	This view is used for backward compatibility for sales classes.
`IC_SHIP_CLS_VW`	This view is used for backward compatibility for shipping classes.
`IC_STOR_CLS_VW`	This view is used for backward compatibility for storage classes.
`IC_SUMM_INV_INT_V`	Private View
`IC_SUMM_INV_ONHAND_V`	Private view
`IC_SUMM_INV_PENDING_V`	Private View
`IC_SUMM_INV_V`	GMI summary inventory view
`IC_TAXN_CLS_VW`	This view is used for backward compatibility for tax classes.
`IC_TEXT_TBL_VL`
`IC_TRAN_CMP_VW1`	Completed inventory transaction
`IC_TRAN_PND_VW2`	Selects transactions summaries for items from IC_TRAN_PND.
`IC_TRAN_PND_VW3`	Selects completed and pending transactions from IC_TRAN_PND.
`IC_TRAN_VW1`	Transaction view.
`IC_TXN_REQUEST_LINES_V`	This view is used in the OPM Transact Process Move Orders form (ICTOTRX.fmb) to get the Move Order Lines data based on the entered criteria.
`IC_WHSE_MST_VW`	View for pre migration UI mapping of warehouse
`INV_CALENDAR_VIEW`
`IN_TEXT_TBL_VL`
`SUB_STD_ITEM_CLS_VW`	Substandard Item Class view
`TECH_CLS_SUBCLS_VW`	Technical Class Subclass View