APPS.GME_DEBUG dependencies on GME_EXCEPTIONS_GTMP

Line 298: FROM gme_exceptions_gtmp

294: ,v_batch_id IN NUMBER
295: ,v_material_detail_id IN NUMBER)
296: IS
297: SELECT *
298: FROM gme_exceptions_gtmp
299: WHERE organization_id = v_organization_id
300: AND (batch_id = v_batch_id OR v_batch_id IS NULL)
301: AND ( material_detail_id = v_material_detail_id
302: OR v_material_detail_id IS NULL)

Line 367: FOR get_rec IN (SELECT * FROM gme_exceptions_gtmp) LOOP

363: ' sec_transaction_qty = '||get_rec.secondary_transaction_quantity);
364: END LOOP;
365: gme_debug.put_line('***** End Txns created automatically by release/complete/IB etc. ***** ');
366: gme_debug.put_line('***** Exceptions created by release/complete/IB etc. *****');
367: FOR get_rec IN (SELECT * FROM gme_exceptions_gtmp) LOOP
368: gme_debug.put_line('Batch_id = '||get_rec.batch_id||' material_detail_id = '||get_rec.material_detail_id||
369: ' transacted_qty = '||get_rec.transacted_qty||' exception_qty = '||get_rec.exception_qty||
370: ' pending_move_order = '||get_rec.pending_move_order_ind||' pending_rsv_ind = '||get_rec.pending_reservations_ind);
371: END LOOP;