Link between ap_suppliers and per_all_people_f

Link between ap_suppliers and per_all_people_f

Here we will be discuss about Link between ap_suppliers and per_all_people_f. These two tables related to the Supplier and Employees. In Oracle We can create Employees as a supplier so in this post , we will be try to find the link between  ap_suppliers and per_all_people_f tables to find out the information's of the Oracle supplier who are employee too in the System. Please find below the complete Join and Link  between ap_suppliers and per_all_people_f.

 

 

 

Columns Join/link  Between ap_suppliers and per_all_people_f

 

AP_SUPPLIERS ==> EMPLOYEE_ID

PER_ALL_PEOPLE_F ==> PERSON_IID

SQL Query Using Link between ap_suppliers and per_all_people_f

 

SELECT VENDOR_NAME "SUPPLIER NAME",

ASS.SEGMENT1 "SUPPLIER NUMBER",

PAPF.EMPLOYEE_NUMBER "EMPLOYEE NUMBER",

PAPF.FULL_NAME "EMPLOYEE NAME",

PAPF.EMAIL_ADDRESS "EMPLOYEE EMAIL ADDRESS"

 FROM AP_SUPPLIERS ASS,PER_ALL_PEOPLE_F PAPF

WHERE ASS.VENDOR_ID IN (SELECT VENDOR_ID FROM AP_SUPPLIER_SITES_ALL

WHERE ORG_ID=:P_ORG_ID)

AND ASS.SEGMENT1=:P_VENDOR_NUMBER

AND ASS.EMPLOYEE_ID=PAPF.PERSON_ID

AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE