7 Most Important Requisition tables in Oracle Fusion

PO Requisition Tables in Oracle Fusion

Hi friends , we are going to discuss about the requisition table in oracle fusion. We will share some of the most important PO requisition tables which helps to store the complete PO requisition information's in oracle fusion. These Requisition tables are very important if we need to extract the PO requisition data from backend in oracle fusion. In this post , we will also try to share some of the important sql queries too which helps you extract the requisition information's in oracle fusion. Using these requisition tables we can develop the custom Oracle BIP reports in oracle fusion. Please find below the complete details about requisition table in oracle fusion.

7 Most Important Requisition tables in Oracle Fusion

7 Most Important requisition table in oracle fusion

Here below is the list of po requisition tables which helps to store the requisition information's in oracle fusion. 

1.POR_REQ_DISTRIBUTIONS_ALL

2.POR_REQUISITION_LINES_ALL

3.POR_REQUISITION_HEADERS_ALL

4.POZ_SUPPLIERS

5.POZ_SUPPLIER_SITES_ALL_M

Detail SQL Query to extract the PO Requisitions information's in oracle fusion

Here below is the detail sql query which you can use to extract the PO requisition information's in oracle fusion. We are using the PO requisition tables in this below detail sql query to develop this complete query. This is one of the most important sql query related to PO requisition which we commonly uses in the procurement module.

SELECT POH.PO_HEADER_ID "PO Id",

       POH.SEGMENT1 " PO Number"  ,

       PRHA.REQUISITION_NUMBER,

PRHA.REQUISITION_HEADER_ID " PO Requisiton ID"

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 PRHA.REQUISITION_NUMBER = '445566'

   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

7 Most Important Requisition tables in Oracle Fusion