你好,游客 登录 注册 搜索
背景:
阅读新闻

QUANTITY_DETAILED,QUANTITY_DELIVERED in MTL_TXN_REQUEST_LINES - PTIAN ORACLE EBS REPOSITORY

[日期:2013-04-22] 来源:  作者: [字体: ]

QUANTITY_DETAILED:Allocated Quantity.
QUANTITY_DELIVERED:Final Transacted Quantity.


1. Create move order:

Quantity: 10
Quantity Delivered: NULL
Quantity Detailed: NULL
Quantity Required: NULL
Line Status: 1 (Incomplete)

2. Approve move order:
Quantity: 10
Quantity Delivered: NULL
Quantity Detailed: NULL
Quantity Required: NULL
Line Status: 3 (Approved)

3. Allocate move order for full quantity:
Quantity: 10
Quantity Delivered: NULL
Quantity Detailed: 10
Quantity Required: NULL
Line Status: 3 (Approved)

4. Transact move order:
Quantity: 10
Quantity Delivered: 10
Quantity Detailed: 10
Quantity Required: NULL
Line Status: 5 (Closed)

ps:SQL to query
SELECT quantity, quantity_delivered, quantity_detailed, required_quantity, line_status
FROM mtl_txn_request_lines
WHERE line_id = &enterlineid;




收藏 推荐 打印 | 录入:admin | 阅读:
相关新闻