摘要：
[代码]selectacct_period_idperiod,open_flag,period_namename,period_start_date,schedule_close_date,period_close_datefromorg_acct_periodswhereorganization_id=&org_idorderby1,2;updateorg_acct_periodssetopen_flag='Y',period_close_date=null,summarized_flag='N'whereorganization_id=&&org_idandacct_period_id= 阅读全文
摘要：
[代码] 阅读全文
摘要：
[代码] 阅读全文
摘要：
The consultant life while working at client site is not easy during ERP transformation projects, many times it’s required toprovide some adhoc query for extract to ends users, therefore it is important to have a cheat sheet so that such untimely things can be easily handled in sort span. Hope the 阅读全文
摘要：
[代码] 阅读全文
摘要：
select aia.invoice_num, aila.line_number, aia.invoice_id, pha.segment1 po_number, pv.vendor_name, pv.segment1 supplier_num, pha.currency_code, pla.line_num, plla.shipment_num, pla.item_description, pla.unit_price, plla.quantity, plla.quantity_received, plla.quantity_billed, rt.transact 阅读全文
摘要：
[代码] 阅读全文
摘要：
[代码] 阅读全文
摘要：
销售订单要经历登记、发放、挑库、交货四个主要环节，有些表在各个环节都有不同的特性，作者罗列了几个主要的常用的表，其它好象还有些货物路线、停靠之类的信息表则没有涉及。下面是销售订单的四个主要环节和每个环节用到的常用表：一、登记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_... 阅读全文
摘要：
select object_name, lmode, sid session_id, decode(type, 'MR', 'Media Recovery', 'RT', 'Redo Thread', 'UN', 'User Name', 'TX', 'Transaction', 'TM', 'DML', 'UL', 'PL/SQL User Lock', 'DX', 'Distributed Xaction', 'CF', 'Control File', 'IS', 'Instance State', 'FS', 'File Set', 'IR', 'Instance Recovery 阅读全文