[Home] [Help] [Dependency Information]

VIEW: APPS.GMI_LOTS_COMP_V

Object Details

Object Name:	GMI_LOTS_COMP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMI.GMI_LOTS_COMP_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view is used to populate the Lot Source tab of the Lot Genealogy Inquiry when the navigation mode is Lot Source. It returns the ingredient lots that went into the batch(es), for which the lot highlighted (in the Genealogy Navigator) was output as a product lot. The Lot Source tab, using this view, adds additional attributes that are not displayed in the Lot Genealogy Tree Navigator.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT PRODUCT_ITEM_ID
,      PRODUCT_LOT_ID
,      TRANS_DATE
,      INGRED_ITEM_ID
,      INGRED_LOT_ID
,      ITEM_NO
,      ITEM_DESC1
,      ITEM_UM
,      ITEM_UM2
,      LOT_NO
,      SUBLOT_NO
,      SUM_TRANS_QTY1
,      SUM_TRANS_QTY2
,      WHSE_CODE
,      LOCATION
,      QC_GRADE
,      LOT_STATUS
FROM APPS.GMI_LOTS_COMP_V;

Dependencies

[top of page]

APPS

FM_FORM_MST

IC_ITEM_MST

IC_LOTS_MST

IC_TRAN_CMP

IC_TRAN_PND

PM_BTCH_HDR

APPS

GMI_GMILTGEN_XMLP_PKG - show dependent code