APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 532: From mtl_serial_numbers_temp

528: END IF;
529: ELSE
530: select count(*)
531: into l_num_serial_record
532: From mtl_serial_numbers_temp
533: where transaction_temp_id = l_transaction_temp_id;
534:
535: debug('Found '||l_num_serial_record||' lines for tempid '||l_transaction_temp_id,'GET_DELIVERY_LINE_SERIAL_INFO');
536: END IF;

Line 3044: from mtl_serial_numbers_temp msnt, wsh_delivery_details_ob_grp_v wdd

3040: l_count NUMBER;
3041: BEGIN
3042: select count(*)
3043: into l_count
3044: from mtl_serial_numbers_temp msnt, wsh_delivery_details_ob_grp_v wdd
3045: where msnt.transaction_temp_id = wdd.transaction_temp_id
3046: and wdd.delivery_detail_id = l_delivery_detail_id
3047: and wdd.transaction_temp_id = l_transaction_temp_id;
3048:

Line 3050: delete from mtl_serial_numbers_temp

3046: and wdd.delivery_detail_id = l_delivery_detail_id
3047: and wdd.transaction_temp_id = l_transaction_temp_id;
3048:
3049: if( l_count > 0 ) then
3050: delete from mtl_serial_numbers_temp
3051: where transaction_temp_id in (select transaction_temp_id
3052: From wsh_delivery_details_ob_grp_v
3053: where transaction_temp_id = l_transaction_temp_id
3054: And delivery_detail_id = l_delivery_detail_id);