VIEW: APPS.PMI_LOT_SOURCE_LEAF_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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