Procedimiento Almacenado

quien me podria ayudar con este store procedure, no se
que estoy haciendo mal...


SELECT A.comp_item_no, C.item_desc_1, C.PUR_OR_MFG,
C.item_desc_2, C.mat_cost_type, C.Prod_Cat,
(A.qty_per_par) AS Peso_Neto, A.SCRAP_FACTOR,
((A.qty_per_par*(A.SCRAP_FACTOR/100))+A.qty_per_par) as
Peso_Bruto , A.loc,
B.qty_on_hand, A.mfg_uom,
(if (SELECT item_no FROM PPCSTSTR_SQL WHERE
ITEM_NO=A.comp_item_no and vac_type='MAQ') <> null
BEGIN
isnull(((SELECT VAC_RATE FROM PPCSTSTR_SQL WHERE
ITEM_NO=A.comp_item_no and vac_type='MAQ') *
A.qty_per_par),0)
END
ELSE
BEGIN
EXEC SP_IR_BMITEMLEVEL2 A.comp_item_no
END) AS Maquila,
CostoProm= CASE C.pur_or_mfg
WHEN 'P' THEN (SELECT avg_cost FROM IMINVLOC_SQL
WHERE ITEM_NO=A.comp_item_no AND LOC='300')
WHEN 'M' THEN 0.00
END,
Costo= CASE C.pur_or_mfg
WHEN 'P' THEN (SELECT avg_cost FROM IMINVLOC_SQL
WHERE ITEM_NO=A.comp_item_no AND LOC='300')+(SELECT
VAC_RATE FROM PPCSTSTR_SQL WHERE ITEM_NO=A.comp_item_no
and vac_type='MAQ')
WHEN 'M' THEN 0.00
END
FROM BMPRDSTR_SQL A
INNER JOIN IMINVLOC_SQL AS B ON A.comp_item_no > B.item_no
INNER JOIN IMITMIDX_SQL AS C ON A.comp_item_no > C.item_no
WHERE A.item_no = 'P03M000100' AND B.loc=c.loc
AND A.activity_fg IN ('A','F')
ORDER BY A.item_no