eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PMI_LOT_SHARED_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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