CREATE TABLE FLATBED.TMP3_FINAN_COST_CENTER
(
COMPANY_CODE VARCHAR2(2 BYTE)
);

CREATE TABLE FLATBED.TMP3_ORGANIZATIONS
(
COMPANY_CODE CHAR(2 BYTE)
);

BEGIN
INSERT INTO flatbed.TMP3_FINAN_COST_CENTER (COMPANY_CODE)
SELECT '00' AS COMPANY_CODE FROM DUAL;
COMMIT;
END;

BEGIN
INSERT INTO flatbed.tmp3_ORGANIZATIONS(COMPANY_CODE)
SELECT 'ZZ' AS COMPANY_CODE FROM DUAL;
COMMIT;
END;

select 1 AS T1
from flatbed.tmp3_ORGANIZATIONS org1,
flatbed.TMP3_FINAN_COST_CENTER fin1
where
fin1.COMPANY_CODE = '00'
AND org1.COMPANY_CODE = 'ZZ'
and
fin1.COMPANY_CODE =
CASE
WHEN (SELECT COUNT(*)
FROM flatbed.TMP3_FINAN_COST_CENTER this2
WHERE this2.COMPANY_CODE=org1.COMPANY_CODE)>0
THEN org1.COMPANY_CODE
ELSE '00'
END
AND ROWNUM = 1