Hello there, friends! In this article, we’ll look at how to extract rfq data in Oracle Apps using a query. We’ll give the entire sql query that may be used to retrieve all of the rfq quotation data. We can get rfq related details from data base tables in Oracle apps using this sql query. Rfq details are stored in different tables in Oracle applications, hence this query is built using these numerous tables to retrieve the whole rfq related information in Oracle apps. We may create custom rfq reports in Oracle apps using this query. We’ll also go through the key tables that Oracle programmes use to hold RFQ information. The whole details regarding Query to retrieve rfq Details may be seen below.
Overview of Sourcing, RFQs, and Quotations
To meet your sourcing needs, Purchasing gives you with request for quotation (RFQ) and quotation tools. You can use requisitions to generate an RFQ, match supplier quotations to your RFQ, and replicate quotation information to purchase orders automatically. Purchasing offers comprehensive reporting to help you manage your quotation requests and assess supplier responses.
Important tables to get rfq Details in Oracle Apps R12
- PO RFQ Tables
- PO_RFQ_VENDORS
- Sales Order RFQ Tables
- ASO_QUOTE_HEADERS_ALL
- ASO_QUOTE_LINES_ALL
- ASO_SHIPMENTS
I-Sourcing RFQ Tables
- PON_AUCTION_HEADERS_ALL
- PON_BID_HEADERS
- PON_AUCTION_ITEM_PRICES_ALL
- PON_BID_ITEM_PRICES
Query to get PO RFQ Details in Oracle Apps R12
SELECT msi.segment1 “Purchasing Item”,
msi.description “Purchasing Item Description”, msi.primary_uom_code “Item UOM”,
poll.quantity “Ordr Quantity”,
poh.attribute1
|| ‘/’
|| poh.segment1 “RFQ #”,
TO_CHAR (TRUNC (poh.creation_date),’DD-MON-YYYY’) po_creation_date, aps.vendor_name “Supplier”,
apss.address_line1||’,’||apss.address_line2||’,’||apss.address_line3||’,’||apss.city||’,’||apss.zip “Supplier Address”
FROM po_headers_all poh,
po_lines_all pol,
po_line_locations_all poll,
mtl_system_items_b msi,
hr_operating_units hou,
po_rfq_vendors prv,
ap_suppliers aps,
ap_supplier_sites_all apss
WHERE pol.item_id = msi.inventory_item_id
AND aps.vendor_id = prv.vendor_id
AND apss.vendor_site_id = prv.vendor_site_id
AND poh.org_id = hou.organization_id
AND prv.po_header_id = poh.po_header_id
ANDpoh.type_lookup_code = ‘RFQ’
AND poh.po_header_id = pol.po_header_id
AND pol.po_line_id = poll.po_line_id
AND poll.ship_to_organization_id = msi.organization_id
Query to get SO Sales Order RFQ Details in Oracle Apps R12
SELECT ooh.order_number “Sales Order No”
,qte.quote_number
,qte.quote_name
,qtl.line_number “Quote Line No”
, msb.segment1 “Item Code”
, ool.ordered_quantity “Item Order Quantity”
, ool.order_quantity_uom “UOM”
FROM aso.aso_quote_headers_all qte
, aso.aso_quote_lines_all qtl
, aso.aso_shipments shp
, ont.oe_order_headers_all ooh
, ont.oe_order_lines_all ool msb
, mtl_system_items_b
WHERE ool.header_id = ooh.header_id
AND ool.source_document_line_Id = shp.shipment_id ;
AND qtl.quote_header_id = qte.quote_header_id
AND ool.inventory_item_id=MSB.inventory_item_id
AND msi.organization_id=:inv_org_id
AND shp.quote_header_id = qtl.quote_header_id
AND shp.quote_line_id = qtl.quote_line_id
AND qte.quote_number=:p_quote_number
AND ooh.source_document_id = qte.quote_header_id