|
摘要：
SELECT distinct res.source_business_grp_id + 0 "businessGroupId", res.source_last_name || ', ' || res.source_first_name || '(' || res.user_name || ')' "salesrepFullName", res.source_email "emailAddress", res.RESOURCE_ID "salesForceId", 阅读全文
posted @ 2012-05-15 16:33 奥客 阅读(306) 评论(0) 推荐(0) 编辑
摘要：
--更新如下表中的数量和状态update rcv_lots_interface rliset rli.quantity = 37094,rli.primary_quantity = 37094where rli.interface_transaction_id = 754842and rli.lot_num = '1208';UPDATE MTL_TRANSACTION_LOTS_TEMP mtltSET mtlt.transaction_quantity = 37094,mtlt.primary_quantity = 37094WHERE mtlt.transaction_t 阅读全文
posted @ 2012-05-15 15:09 奥客 阅读(300) 评论(0) 推荐(0) 编辑 |
||
