View: PMI_LOT_SOURCE_LEAF_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	This view lists raw material lots that are used in the manufacture of a product lot. In this context, a raw material lot is any lot that cannot be further decomposed into a lower level of constituent ingredients.
Implementation/DBA Data:	APPS.PMI_LOT_SOURCE_LEAF_V

View Text

SELECT PRODUCT_ITEM_ID
, PRODUCT_LOT_ID
, INGRED_ITEM_ID
, INGRED_LOT_ID
FROM PMI_LOT_GENEALOGY A
WHERE NOT EXISTS ( SELECT 'TRUE' FROM PMI_LOT_GENEALOGY B WHERE B.PRODUCT_LOT_ID = A.INGRED_LOT_ID AND B.INGRED_LOT_ID <> B.PRODUCT_LOT_ID ) WITH READ ONLY

Columns