Oracle EBS INV 更新物料慢

失效ICX 

SELECT FA.APPLICATION_SHORT_NAME, FA.APPLICATION_ID,
PI.STATUS, PI.PRODUCT_VERSION, PI.PATCH_LEVEL
FROM FND_PRODUCT_INSTALLATIONS PI,FND_APPLICATION FA
WHERE FA.APPLICATION_ID = PI.APPLICATION_ID
AND UPPER(APPLICATION_SHORT_NAME)='ICX' 

Update fnd_product_installations set status='S'where application_id=178

 

posted on 2018-11-23 14:01  Jenrry  阅读(319)  评论(0编辑  收藏  举报