APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 531: From mtl_serial_numbers_temp

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

Line 2889: from mtl_serial_numbers_temp msnt, wsh_delivery_details_ob_grp_v wdd

2885: l_count NUMBER;
2886: BEGIN
2887: select count(*)
2888: into l_count
2889: from mtl_serial_numbers_temp msnt, wsh_delivery_details_ob_grp_v wdd
2890: where msnt.transaction_temp_id = wdd.transaction_temp_id
2891: and wdd.delivery_detail_id = l_delivery_detail_id
2892: and wdd.transaction_temp_id = l_transaction_temp_id;
2893:

Line 2895: delete from mtl_serial_numbers_temp

2891: and wdd.delivery_detail_id = l_delivery_detail_id
2892: and wdd.transaction_temp_id = l_transaction_temp_id;
2893:
2894: if( l_count > 0 ) then
2895: delete from mtl_serial_numbers_temp
2896: where transaction_temp_id in (select transaction_temp_id
2897: From wsh_delivery_details_ob_grp_v
2898: where transaction_temp_id = l_transaction_temp_id
2899: And delivery_detail_id = l_delivery_detail_id);