DBA Data[Home] [Help]

APPS.PA_WORK_TYPE_UPGRADE dependencies on MTL_SYSTEM_ITEMS

Line 537: ,MTL_SYSTEM_ITEMS MSI

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