533: ,to_number(NULL) Wip_Resource_Id
534: ,MSI.Primary_UOM_Code UOM
535: ,Temp.Pk1_Id
536: FROM MTL_MATERIAL_TRANSACTIONS MMT
537: ,MTL_SYSTEM_ITEMS MSI
538: ,Pa_Txn_Upgrade_Temp Temp
539: WHERE Temp.Worker_Id = p_worker_id
540: And Temp.Pk2_id = MMT.Transaction_Id
541: AND MMT.Inventory_Item_Id = MSI.Inventory_Item_Id