SELECT DISTINCT CARD.CARD_ID
, ICC.MASKED_CC_NUMBER
, EMP.FULL_NAME
, CARD_PROG.CARD_PROGRAM_NAME
, CARD.ORG_ID
FROM AP_CARDS_ALL CARD
, AP_CARD_PROGRAMS_ALL CARD_PROG
, PER_EMPLOYEES_X EMP
, IBY_CREDITCARD ICC
WHERE CARD.CARD_PROGRAM_ID = CARD_PROG.CARD_PROGRAM_ID
AND CARD.EMPLOYEE_ID = EMP.EMPLOYEE_ID
AND CARD.CARD_REFERENCE_ID = ICC.INSTRID