DBA Data[Home] [Help]

APPS.PA_WORK_TYPE_UPGRADE dependencies on WIP_TRANSACTIONS

Line 551: FROM WIP_TRANSACTIONS WT

547: SELECT to_number(NULL) Inventory_Item_ID
548: ,WT.Resource_Id Wip_Resource_ID
549: ,WT.Primary_UOM UOM
550: ,Temp.Pk1_ID
551: FROM WIP_TRANSACTIONS WT
552: ,Pa_Txn_Upgrade_Temp Temp
553: WHERE Temp.Worker_Id = p_worker_id
554: And Temp.Pk2_ID = WT.Transaction_ID
555: AND Temp.Txn_Src IN ('Work In Process'