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.

APPS.GME_CANCEL_BATCH_PVT dependencies on GME_PENDING_PRODUCT_LOTS

Line 680: DELETE FROM gme_pending_product_lots

676: || l_material_detail_id);
677: END IF;
678:
679: IF l_batch_id IS NOT NULL THEN
680: DELETE FROM gme_pending_product_lots
681: WHERE batch_id = l_batch_id;
682: ELSIF l_material_detail_id IS NOT NULL THEN
683: DELETE FROM gme_pending_product_lots
684: WHERE material_detail_id = l_material_detail_id;

Line 683: DELETE FROM gme_pending_product_lots

679: IF l_batch_id IS NOT NULL THEN
680: DELETE FROM gme_pending_product_lots
681: WHERE batch_id = l_batch_id;
682: ELSIF l_material_detail_id IS NOT NULL THEN
683: DELETE FROM gme_pending_product_lots
684: WHERE material_detail_id = l_material_detail_id;
685: ELSE
686: DELETE FROM gme_pending_product_lots
687: WHERE batch_id = l_batch_id

Line 686: DELETE FROM gme_pending_product_lots

682: ELSIF l_material_detail_id IS NOT NULL THEN
683: DELETE FROM gme_pending_product_lots
684: WHERE material_detail_id = l_material_detail_id;
685: ELSE
686: DELETE FROM gme_pending_product_lots
687: WHERE batch_id = l_batch_id
688: AND material_detail_id = l_material_detail_id;
689: END IF;
690: EXCEPTION