2013年4月3日
SQL queries to get Requisition, PO and PO Receipt details
摘要： I had to provide data to auditors on theInternal & Purchase Requisitions created by usersPurchase Orders created for the requisitions (inventory and non inventory items)Receiving transactions with PO and Requisition informationI have given the queries here as could be useful. All data has been t 阅读全文
posted @ 2013-04-03 13:46 PPTNotes 阅读(912) 评论(0) 推荐(0)
Useful queries/code/scripts in Oracle Apps Order Management
摘要： Following are some of the most frequently used queries in oracle apps order management:Order header infoSelect * from oe_order_headers_all ooh where order_number= :p_order_number Operating unit info select * from hr_operating_units where organization_id=oe_order_headers_all.org_id Order type infose. 阅读全文
posted @ 2013-04-03 13:43 PPTNotes 阅读(2107) 评论(0) 推荐(0)