Friday, June 5, 2015

serial number query

1. Determine the status of the serial number that you are attempting to use:

SELECT segment1 "ITEM", msn.serial_number, ml.meaning
FROM mtl_serial_numbers MSN,
           mtl_system_items_b MSIB,
           mfg_lookups ml
WHERE msn.inventory_item_id = msib.inventory_item_id
AND ml.lookup_code = msn.current_status
AND ml.lookup_type = 'SERIAL_NUM_STATUS'
AND msib.segment1 = '&your_item'
AND msn.serial_number ='&your_serial_number';

2.  If the status is 'Issued Out Of Stores', the serial number is used in some organization.  You will need another serial number for your transaction

No comments: