Transaction Quantity to Primary Quantity

最新推荐文章于 2023-02-17 08:13:13 发布
最新推荐文章于 2023-02-17 08:13:13 发布
阅读量1.1k 收藏
点赞数
分类专栏： INV
本文提供了一个使用PL/SQL进行单位换算的例子，展示了如何将交易数量从交易单位（如件数PC）转换到主单位的流程。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

--Convert the transaction quantity to Primary UOM's quantity
DECLARE
  L_PRIMARY_QTY NUMBER;
BEGIN

  PO_UOM_S.UOM_CONVERT(100 --Transaction Quantity
                      ,'PC' --Transaction Uom
                      ,403769 --Inventory_item_id
                      ,'PC' --Primary Uom Code
                      ,L_PRIMARY_QTY);

  DBMS_OUTPUT.PUT_LINE(L_PRIMARY_QTY);

END;

EBS 可保留量(Quantity Available To Reserve) 异常
Oralce Ebs 专栏
09-30 6085
销售挑库因为可保留量不足失败：   库存管理下检查现有量，现有量正常，但是处理和可保留存在占用。 查询待定事务处理和相关接口表，未发现待定数据。（tmp和interface） 检查批次失效时间（R12.0 BUG）：物料无批次失效控制。 （注：R12.0存在一个bu
Transaction Historical Summary(Quantity,Value,Balance)
系统运维
11-16 203
Transaction Historical Summary Report Use the Transaction Historical Summary Report to report past item quantities, past item value, or past inventory balances. The report calculates historical bal...
oracle ebs分销模块,oracle ebs表结构及功能总结(财务,制造,分销模块)
weixin_35588980的博客
04-05 665
Oracle application表结构1．表结构，WHO字段来实现通过菜单HELP 下的HISTORY 来找表2. 通过LAST_QUERY来判断所使用的表LAST_ QUERY 是系统变量保存所执行的最后一次的SQL语句 BLOCK 一定选SYSTEM 作为一个虚拟的BLOCK 用HELP 菜单下面的EXAMING子菜单3.用TRACE的办法来实现找表4.查看源代码来找表基本表结构学习目的：...
interface 开发
cuixie7913的博客
11-12 249
Inventory 物料库存 mtl_transactions_interface 的开发示例代码 mtl_transactions_interface的开发:比如杂收，杂发，物料库存数控制等。注意item的属性控制。IN...
Oracle application 表结构
行走的艺术
10-11 1285
Oracle application 表结构   1． 表结构，WHO字段来实现 通过菜单HELP 下的HISTORY 来找表 2. 通过LAST_QUERY来判断所使用的表    LAST_ QUERY 是系统变量 保存所执行的最后一次的SQL语句  BLOCK 一定选SYSTEM  作为一个虚拟的BLOCK    用HELP 菜单下面的EXAMING子菜单 3.用TRACE的办法
详解EBS接口开发之库存事务处理采购接收和退货
biqidaoer的专栏
02-17 1811
1.1 常用标准表如下表中列出了与采购接收&退货导入相关的表和说明：表名说明其他信息采购接收事务表事务类型，订单分配行相关信息采购接收头表接收单号，供应商，订单号对应视图采购接收行表物料信息，接收组织信息，接收子库，接收数量对应视图mtl_supply可以接收入库的记录对应视图接收科目事件表对应视图接收会计科目表对应视图物料信息表是否启用批次控制对应视图批次信息表物料事务处理子库，事务类型，数量，事务处理时间库存现有量1.2 接口表大体介绍。
根据这些信息提供创建数据库和创建数据表的Oracle代码：CUSTOMER: stores customer information such as name, address, phone number, email, and loyalty program status. This table has the primary key of CustomerID. • ORDER: stores information about each order such as the order date, order status, and total cost. This table has a primary key of OrderID and a foreign key to the Customer table. • ORDER_DETAILS: stores details about each item in an order such as the product name, price, quantity, and subtotal. This table has a primary key of OrderDetailID and foreign keys to the Order and PRODUCT tables. • PRODUCT: stores information about each product such as the product name, description, price, and category. This table has the primary key of ProductID. • STORE: stores information about each store such as the store name, location, and hours of operation. This table has the primary key of StoreID. • INVENTORY: stores information about the inventory for each product in each store such as the quantity on hand and the reorder point. This table has a composite primary key of ProductID and StoreID. Group Assignment • TRANSACTION: stores information about each transaction such as the transaction date, transaction type, and total amount. This table has a primary key of TransactionID and a foreign key to the Customer table. • TRANSACTION_DETAILS: stores details about each item in a transaction such as the product name, price, quantity, and subtotal. This table has the primary key of TransactionDetailID and foreign keys to the TRANSACTION and PRODUCT tables. • EMPLOYEE: stores employee information such as name, address, phone number, email, and position. This table has the primary key of EmployeeID. • SALARY: stores information about the salary for each employee such as the salary amount, start date, and end date. This table has a composite primary key of EmployeeID and StartDate. • SHIFT: stores information about the shift for each employee such as the start time, end time, and store location. This table has a primary key of ShiftID and foreign keys to the Employee and STORE tables.
05-23
TransactionID INT PRIMARY KEY, TransactionDate DATE, TransactionType VARCHAR(20), TotalAmount DECIMAL(10, 2), CustomerID INT FOREIGN KEY REFERENCES CUSTOMER(CustomerID) ); CREATE TABLE ...
ATE TABLE ORDER_DETAILS ( OrderDetailID NUMBER PRIMARY KEY, OrderID NUMBER, ProductID NUMBER, ProductName VARCHAR2(100), Price NUMBER, Quantity NUMBER, Subtotal NUMBER, CONSTRAINT FK_ORDER_DETAILS_ORDER FOREIGN KEY (OrderID) REFERENCES "ORDER"(OrderID), CONSTRAINT FK_ORDER_DETAILS_PRODUCT FOREIGN KEY (ProductID) REFERENCES PRODUCT(ProductID) ); CREATE TABLE PRODUCT ( ProductID NUMBER PRIMARY KEY, ProductName VARCHAR2(100), Description VARCHAR2(200), Price NUMBER, Category VARCHAR2(50) ); CREATE TABLE STORE ( StoreID NUMBER PRIMARY KEY, StoreName VARCHAR2(100), Location VARCHAR2(200), HoursOfOperation VARCHAR2(100) ); CREATE TABLE INVENTORY ( ProductID NUMBER, StoreID NUMBER, QuantityOnHand NUMBER, ReorderPoint NUMBER, PRIMARY KEY (ProductID, StoreID), CONSTRAINT FK_INVENTORY_PRODUCT FOREIGN KEY (ProductID) REFERENCES PRODUCT(ProductID), CONSTRAINT FK_INVENTORY_STORE FOREIGN KEY (StoreID) REFERENCES STORE(StoreID) ); CREATE TABLE "TRANSACTION" ( TransactionID NUMBER PRIMARY KEY, TransactionDate DATE, TransactionType VARCHAR2(20), TotalAmount NUMBER, CustomerID NUMBER, CONSTRAINT FK_TRANSACTION_CUSTOMER FOREIGN KEY (CustomerID) REFERENCES CUSTOMER(CustomerID) ); CREATE TABLE TRANSACTION_DETAILS ( TransactionDetailID NUMBER PRIMARY KEY, TransactionID NUMBER, ProductID NUMBER, ProductName VARCHAR2(100), Price NUMBER, Quantity NUMBER, Subtotal NUMBER, CONSTRAINT FK_TRANSACTION_DETAILS_TRANSACTION FOREIGN KEY (TransactionID) REFERENCES "TRANSACTION"(TransactionID), CONSTRAINT FK_TRANSACTION_DETAILS_PRODUCT FOREIGN KEY (ProductID) REFERENCES PRODUCT(ProductID) ); CREATE TABLE EMPLOYEE ( EmployeeID NUMBER PRIMARY KEY, Name VARCHAR2(100), Address VARCHAR2(200), Phone VARCHAR2(20), Email VARCHAR2(100), Position VARCHAR2(50) ); CREATE TABLE SALARY ( EmployeeID NUMBER, StartDate DATE, SalaryAmount NUMBER, EndDate DATE, PRIMARY KEY (EmployeeID, StartDate), CONSTRAINT FK_SALARY_EMPLOYEE FOREIGN KEY (EmployeeID) REFERENCES EMPLOYEE(EmployeeID) ); CREATE TABLE SHIFT ( ShiftID NUMBER PRIMARY KEY, StartTime TIMESTAMP, EndTime TIMESTAMP, StoreID NUMBER, EmployeeID NUMBER, CONSTRAINT FK_SHIFT_EMPLOYEE FOREIGN KEY (EmployeeID) REFERENCES EMPLOYEE(EmployeeID), CONSTRAINT FK_SHIFT_STORE FOREIGN KEY (StoreID) REFERENCES STORE(StoreID) ); CREATE TABLE REVIEW ( ReviewID NUMBER PRIMARY KEY, CustomerID NUMBER, ProductID NUMBER, ReviewText VARCHAR2(200), ReviewDate DATE, CONSTRAINT FK_REVIEW_CUSTOMER FOREIGN KEY (CustomerID) REFERENCES CUSTOMER(CustomerID), CONSTRAINT FK_REVIEW_PRODUCT FOREIGN KEY (ProductID) REFERENCES PRODUCT(ProductID) ); CREATE TABLE RATING ( RatingID NUMBER PRIMARY KEY, CustomerID NUMBER, ProductID NUMBER, RatingValue NUMBER, RatingDate DATE, CONSTRAINT FK_RATING_CUSTOMER FOREIGN KEY (CustomerID) REFERENCES CUSTOMER(CustomerID), CONSTRAINT FK_RATING_PRODUCT FOREIGN KEY (ProductID) REFERENCES PRODUCT(ProductID) );你能帮我给每个表插入至少十条数据不
最新发布
05-23
INSERT INTO TRANSACTION_DETAILS (TransactionDetailID, TransactionID, ProductID, ProductName, Price, Quantity, Subtotal) VALUES (3, 2, 3, 'Product C', 7.50, 1, 7.50); INSERT INTO TRANSACTION_DETAILS ...
oracle怎么查询每天的库存,Oracle是否有库存现有量报表
weixin_35735370的博客
04-03 457
SELECT dtl.organization_id,dtl.inventory_item_id,dtl.segment1,dtl.revision,dtl.subinventory_code,dtl.locator_id,dtl.lot_number,dtl.primary_uom_code,SUM(dtl.primary_transaction_quantity) primary_transa...
【转】INV模块常用表结构
AlexLiu_2019的博客
05-22 992
【转】INV模块常用表结构 INV模块常用表结构 表名：inv.mtl_system_items 说明： 物料主表 列名 类型 含义 ORGANIZATION_ID NUMBER 组织代码 INVENTORY_ITEM_ID NUMBER 项目内码 SEGMENT1 VARCHAR2(40) 项目编码（外码） UNIT_OF_ISSUE 单位 DESCRIPTION 项目说明 ALLOWED_UNITS_LOOKUP_CODE 可否单位换算 INVENTORY_ITEM_STATUS...
mtl_transactions_interface接口表错误代码
weixin_34380948的博客
02-25 469
错误信息1：mtl_transactions_interface,货位段无效 原因：mtl_transactions_interface.locator_id值不正确或为空，或其他异常情况   错误信息2：mtl_transactions_interface,|物料挑库发放和挑库确认流程完成时出现错误，|程序包 INV_Trolin_Util 过程 Query_Rows 中出现错...
物料常用表
11-14 1339
--任务物料需求发放表 SELECT *   FROM WIP_REQUIREMENT_OPERATIONS WRO   WHERE INVENTORY_ITEM_ID='1.1.11.0010' --任务物料需求发放视图 SELECT WROV.concatenated_segments--组件编码   FROM WIP_REQUIREMENT_OPERATIONS_V WROV 
详解EBS接口开发之WIP模块接口
weixin_30617737的博客
07-23 664
总体说明 文档目的 本文档针对WIP模块业务功能和接口进行分析和研究，对采用并发请求方式和调用API方式分别进行介绍 内容 WIP模块常用标准表简介 WIP事物处理组成 WIP相关业务流程 WIP相关API研究事例 （十）参考文档（七）采购相关的一些知识 （一）WIP模块常用标准表简介 1.1 常用标准表 ...
Oracle EBS-SQL (INV-3):检查仓库库存价值明细.sql
weixin_33857679的博客
06-09 204
SELECTa.subinventory_code 子库代码,d.DESCRIPTION 子库描述 ,b.segment1 物料编码...
EBS库存事务处理及分配数据拉取
kelly_yun的博客
11-16 1414
select mmt.transaction_id,---事务处理头id, mmt.organization_id,---事务处理库存组织， mmt.transaction_quantity,----事务处理头数量， mmt.transaction_cost，---事务处理头成本， mmt.inventory_item_id,---事务处理头物料id mtt.transaction_type_name,...
WIP 移动事务处理API Demo
chosen1brain的专栏
08-08 3018
DECLARE l_rec_move_txn wip_move_txn_interface%ROWTYPE; l_group_id NUMBER; l_txn_id NUMBER; l_available NUMBER; -- p_wip_entity_id NUMBER := 178160; p_organization_id NUMBE
mysql 事务 库存_库存事务处理临时表
weixin_39683598的博客
02-01 512
库存事务处理临时表 Mtl_material_transactions_temp批次事务处理临时表 mtl_transaction_lots_temp序列事务处理临时表 mtl_serial_numbers_tempü 表 Mtl_material_transactions_tempn allowed_units_lookup_code 默认值 3n...
oracle的存量,请教一个物料库存量查询的问题， 请进。
weixin_39866857的博客
04-03 517
其实这个需求还是比较简单的， 只是查询物料的库存量和成本信息， 具体sql如下。问题在于mtl_material_transactions、mtl_transaction_accounts这两张表中的数据量超大， 导致查询需要执行很长时间。如果可以使用mtl_onhand_quantities_detail替代mtl_material_transactions， 执行效率应该会有提升。 另外，...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值