Query to Get PO and Requisition details or Tables in Oracle Fusion Cloud - Orapoint

In this post we will discuss on how to get PO and Requisition details in Oracle Fusion Cloud Application, we will also show requisition and PO important table details which are used in the SQL query.

Important Requisition table in Oracle Fusion

po_requisition_headers_all: This table stores requisition header related information, this table stores some important information like PREPARER_ID, SEGMENT1 Requisition No , AUTHORIZATION_STATUS, TYPE_LOOKUP_CODE Requisition Type , Approved Date and Source.

po_requisition_lines_all : This table stores requisition line level information with certain columns like Item Id , Qty, Unit Price , Vendor ID.

po_req_distributions_all: This table stores requisition distribution level information, this table stores Accounting GL code for Requisition Lines.

Query to get Requisition to PO details in Oracle Fusion Cloud Application

This query will fetch link between requisition and PO details in Oracle Fusion Application

SELECT POH.PO_HEADER_ID,
       POH.SEGMENT1  ,
       PRHA.REQUISITION_NUMBER
FROM
       PO_HEADERS_ALL POH,
       PO_DISTRIBUTIONS_ALL PDA ,
       POR_REQ_DISTRIBUTIONS_ALL PRDA ,
       POR_REQUISITION_LINES_ALL PRLA ,
       POR_REQUISITION_HEADERS_ALL PRHA
WHERE  1=1
   AND POH.PO_HEADER_ID = PDA.PO_HEADER_ID
   AND PDA.REQ_DISTRIBUTION_ID = PRDA.DISTRIBUTION_ID
   AND PRDA.REQUISITION_LINE_ID = PRLA.REQUISITION_LINE_ID
   AND PRLA.REQUISITION_HEADER_ID = PRHA.REQUISITION_HEADER_ID
   AND PRHA.REQUISITION_NUMBER = :P_Req_Num;