View: GMI_LOTS_SOURCE_BOM_V

Product:	GMI - Process Manufacturing Inventory
Description:	This view is used to populate the Lot Genealogy Tree Navigator (on the Lot Genealogy Inquiry) when the navigation mode is Lot Source.
Implementation/DBA Data:	APPS.GMI_LOTS_SOURCE_BOM_V

View Text

SELECT DOC_ID
, PRODUCT_ITEM_ID
, PRODUCT_LOT_ID
, INGRED_ITEM_ID
, INGRED_LOT_ID
, GMI_LOT_TRACE_PKG.HAS_INGRED(INGRED_ITEM_ID
, INGRED_LOT_ID) HAS_CHILD
FROM GMI_LOTS_BOM_V GROUP BY DOC_ID
, PRODUCT_ITEM_ID
, PRODUCT_LOT_ID
, INGRED_ITEM_ID
, INGRED_LOT_ID

Columns