It appears that this query goes into an endless loop. Can someone please identify the error? The 4 tables referenced (CPADF_DT , CPACCDEF , CPARTY, CPDELACC) have less that 2000 records each.
--CP BANK ACCOUNT DEFAULTS
SELECT
CPARTY.NAME AS "COUNTERPAR TY" ,
CPACCDEF.TRANS_ TYPE AS "TRANSACTIO N TYPE",
CPACCDEF.SECTYP E AS "INSTRUMENT TYPE",
CPACCDEF.ENTITY AS "ENTITY",...