How to create a valueset of type 'TABLE' with two or more tables?

We are trying to create a valueset of type 'TABLE' with two or more tables, but the logic written in WHERE clause is not working.

Sample Query:

SELECT
DISTINCT PS.ATTRIBUTE1
FROM
POZ_SUPPLIERS PS
,AP_INVOICES_ALL AIA
,AP_INVOICE_DISTRIBUTIONS_ALL AIDA
WHERE
1=1
AND PS.VENDOR_ID = AIA.VENDOR_ID
AND AIA.INVOICE_ID = AIDA.INVOICE_ID
AND (AIDA.DEF_ACCTG_START_DATE IS NOT NULL OR AIDA.ASSETS_TRACKING_FLAG ='Y')