[Home] [Help]
APPS.GME_REOPEN_BATCH_PVT dependencies on GME_BATCH_STEP_ITEMS
Line 59: FROM gme_batch_step_items
55: WHERE d.batch_id = v_batch_id
56: AND NVL (d.phantom_id, 0) > 0
57: AND NOT EXISTS (
58: SELECT 1
59: FROM gme_batch_step_items
60: WHERE material_detail_id = d.material_detail_id
61: AND d.release_type = 3);
62:
63: l_api_name CONSTANT VARCHAR2 (30) := 'REOPEN_BATCH';