随笔分类 -  Oracle EBS-SQL (QA)

Oracle EBS-SQL (QA-3):检查已检验未入库.sql
摘要：DEFINE RECE="%" SELECT rsh.receipt_num 收据号, pov.vendor_name 供应商名称, poh.segment1采购订单,decode(POH.AUTHORIZATION_STATUS,'APPROVED','已批准','IN PROCESS','过... 阅读全文

posted @ 2014-06-11 15:45 st.sun

Oracle EBS-SQL (QA-2):检查接收未检验.SQL
摘要：SELECT rsh.receipt_num 收据号, pov.vendor_name 供应商名称, poh.segment1采购订单, decode(POH.AUTHORIZATION_STATUS,'APPROVED','已批准','IN PROCESS','过程中','','未完成') 批准状... 阅读全文

posted @ 2014-06-11 15:34 st.sun

Oracle EBS-SQL (QA-1):检查超出检验周期的检验数据.sql
摘要：select msi.segment1 物料编码, msi.DESCRIPTION 物料描述, PER.LAST_NAME 采购员, MSI.FULL_LEAD_TIME 提前期, MSI.FIXED_ORDER_QUANTITY 固定订单数量, MSI.MINIMUM_ORDER_QUA... 阅读全文

posted @ 2014-06-11 15:26 st.sun

导航