544: ,to_number(NULL) Wip_Resource_Id
545: ,MSI.Primary_UOM_Code UOM
546: ,Temp.Pk1_Id
547: FROM MTL_MATERIAL_TRANSACTIONS MMT
548: ,MTL_SYSTEM_ITEMS MSI
549: ,Pa_Txn_Upgrade_Temp Temp
550: WHERE Temp.Worker_Id = p_worker_id
551: And Temp.Pk2_id = MMT.Transaction_Id
552: AND MMT.Inventory_Item_Id = MSI.Inventory_Item_Id