APPS.WMS_POSTALLOC_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 5891: FROM mtl_serial_numbers_temp msnt

5887: , 'S'
5888: , t_last_update_date(kk)
5889: , t_last_updated_by(kk)
5890: , t_last_update_login(kk)
5891: FROM mtl_serial_numbers_temp msnt
5892: WHERE msnt.transaction_temp_id = t_transaction_temp_id(kk)
5893: AND t_dev_id(kk) IS NOT NULL
5894: AND t_lot_serial_capable_flag(kk) <> 'N'
5895: UNION ALL

Line 5923: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt

5919: , 'S'
5920: , t_last_update_date(kk)
5921: , t_last_updated_by(kk)
5922: , t_last_update_login(kk)
5923: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt
5924: WHERE mtlt.transaction_temp_id = t_transaction_temp_id(kk)
5925: AND mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
5926: AND t_dev_id(kk) IS NOT NULL
5927: AND t_lot_serial_capable_flag(kk) <> 'N' );

Line 6221: FROM mtl_serial_numbers_temp msnt

6217: , 'S'
6218: , t_last_update_date(nn)
6219: , t_last_updated_by(nn)
6220: , t_last_update_login(nn)
6221: FROM mtl_serial_numbers_temp msnt
6222: WHERE msnt.transaction_temp_id = t_transaction_temp_id(nn)
6223: AND t_dev_id(nn) IS NOT NULL
6224: AND t_lot_serial_capable_flag(nn) <> 'N'
6225: UNION ALL

Line 6253: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt

6249: , 'S'
6250: , t_last_update_date(nn)
6251: , t_last_updated_by(nn)
6252: , t_last_update_login(nn)
6253: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt
6254: WHERE mtlt.transaction_temp_id = t_transaction_temp_id(nn)
6255: AND mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
6256: AND t_dev_id(nn) IS NOT NULL
6257: AND t_lot_serial_capable_flag(nn) <> 'N' );