DBA Data[Home] [Help]

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 3063: DELETE FROM mtl_serial_numbers_temp

3059: END IF;
3060:
3061: BEGIN
3062: forall i IN 1 .. l_mmtts_count
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