APPS.WMS_RCV_PUP_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP
Line 189: mtl_serial_numbers_temp
185: ,n_attribute8
186: ,n_attribute9
187: ,n_attribute10
188: FROM 189: mtl_serial_numbers_temp 190: WHERE
191: transaction_temp_id = l_txn_tmp_id;
192:
193: BEGIN
Line 3016: DELETE FROM mtl_serial_numbers_temp
3012: END IF;
3013:
3014: BEGIN
3015: forall i IN 1 .. l_mmtts_count 3016: DELETE FROM mtl_serial_numbers_temp 3017: WHERE transaction_temp_id = l_mmtt_ids(i)
3018: OR transaction_temp_id IN
3019: (SELECT mtlt.serial_transaction_temp_id
3020: FROM mtl_transaction_lots_temp mtlt