APPS.GME_DEBUG dependencies on GME_EXCEPTIONS_GTMP

Line 288: FROM gme_exceptions_gtmp

284: ,v_batch_id IN NUMBER
285: ,v_material_detail_id IN NUMBER)
286: IS
287: SELECT *
288: FROM gme_exceptions_gtmp
289: WHERE organization_id = v_organization_id
290: AND (batch_id = v_batch_id OR v_batch_id IS NULL)
291: AND ( material_detail_id = v_material_detail_id
292: OR v_material_detail_id IS NULL)

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

353: ' sec_transaction_qty = '||get_rec.secondary_transaction_quantity);
354: END LOOP;
355: gme_debug.put_line('***** End Txns created automatically by release/complete/IB etc. ***** ');
356: gme_debug.put_line('***** Exceptions created by release/complete/IB etc. *****');
357: FOR get_rec IN (SELECT * FROM gme_exceptions_gtmp) LOOP
358: gme_debug.put_line('Batch_id = '||get_rec.batch_id||' material_detail_id = '||get_rec.material_detail_id||
359: ' transacted_qty = '||get_rec.transacted_qty||' exception_qty = '||get_rec.exception_qty||
360: ' pending_move_order = '||get_rec.pending_move_order_ind||' pending_rsv_ind = '||get_rec.pending_reservations_ind);
361: END LOOP;