Search from 700 + Posts

Dec 19, 2010

Data Flow and Query to connects Oracle Order Management and Purchasing tables for B2B Order

Often customers order products that you do not typically stock but that you do not manufacture either. You may want to purchase that item specifically for this order, have the supplier ship it to you, and then combine it with other items you may have purchased or stocked to create one shipment to the customer. This is a common scenario for Wholesale Distributors who use the S3 (Sell-Source-Ship) business model as well as for other demand channels. We call this process ‘back-to-back orders’ or ‘procure-to-order’.

Data flow for a Simple B2B(Back to Back Order ) in Oracle Order  Management-


.


Keys to making this business process work are automating the Purchasing document creation, having accurate status of where the line is in the process, and pegging (or hard reservation) of the supply to the demand, so that the inventory isn’t shipped to other customers once it is received.
 
Workflow for B2B Order line in Oracle Applications

Queries to Connect Sales Order and Requistion Interface tables for Back to Back Order

select ool.line_id, ool.flow_status_code , ool.open_flag,pri.interface_source_code,pri.interface_source_line_id,
pri.note_to_buyer,pri.note_to_receiver
from
oe_order_lines_all ool,
po_requisitions_interface_all pri
where ool.line_id = pri.interface_source_line_id
and pri.interface_source_code='CTO'


Queries to Connect Sales Order and Purchase Order tables for Back to Back Order

select ph.segment1,a. supply_source_line_id, a.supply_source_header_id
from mtl_reservations a, oe_order_lines_all ool, po_headers_all ph
where ool.line_id = a.demand_source_line_id
and a.supply_source_header_id = ph.po_header_id

Queries to Connect Sales Order and Requistion tables for Back to Back Order

select pqh.segment1,a. supply_source_line_id, a.supply_source_header_id
from mtl_reservations a, oe_order_lines_all ool, po_requisition_headers_all pqh
where ool.line_id = a.demand_source_line_id
and a.supply_source_header_id = pqh.requisition_header_id



No comments:

Post a Comment