INV_SERIAL_NUMBERS does not show some serial numbers
I have items serial numbers in which i have transaction id in INV_MATERIAL_TXNS which is join to INV_SERIAL_NUMBERS > LAST_TRANSACTION_ID
it is showing correct serials number but some of them are showing null. means items have created and there transaction id is also shows in INV_MATERIAL_TXNS
but not shows in INV_SERIAL_NUMBERS > LAST_TRANSACTION_ID. Through this i cant see some transactions serial number.
Could you please help me why this is happen?
I want to check my GRN have which serial number so how can create a query for this?