If the objective is to view items that have been KITTED, then this information resides in the kalocate table. This table is linked to the kamain table by the kaseqnum field. The kamain table contains work order, dept_id actual quantity and date, and uniq_key. The uniq_key is linked to the inventor table to find the part number and revision.
Also in the kalocate table is the W-key, which links to invtmfgr table and warehouse/location information. Also is the uniqmfgrhd, which links to the invtmfhd table where the AVL information is contained.
|