首页 > 代码库 > Oracle EBS-SQL (INV-2):检查帐户别名发放记录.sql
Oracle EBS-SQL (INV-2):检查帐户别名发放记录.sql
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‘))