select c.MISSIONARY_ID,c.RECEIPT_NO,c.SUPPORTER_ID,c.AMOUNT,d.DTYPE,

c.AMOUNT*d.DTPERCENT/100 as "DEDUCTION AMOUNT",(c.AMOUNT-c.AMOUNT*d.DTPERCENT/100) as "ACTUAL CONTRIBUTION AMOUNT",d.DTPERCENT as "DEDUCTION %"

from CONTRIBUTION c, DEDUCTION_TYPE d

where CONTRIBUTION_DATE between :P33_FROM AND :P33_TO 

AND NVL(c.DEDUCTION,0) = d.DTID 

Order BY MISSIONARY_ID ASC

 

 

,,,,,,,,,,,,,,,,,,,,,

 

select c.MISSIONARY_ID,c.RECEIPT_NO,c.SUPPORTER_ID,c.AMOUNT,d.DTYPE,

c.AMOUNT*d.DTPERCENT/100 as "DEDUCTION AMOUNT",(c.AMOUNT-c.AMOUNT*d.DTPERCENT/100) 

as "ACTUAL CONTRIBUTION AMOUNT",d.DTPERCENT as "DEDUCTION %"

from CONTRIBUTION c, DEDUCTION_TYPE d

WHERE :P33_YEAR = to_number(to_char(c.CONTRIBUTION_DATE,'YYYY')) 

AND :P33_MONTH = to_number(to_char(c.CONTRIBUTION_DATE,'MM'))

AND NVL(c.DEDUCTION,0) = d.DTID 

Order BY MISSIONARY_ID ASC

 

............ 

select c.MISSIONARY_ID,c.RECEIPT_NO,c.SUPPORTER_ID,c.AMOUNT,d.DTYPE,

c.AMOUNT*d.DTPERCENT/100 as "DEDUCTION AMOUNT",(c.AMOUNT-c.AMOUNT*d.DTPERCENT/100) as "SENT AMOUNT",d.DTPERCENT as "DEDUCTION %"

from CONTRIBUTION c, DEDUCTION_TYPE d

where CONTRIBUTION_DATE between :P33_FROM AND :P33_TO 

AND NVL(c.DEDUCTION,0) = d.DTID

AND :P33_DEDUCTION_TYPE = NVL(c.DEDUCTION,0)

Order BY MISSIONARY_ID ASC

 

>>>>>>>>>

select c.MISSIONARY_ID,c.RECEIPT_NO,c.SUPPORTER_ID,c.AMOUNT,d.DTYPE,

c.AMOUNT*d.DTPERCENT/100 as "DEDUCTION AMOUNT",(c.AMOUNT-c.AMOUNT*d.DTPERCENT/100) as "SENT AMOUNT",d.DTPERCENT as "DEDUCTION %"

from CONTRIBUTION c, DEDUCTION_TYPE d

WHERE :P33_YEAR = to_number(to_char(c.CONTRIBUTION_DATE,'YYYY')) 

AND :P33_MONTH = to_number(to_char(c.CONTRIBUTION_DATE,'MM'))

AND NVL(c.DEDUCTION,0) = d.DTID

AND :P33_DEDUCTION_TYPE2 = NVL(c.DEDUCTION,0)

Order BY MISSIONARY_ID ASC