Sorry below is the code regarding show zero amount in pass thru query.

SELECT DISTINCT
ASODTANNA.ASOSHHM.SHSHPM, ASODTANNA.ASOSHHM.SHSHPY, ASODTANNA.ASOSHHM.SHTXCS AS State,
SUM(CASE WHEN ASODTANNA.ASOSHDM.SDSHPQ * AICDTANNA.AICITMM.ITAVGC IS NULL THEN 0 ELSE ASODTANNA.ASOSHDM.SDSHPQ * AICDTANNA.AICITMM.ITAVGC END) AS Cost
FROM ASODTANNA.ASOSHHM, ASODTANNA.ASOSHDM, AICDTANNA.AICITMM
WHERE ASODTANNA.ASOSHHM.SHSHPM = ASODTANNA.ASOSHDM.SDSHPM AND ASODTANNA.ASOSHHM.SHSHPY = ASODTANNA.ASOSHDM.SDSHPY AND
ASODTANNA.ASOSHHM.SHSON = ASODTANNA.ASOSHDM.SDSON AND ASODTANNA.ASOSHHM.SHSHPN = ASODTANNA.ASOSHDM.SDSHPN AND
ASODTANNA.ASOSHDM.SDICH = AICDTANNA.AICITMM.ITITM AND (ASODTANNA.ASOSHHM.SHPSTF = 'Y') AND (ASODTANNA.ASOSHHM.SHSHPM = '04') AND (ASODTANNA.ASOSHHM.SHSHPY = '2014') AND
(ASODTANNA.ASOSHHM.SHTXCS = 'CA') AND (ASODTANNA.ASOSHDM.SDUNTR = 0) AND (ASODTANNA.ASOSHDM.SDSHPQ > 0) AND (AICDTANNA.AICITMM.ITITM IN ('05119', '05121', '05122', '05123', '05124',
'05125', '05127', '05128', '05130', '05131', '05132', '05134', '05135', '05136', '05137', '05141', '05144', '05393', '05886', '06712'))
GROUP BY ASODTANNA.ASOSHHM.SHSHPM, ASODTANNA.ASOSHHM.SHSHPY, ASODTANNA.ASOSHHM.SHTXCS, ASODTANNA.ASOSHDM.SDUNTR, AICDTANNA.AICITMM.ITITM, ASODTANNA.ASOSHDM.SDSHPQ