APPS.WMS_RCV_PUP_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 384: mtl_transaction_lots_temp

380: ,l_lot_attribute13
381: ,l_lot_attribute14
382: ,l_lot_attribute15
383: FROM
384: mtl_transaction_lots_temp
385: WHERE
386: transaction_temp_id = p_transaction_temp_id;
387: EXCEPTION
388: WHEN no_data_found THEN

Line 3067: FROM mtl_transaction_lots_temp mtlt

3063: DELETE FROM mtl_serial_numbers_temp
3064: WHERE transaction_temp_id = l_mmtt_ids(i)
3065: OR transaction_temp_id IN
3066: (SELECT mtlt.serial_transaction_temp_id
3067: FROM mtl_transaction_lots_temp mtlt
3068: WHERE mtlt.transaction_temp_id = l_mmtt_ids(i));
3069: IF (l_debug = 1) THEN
3070: print_debug('# OF MSNT DELETED: ' || SQL%rowcount);
3071: END IF;

Line 3082: DELETE FROM mtl_transaction_lots_temp

3078: END;
3079:
3080: BEGIN
3081: forall i IN 1 .. l_mmtts_count
3082: DELETE FROM mtl_transaction_lots_temp
3083: WHERE transaction_temp_id = l_mmtt_ids(i);
3084: IF (l_debug = 1) THEN
3085: print_debug('# OF MTLT DELETED: ' || SQL%rowcount);
3086: END IF;