摘要：销售订单要经历登记、发放、挑库、交货四个主要环节，有些表在各个环节都有不同的特性，作者罗列了几个主要的常用的表，其它好象还有些货物路线、停靠之类的信息表则没有涉及。下面是销售订单的四个主要环节和每个环节用到的常用表：一、登记1、oe_order_headers_all --订单头信息表2、oe_order_lines_all--header_id=oe_order_headers_all.header_id--订单行信息表3、mtl_sales_orders--segment1=oe_order_headers_all.order_number--sales_order_id=mtl_ma.. 阅读全文

摘要：--1.发票创建时生成数据如下表--发票主表SELECT * FROM AP_INVOICES_ALL A WHERE A.INVOICE_NUM = '20111213001';--发票分配表SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALL B WHERE B.INVOICE_ID = 697444;--发票付款计划表SELECT * FROM AP_PAYMENT_SCHEDULES_ALL C WHERE C.INVOICE_ID = 697444; --From ap_invoices_all.invoice_id--2.发票验证并创 阅读全文

摘要：ORACLE APPLICATIONS TECHNO-FUNCTIONAL CONSULTANThttp://techie2notice.weebly.com/index.htmlhttp://asktom.oracle.com/http://blogs.warwick.ac.uk/JAVA/tag/oracle/http://dev.fyicenter.com/faq/oracle/http://kevinclosson.wordpress.com/http://onlineappsdba.com/http://optimizermagic.blogspot.com/http://oracl 阅读全文