Transaction Types

               

Transaction Type = Transaction Source Type + Transaction Action Type


TRANSACTIONTYPE ID
TRANSACTIONNAME
DESCRIPTION
TRANSACTIONSOURCE ID
TRANSACTIONACTION ID
1Account issueIssue material against account31
2Subinventory TransferTransfer material betweensubinventories132
3Direct Org TransferDirect transfer betweentwo organizations133
4Cycle Count AdjustRecord cycle count adjustments94
5Cycle Count TransferCycle Count Sub Transfer92
8Physical Inv AdjustPhysical Inventory adjustmenttransactions108
9Physical Inv TransferPhysical Count Sub Transfer102
12Intransit ReceiptReceive from intransit1312
15RMA ReceiptReturn material authorization1227
17WIP Assembly ReturnReturn assembly from storesto WIP532
18PO ReceiptReceive Purchase Order127
21Intransit ShipmentShip to intransit sourcedfrom Inventory1321
24Standard cost updateUpdate standard cost information1124
25WIP cost updateUpdate cost of a WIP item524
26Periodic Cost UpdateUpdate Periodic Cost1424
28Layer Cost UpdateLayer Cost Update1524
31Account alias issueIssue material against accountalias61
32Miscellaneous issuePerform miscellaneous issueof material131
33Sales order issueShip Confirm external SalesOrder21
34Internal order issueShip Confirm Internal Order:Issue81
35WIP component issueIssue components from storesto WIP51
36Return to VendorReturn to vendor from stores11
37RMA ReturnReturn return material authorization121
38WIP Neg Comp IssueIssue negative componentto WIP533
40Account receiptReceive material againstaccount327
41Account alias receiptReceive material againstaccount alias627
42Miscellaneous receiptPerform miscellaneous receiptof material1327
43WIP Component ReturnWIP component return transaction527
44WIP Assy CompletionComplete assemblies fromWIP to stores531
48WIP Neg Comp ReturnReturn negative componentfrom WIP534
50Internal Order XferSubinventory transfer sourcedby Internal order82
51Backflush TransferBackflush subinventory transfer132
52Sales Order PickStaging transfer on a Salesorder228
53Internal Order PickStaging transfer on an Internalorder828
54Int Order Direct ShipDirect transfer betweentwo organizations on a internal order83
55WIP Lot SplitLot Split540
56WIP Lot MergeLot Merge541
57Lot BonusLot Bonus542
58Lot Update QuantityLot Update Quantity543
61Int Req Intr RcptDelivery of intransit materialsourced by Internal requisition712
62Int Order Intr ShipShip to intransit sourcedby Internal order821
63Move Order IssueTransact Account Issue MoveOrder41
64Move Order TransferTransact Subinventory TransferMove Order42
66Project BorrowBorrow from project in projectmanufacturing132
67Project TransferTransfer to project in projectmanufacturing132
68Project PaybackPayback to project in projectmanufacturing132
70Shipment Rcpt AdjustAdjustment to receipt ofin-transit delivery1329
71PO Rcpt AdjustDelivery adjustments ona Purchase order receipt129
72Int Req Rcpt AdjustDelivery adjustments onintransit receipt sourced by Internal req.729
73Planning TransferPlanning Transfer135
77ProjectContract IssueProject contract Issue161
80Average cost updateUpdate average cost information1324
82Inventory Lot SplitLot Split1340
83Inventory Lot MergeLot Merge1341
84Inventory Lot TranslateLot Translate1342
86Cost Group TransferCost Group Transfer1355
87Container PackContainer Pack1350
88Container UnpackContainer Unpack1351
89Container SplitContainer Split1352
90WIP assembly scrapScrap assemblies from WIP530
91WIP return from scrapReturn assemblies scrappedto WIP530
92WIP estimated scrapWIP estimated scrap transaction530
93Field Service UsageField Service Usage131
94Field Service RecoveryField Service Recovery1327



           

再分享一下我老师大神的人工智能教程吧。零基础!通俗易懂!风趣幽默!还带黄段子!希望你也加入到我们人工智能的队伍中来!https://blog.csdn.net/jiangjunshow

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
优化以下Oracle语句: SELECT SUBSTR(msn.serial_number, 1, 10) genset_sn, msi2.segment1 Genset_BOM_NUM, msi2.inventory_item_id, msi.segment1 key_component, mut1.serial_number component_sn, msi.description component_desc, wdj.date_completed, (SELECT MAX(aps.vendor_name) FROM ap_suppliers aps, bom_resources bor, mtl_unit_transactions mut, po_headers_all poh, po_lines_all pol, wip_osp_resources_val_v wor WHERE aps.vendor_id = poh.vendor_id AND bor.resource_id = wor.resource_id AND poh.po_header_id = pol.po_header_id AND pol.item_id = bor.purchase_item_id AND wor.wip_entity_id = mut.transaction_source_id AND mut.serial_number = mut1.serial_number AND mut.inventory_item_id = mut1.inventory_item_id AND mut.organization_id = mut1.organization_id AND mut.receipt_issue_type = 2 AND mut.transaction_source_type_id = 5 ) supplier FROM mtl_material_transactions mmt1, mtl_material_transactions mmt2, mtl_parameters mpa, mtl_serial_numbers msn, mtl_system_items msi, mtl_system_items msi2, mtl_transaction_types mtt1, mtl_transaction_types mtt2, mtl_unit_transactions mut1, mtl_unit_transactions mut2, wip_discrete_jobs_v wdj WHERE mmt1.inventory_item_id = mut1.inventory_item_id AND mmt1.organization_id = mut1.organization_id AND WDJ.PRIMARY_ITEM_ID = msi2.INVENTORY_ITEM_ID AND mmt1.transaction_id = mut1.transaction_id AND mmt1.transaction_source_id = wdj.wip_entity_id AND mmt1.transaction_type_id = mtt1.transaction_type_id AND mtt1.transaction_type_name = 'WIP Issue' AND NOT EXISTS (SELECT 'WIP Negative Issue or WIP Return' FROM mtl_material_transactions mmt3, mtl_transaction_types mtt3, mtl_unit_transactions mut3 WHERE mmt3.transaction_id = mut3.transaction_id AND mmt3.transaction_type_id = mtt3.transaction_type_id AND mmt3.transaction_date > mmt1.transaction_date AND mtt3.transaction_type_name IN ('WIP Negative Issue', 'WIP Return') AND mut3.serial_number = mut1.serial_number AND mut3.inventory_item_id = mut1.inventory_item_id) AND mmt2.transaction_id = mut2.transaction_id AND mmt2.transaction_source_id = wdj.wip_entity_id AND mmt2.transaction_type_id = mtt2.transaction_type_id AND mtt2.transaction_type_name = 'WIP Completion' AND mpa.organization_code = 'WHP' AND msn.current_organization_id = mpa.organization_id AND LENGTH(msn.serial_number) >= 10 AND msi.inventory_item_id = mmt1.inventory_item_id AND msi.organization_id = mmt1.organization_id AND (msi.planning_make_buy_code = 2 OR msi.segment1 LIKE 'SO%') AND mut2.serial_number = msn.serial_number AND mut2.inventory_item_id = msn.inventory_item_id AND mut2.organization_id = mpa.organization_id AND msi2.ORGANIZATION_ID = '323'
最新发布
07-15

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值