ERP PO Module
-
编辑 删除
Oracle EBS:PO 常用的查询及Tips
原文:PO: Tips and useful Query作者:Sanjit Anand来源:http://www.oracleappshub.com/oracle-purchasing/po-tips-and-useful-query/http://www.dezai.cn/blog/article.asp?id=3041.列出没有销售订单的内部采购订单 程序代码 ---used to list all Internal Requisitions that do not have an associated Internal Sales orderSelect RQH.SEGMENT1 REQ_NUM,RQL.LINE_NUM,RQL.REQUISITION_HEADER_ID ,RQL.REQUISITION_LINE_ID,RQL.ITEM_ID ,RQL.UNIT_MEAS_LOOKUP_CODE ,RQL.UNIT_PRICE ,RQL.QUANTITY ,RQL.QUANTITY_CANCELLED,RQL.QUA
