首页 > 数据库技术 > 详细

Oracle EBS-SQL (INV-2):检查帐户别名发放记录.sql

时间:2014-06-10 09:43:03      阅读:563      评论:0      收藏:0      [点我收藏+]

SELECT FU.description                 操作者,
         ITM.SEGMENT1               物料编码,
         ITM.DESCRIPTION           物料描述,
         TXN.TRANSACTION_DATE 交易日期,
         TXN.PRIMARY_QUANTITY 交易数量,
         TXN.SUBINVENTORY_CODE   仓库,
         MUM.UNIT_OF_MEASURE_TL 单位,
         A.ITEM_COST                 单位成本,
         MGD.DESCRIPTION         账户别名
    FROM INV.MTL_SYSTEM_ITEMS_B        ITM,
         INV.MTL_MATERIAL_TRANSACTIONS TXN,
         BOM.CST_ITEM_COSTS                   a,
         inv.mtl_generic_dispositions            MGD,
         INV.MTL_UNITS_OF_MEASURE_TL   MUM,
         applsys.fnd_user                            FU
   WHERE a.inventory_item_id(+) = ITM.inventory_item_id                          AND
         MUM.UOM_CODE = TXN.TRANSACTION_UOM AND a.cost_type_id = 1 AND
         ITM.INVENTORY_ITEM_ID = TXN.INVENTORY_ITEM_ID                      AND
         ITM.ORGANIZATION_ID = TXN.ORGANIZATION_ID                            AND
         mum.language=‘ZHS‘                                                                       AND
         txn.TRANSACTION_TYPE_ID = 31                                                      AND
         TXN.TRANSACTION_SOURCE_TYPE_ID = 6                                        AND --源类型为库存
         TXN.ORGANIZATION_ID = X                                                             AND
         A.ORGANIZATION_ID = TXN.ORGANIZATION_ID                               AND
         TXN.TRANSACTION_SOURCE_ID = MGD.DISPOSITION_ID                  AND
         FU.USER_ID = TXN.CREATED_BY                                                      AND
         (TXN.TRANSACTION_DATE between TO_DATE(‘20**-01-01‘,‘YYYY-MM-DD‘) AND
         TO_DATE( ‘20**-01-31‘, ‘YYYY-MM-DD‘))

Oracle EBS-SQL (INV-2):检查帐户别名发放记录.sql,布布扣,bubuko.com

Oracle EBS-SQL (INV-2):检查帐户别名发放记录.sql

原文:http://www.cnblogs.com/st-sun/p/3778457.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!