Join between per_all_people_f and po_headers_all

Join between per_all_people_f and po_headers_all

In this post , we will be discuss about sql Table Join between per_all_people_f and po_headers_all tables. In oracle apps , Purchase Order Header Information's stores in the po_headers_all and Employee Header Information's stores in the per_all_people_f. These is also an join between both these tables which I will explain and share in this Post. Please find below the Join between per_all_people_f and po_headers_all

 

 

 

Important Columns for Join between per_all_people_f and po_headers_all

 

PER_ALL_PEOPLE_F  ==>  PERSON_ID

 

PO_HEADERS_ALL  ==>  AGENT_ID

 

These Two columns helps to join these two tables. Agent Id is the Buyer who is creating the PO for Purchase Goods from Suppliers.

 

SELECT PAPF.FULL_NAME BUYER_NAME
  FROM PER_ALL_PEOPLE_F PAPF,
       PO_HEADERS_ALL PHA
 WHERE PAPF.PERSON_ID = PHA.AGENT_ID
   AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
   AND PHA.SEGMENT1 =:P_PO_NUMBER