SAP B1 -Mal Çıkış Belgesinde masraf yerleri seçili olsun kontrolü

IF :object_type = '60' AND :transaction_type IN ( 'U','A')

then

select count(*) into cnt

FROM OIGE T0 INNER JOIN IGE1 T1 ON T0."DocEntry" =T1."DocEntry"

WHERE

(T1."OcrCode" is null or T1."OcrCode" ='') and (T1."OcrCode2" is null or T1."OcrCode2" ='') and

T1."BaseType" <> '202'

AND T0."DocEntry" =:list_of_cols_val_tab_del;

if :cnt > 0 then

error := -111;

error_message := N'[HATA 21-01] Mal Çıkış Belgesinde masraf yerleri zorunludur.';

END if;

END if;