1. What is a Purchase Requisition and define various
requisitions
It is a formal request intended to procure/buy something that is
needed by the organization. It is created and approved...
Thursday, July 3, 2014
Order Management Interview Questions Part 2
1. What are the various order management processes supported by oracle OM
Standard orders: This method supports Make to Stock business model where the products are made and kept in stock. The products...
Tuesday, July 1, 2014
SQL query to find out Drop Ship Sales Order, Line, Requisition and Purchase order
select h.order_number,l.line_number SO_Line_number, ph.segment1
PO_Number,pl.line_num PO_Line_Number,
ph.authorization_status,ph.closed_date,ph.closed_code,
prh.interface_source_code,
prh.segment1...
SQL Query to find sales order lines whose workflow is Purged
Select Line_Id, flow_status_code,ordered_quantity,shipped_quantity, fulfilled_flag, invoice_interface_status_code
From Oe_Order_Lines_All l
where open_flag = 'Y'
And not Exists
(Select 1 From Wf_Items...
Subscribe to:
Posts (Atom)