PO 在途
来源:互联网 发布:数据噪声是什么意思 编辑:程序博客网 时间:2024/05/17 09:44
SELECT MSIB.SEGMENT1 AA ,MSIB.DESCRIPTION BB ,MSIB.MIN_MINMAX_QUANTITY CC ,(SELECT SUM(MOQD.PRIMARY_TRANSACTION_QUANTITY) FROM INV.MTL_ONHAND_QUANTITIES_DETAIL MOQD WHERE 2 = 2 AND MSIB.ORGANIZATION_ID = MOQD.ORGANIZATION_ID AND MOQD.SUBINVENTORY_CODE = SUB_CODE AND MSIB.INVENTORY_ITEM_ID = MOQD.INVENTORY_ITEM_ID) DD ,NVL((SELECT SUM(MS.QUANTITY) FROM INV.MTL_SUPPLY MS ,PO.PO_REQUISITION_HEADERS_ALL PRH WHERE 2 = 2 AND MS.REQ_HEADER_ID = PRH.REQUISITION_HEADER_ID AND MS.CREATION_DATE > TO_DATE('2006/06/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS') AND MS.SUPPLY_TYPE_CODE = 'REQ' AND MSIB.ORGANIZATION_ID = MS.TO_ORGANIZATION_ID AND MS.ITEM_ID = MSIB.INVENTORY_ITEM_ID), 0) E1 ,NVL((SELECT SUM(MS.QUANTITY) FROM INV.MTL_SUPPLY MS ,PO.PO_HEADERS_ALL PRH WHERE 2 = 2 AND MS.CREATION_DATE > TO_DATE('2006/06/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS') AND MS.PO_HEADER_ID = PRH.PO_HEADER_ID AND MS.SUPPLY_TYPE_CODE = 'PO' AND MSIB.ORGANIZATION_ID = MS.TO_ORGANIZATION_ID AND MS.ITEM_ID = MSIB.INVENTORY_ITEM_ID), 0) E2 FROM INV.MTL_SYSTEM_ITEMS_B MSIB WHERE 2 = 2 AND MSIB.DESCRIPTION NOT LIKE '%加工费%' AND MSIB.DESCRIPTION NOT LIKE '%磨制费%' AND MSIB.DESCRIPTION NOT LIKE '%返磨费%' AND MSIB.DESCRIPTION NOT LIKE '%切断费%' AND MSIB.DESCRIPTION NOT LIKE '%加长费%' AND MSIB.DESCRIPTION NOT LIKE '%检定费%' AND MSIB.DESCRIPTION NOT LIKE '%维护费%' AND MSIB.INVENTORY_ITEM_STATUS_CODE = 'Active' AND MSIB.ORGANIZATION_ID = ORG_ID AND (SEGMENT1 LIKE SS4 OR SEGMENT1 LIKE SS3 OR SEGMENT1 LIKE SS2 OR SEGMENT1 LIKE SS1 OR SEGMENT1 LIKE 'C-T-%' OR SEGMENT1 LIKE 'T-%' OR SEGMENT1 LIKE 'F-T%' OR SEGMENT1 LIKE 'E-T%' OR SEGMENT1 LIKE 'E-F%') ORDER BY SEGMENT1;
- PO在途
- PO 在途
- 暂估与在途
- 一路美好,尽在途中
- Beyond三个人在途上(转)
- 怎样减少基金赎回在途时间
- SAP 在途库存与中转库存
- 黑马程序员_为你奔跑在途中
- 现有量,在途量,可用量,可保留量
- 朝着目标前进,怎么能在途中放弃
- po文档
- VO , PO
- PO Print
- 查未清PO
- PO表
- PO Tables
- po命令
- java PO DTO PO解释
- Java 马士兵 视频 网址
- 动态创建目录,文件
- 帕金森定律
- RTTI运行时对象识别
- map和set异同
- PO 在途
- 【Linux 0.11】IA-CPU
- Creating a PHP-Based Content Management System
- sicily 1443
- 关于张老师java视频的学习(十四)
- 如果男人真心欺骗,如果女人真心演戏,那么一切就是真的
- linux用户组操作文档
- 文件数据导入
- STL容器比较