DBA Data[Home] [Help]

APPS.PA_WORK_TYPE_UPGRADE dependencies on WIP_TRANSACTIONS

Line 562: FROM WIP_TRANSACTIONS WT

558: SELECT to_number(NULL) Inventory_Item_ID
559: ,WT.Resource_Id Wip_Resource_ID
560: ,WT.Primary_UOM UOM
561: ,Temp.Pk1_ID
562: FROM WIP_TRANSACTIONS WT
563: ,Pa_Txn_Upgrade_Temp Temp
564: WHERE Temp.Worker_Id = p_worker_id
565: And Temp.Pk2_ID = WT.Transaction_ID
566: AND Temp.Txn_Src IN ('Work In Process'