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‘))
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。