[Home] [Help]
APPS.GME_ERES_UTILS SQL Statements
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Line: 21
SELECT count(1)
FROM gme_material_details
WHERE phantom_id = p_batch_id
AND ROWNUM = 1;
Line: 47
SELECT organization_code || ' ' || batch_no
FROM gme_batch_header_vw
WHERE batch_id = v_batch_id;