[Home] [Help] [Dependency Information]

VIEW: APPS.GMI_LOTS_DEST_V

Object Details

Object Name:	GMI_LOTS_DEST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMI.GMI_LOTS_DEST_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 Where Used tab of the Lot Genealogy Inquiry when the navigation mode is Where Used. It returns the product lots output by batches, for which the lot highlighted (in the Genealogy Navigator) was used as an ingredient. The Where Used 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
,      LINE_TYPE
,      INGRED_ITEM_ID
,      INGRED_LOT_ID
,      PRODUCT_ITEM_NO
,      PRODUCT_ITEM_DESC1
,      PRODUCT_ITEM_UM
,      PRODUCT_ITEM_UM2
,      INV_TYPE
,      INV_CLASS
,      PRODUCT_LOT_NO
,      PRODUCT_SUBLOT_NO
,      SUM_TRANS_QTY1
,      SUM_TRANS_QTY2
,      WHSE_CODE
,      LOCATION
,      QC_GRADE
,      LOT_STATUS
FROM APPS.GMI_LOTS_DEST_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