PO and Quotations in Oracle Apps R12 - Session 3

Overview

Purchasing provides you with request for quotation (RFQ), and quotation features to handle your sourcing needs. You can create an RFQ from requisitions, match supplier quotations to your RFQ, and automatically copy quotation information to purchase orders. Purchasing provides complete reporting to control your requests for quotations and evaluate supplier responses.

R12 Oracle E-Business Suite: Oracle Procurement Process: RFQ's and Quotations

RFQs and Quotations

A request for quotation (RFQ) is sent to a supplier to request pricing and other information for an item or items. A quotation is the supplier's response to that RFQ. Some examples of how you send an RFQ to a supplier include creating an RFQ in the RFQs window and sending it by facsimile, making a phone call, or using Oracle iSupplier Portal. One way a supplier can send a quotation, whether or not in response to an RFQ, is through the Purchasing Documents Open Interface. (See: Receiving Price/Sales Catalog Information Electronically.) If you don't receive quotations electronically from your supplier, you can create the quotation manually using the Quotations window, or copy the quotation from an RFQ. (See: Copying Quotations from RFQs.)

PO and Quotations in Oracle Apps R12

How to Create a Standard RFQ in ORACLE APPS R12

SELECT  rh.segment1 REQ_NUM,  
       rl.requisition_line_id,  
       rl.requisition_header_id,  
       ph.segment1 RFQ_NUM,  
       pl.po_header_id,  
       pl.po_line_id  
   FROM  po_requisition_headers_all rh,  
       po_requisition_lines_all rl,  
       po_headers_all ph,  
       po_lines_all pl  
   WHERE    rh.requisition_header_id = rl.requisition_header_id  
       AND rl.last_update_date = pl.creation_date  
       AND pl.po_header_id = ph.po_header_id  
       AND rl.on_rfq_flag = 'Y'  
 ORDER BY  requisition_line_id DESC;  

Via - https://youtube.com/playlist?list=PL274YJ3ipjef5pvBUy0uxaVqaQPhYMoiM

Read More