View: PMI_LOT_SHARED_V

Product:	PMI - Process Manufacturing Intelligence
Description:	This view lists lots that share ingredient lots with another product start lot
Implementation/DBA Data:	APPS.PMI_LOT_SHARED_V

View Text

SELECT LEAF_V.PRODUCT_ITEM_ID START_ITEM_ID
, LEAF_V.PRODUCT_LOT_ID START_LOT_ID
, DEST_V.PRODUCT_ITEM_ID SHARED_ITEM_ID
, DEST_V.PRODUCT_LOT_ID SHARED_LOT_ID
FROM PMI_LOT_SOURCE_LEAF_V LEAF_V
, PMI_LOT_GENEALOGY DEST_V
WHERE DEST_V.INGRED_LOT_ID = LEAF_V.INGRED_LOT_ID GROUP BY LEAF_V.PRODUCT_ITEM_ID
, LEAF_V.PRODUCT_LOT_ID
, DEST_V.PRODUCT_ITEM_ID
, DEST_V.PRODUCT_LOT_ID WITH READ ONLY

Columns