- 1. TRANSACTION_ACTION_ID
select TRANSACTION_ACTION_ID,count(*) from MTL_MATERIAL_TRANSACTIONS group by TRANSACTION_ACTION_ID
|
TRANSACTION_ACTION_ID |
COUNT |
REMARK |
|
1 |
429123 |
从库存发放 |
|
2 |
22798 |
子库存转移 |
|
3 |
24 |
组织直接转移 |
|
24 |
2 |
成本更新 |
|
27 |
244138 |
接收至库存 |
|
28 |
619706 |
分段转移 |
|
29 |
48 |
交货调整 |
SELECT LOOKUP_CODE,MEANING,DESCRIPTION
FROM FND_LOOKUP_VALUES_VL
WHERE (nvl('', territory_code) = territory_code or territory_code is null)
AND lookup_type = 'MTL_TRANSACTION_ACTION'
and (LOOKUP_TYPE LIKE 'MTL_TRANSACTION_ACTION')
and (VIEW_APPLICATION_ID = 700)
and (SECURITY_GROUP_ID = 0)
order by LOOKUP_CODE
1 从库存发放
12 在途接收
2 子库存转移
21 在途发货
24 成本更新
27 接收至库存
28 分段转移
29 交货调整
3 组织直接转移
30 WIP 报废事务处理
31 完成装配
32 退回装配件
33 负组件发放
34 负组件退货
35 集装箱事务处理 集装箱事务处理
4 周期盘点调整
40 分割批次 分割批次
41 合并批次 合并批次
42 批次转换 批次转换
43 批次更新数量 批次更新数量
5 计划转移 计划转移
50 集装箱装箱 集装箱装箱
51 集装箱卸货 集装箱卸货
52 集装箱分解
55 成本组转移
6 所有权转移 所有权转移
8 物理库存调整
- transaction_type_id
select transaction_type_id,count(*) from MTL_MATERIAL_TRANSACTIONS group by transaction_type_id
|
TRANSACTION_TYPE_ID |
COUNT |
REMARK |
|
2 |
2 |
Subinventory Transfer Transfer material between subinventories |
|
3 |
24 |
Direct Org Transfer Direct transfer between two organizations |
|
15 |
3856 |
RMA Receipt Return material authorization |
|
18 |
204263 |
PO Receipt Receive Purchase Order |
|
31 |
14896 |
Account alias issue Issue material against account alias |
|
33 |
411916 |
Sales order issue Ship Confirm external Sales Order |
|
36 |
2312 |
Return to Vendor Return to vendor from stores |
|
41 |
36021 |
Account alias receipt Receive material against account alias |
|
52 |
619708 |
Sales Order Pick Staging transfer on a Sales order |
|
64 |
92 |
Move Order Transfer Transact Subinventory Transfer Move Order |
|
71 |
48 |
PO Rcpt Adjust Delivery adjustments on a Purchase order receipt |
|
80 |
2 |
Average cost update Update average cost information |
|
100 |
9884 |
LENDING MOVE 借物出库 |
|
101 |
9564 |
LENDING RETURN 借物归还 |
|
102 |
834 |
DEFECTIVE MOVE 不良品 |
|
103 |
12 |
PROMOTION MOVE 促销品 |
|
104 |
542 |
BULK MOVE 散货 |
|
105 |
2 |
ESS MOVE ESS |
|
106 |
1866 |
VMI MOVE VMI转移 |
select mtt.transaction_type_id,mtt.transaction_type_name,mtt.description from mtl_transaction_types mtt where mtt.transaction_type_id in(
select transaction_type_id from MTL_MATERIAL_TRANSACTIONS group by transaction_type_id
)
2 Subinventory Transfer Transfer material between subinventories
3 Direct Org Transfer Direct transfer between two organizations
15 RMA Receipt Return material authorization
18 PO Receipt Receive Purchase Order
31 Account alias issue Issue material against account alias
33 Sales order issue Ship Confirm external Sales Order
36 Return to Vendor Return to vendor from stores
41 Account alias receipt Receive material against account alias
52 Sales Order Pick Staging transfer on a Sales order
64 Move Order Transfer Transact Subinventory Transfer Move Order
71 PO Rcpt Adjust Delivery adjustments on a Purchase order receipt
80 Average cost update Update average cost information
100 LENDING MOVE 借物出库
101 LENDING RETURN 借物归还
102 DEFECTIVE MOVE 不良品
103 PROMOTION MOVE 促销品
104 BULK MOVE 散货
105 ESS MOVE ESS
106 VMI MOVE VMI转移
- TRANSACTION_SOURCE_TYPE_ID
select TRANSACTION_SOURCE_TYPE_ID,count(*) from MTL_MATERIAL_TRANSACTIONS group by TRANSACTION_SOURCE_TYPE_ID
|
TRANSACTION_SOURCE_TYPE_ID |
COUNT |
REMARK |
|
1 |
206624 |
Purchase order |
|
2 |
1031624 |
Sales order |
|
4 |
22796 |
Move order |
|
6 |
50917 |
Account alias |
|
12 |
3856 |
RMA |
|
13 |
28 |
Inventory |
select mts.transaction_source_type_id,mts.transaction_source_type_name from MTL_TXN_SOURCE_TYPES mts
1 Purchase order
2 Sales order
3 Account
4 Move order
5 Job or Schedule
6 Account alias
7 Internal requisition
8 Internal order
9 Cycle Count
10 Physical Inventory
11 Standard cost update
12 RMA
13 Inventory
14 Periodic Cost Update
16 Project Contract
15 Layer Cost Update
17 External Requisition
- 4. rcv_transactions
附件图片是在哪个模块的没有找到，看是对应到哪张表？能否告诉我下
还有表rcv_transactions 的 transaction_type 值是在哪个模块维护的？
SELECT fvl.LOOKUP_CODE,fvl.MEANING,fvl.DESCRIPTION FROM FND_LOOKUP_VALUES_VL fvl
where fvl.lookup_type ='RCV TRANSACTION TYPE'
1 SHIP 发运 在途发货或内部订单
2 CORRECT 更正 更正前一事务处理录入
3 DELIVER 交货 将物料发货交至申请人
4 RECEIVE 接收 接收物料发货
5 ACCEPT 接受 接受随后检验的物料
6 REJECT 拒绝 拒绝随后检验的物料
7 MATCH 匹配 将未订购物料匹配至采购订单
8 CANCEL 取消 取消 ASN 的提前发货通知事务处理
9 RETURN TO CUSTOMER 退回给客户 将物料退回给客户
10 RETURN TO VENDOR 退回供应商 将物料退回至供应商
11 RETURN TO RECEIVING 退回接收部门 将交货物料退回至接收
12 UNORDERED 未订购接收 接收与来源单据不匹配的物料
13 TRANSFER 转移 在接收地点之间转移物料
