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.

[Home] [Help]

APPS.GME_CANCEL_BATCH_PVT dependencies on GME_PENDING_PRODUCT_LOTS

Line 819: DELETE FROM gme_pending_product_lots

815: || l_material_detail_id);
816: END IF;
817:
818: IF l_batch_id IS NOT NULL THEN
819: DELETE FROM gme_pending_product_lots
820: WHERE batch_id = l_batch_id;
821: ELSIF l_material_detail_id IS NOT NULL THEN
822: DELETE FROM gme_pending_product_lots
823: WHERE material_detail_id = l_material_detail_id;

Line 822: DELETE FROM gme_pending_product_lots

818: IF l_batch_id IS NOT NULL THEN
819: DELETE FROM gme_pending_product_lots
820: WHERE batch_id = l_batch_id;
821: ELSIF l_material_detail_id IS NOT NULL THEN
822: DELETE FROM gme_pending_product_lots
823: WHERE material_detail_id = l_material_detail_id;
824: ELSE
825: DELETE FROM gme_pending_product_lots
826: WHERE batch_id = l_batch_id

Line 825: DELETE FROM gme_pending_product_lots

821: ELSIF l_material_detail_id IS NOT NULL THEN
822: DELETE FROM gme_pending_product_lots
823: WHERE material_detail_id = l_material_detail_id;
824: ELSE
825: DELETE FROM gme_pending_product_lots
826: WHERE batch_id = l_batch_id
827: AND material_detail_id = l_material_detail_id;
828: END IF;
829: EXCEPTION