[Home] [Help]
VIEW: APPS.FII_COLLECTORS_V
Source
View Text - Preformatted
SELECT distinct arcol.collector_id, arcol.name FROM ar_collectors arcol, fii_collectors fiicol WHERE fiicol.collector_id = arcol.collector_id
View Text - HTML Formatted
SELECT DISTINCT ARCOL.COLLECTOR_ID
, ARCOL.NAME
FROM AR_COLLECTORS ARCOL
, FII_COLLECTORS FIICOL
WHERE FIICOL.COLLECTOR_ID = ARCOL.COLLECTOR_ID