DBA Data[Home] [Help]

APPS.PA_WORK_TYPE_UPGRADE dependencies on MTL_MATERIAL_TRANSACTIONS

Line 536: FROM MTL_MATERIAL_TRANSACTIONS MMT

532: SELECT MMT.Inventory_Item_Id Inventory_Item_ID
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