Post date: Jan 21, 2020 6:16:27 AM
Select * from PO_Vendors
Select * from PO_Vendor_Sites_All
select a.VENDOR_ID,a.VENDOR_NAME,b.VENDOR_SITE_CODE,b.ACCTS_PAY_CODE_COMBINATION_ID,b.PREPAY_CODE_COMBINATION_ID
from PO_Vendors a,PO_Vendor_Sites_All b
where a.VENDOR_ID=b.VENDOR_ID
=======================================================
Berdasarkan Org ID
Select * from PO_Vendors
Select * from PO_Vendor_Sites_All
select * from hr_organization_units
select a.VENDOR_ID,a.VENDOR_NAME,b.VENDOR_SITE_CODE,b.ACCTS_PAY_CODE_COMBINATION_ID,b.PREPAY_CODE_COMBINATION_ID,b.ORG_ID,c.NAME
from PO_Vendors a,PO_Vendor_Sites_All b,hr_organization_units c
where a.VENDOR_ID=b.VENDOR_ID
and c.ORGANIZATION_ID=b.ORG_ID
and b.ORG_ID = '84'