Select RECEIPT_NO,MISSIONARY_ID,SUPPORTER_ID,CONTRIBUTION_DATE,AMOUNT,

(select t.CONTRIBUTION_TYPE_NAME from CONTRIBUTION_TYPE t where t.CONTRIBUTION_TYPE_ID = c.TYPE ) as "CONTRIBUTION TYPE" from Contribution c

where :P19_DATE = CONTRIBUTION_DATE