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-26 16:53  Jenrry  阅读(298)  评论(0编辑  收藏  举报