CREATE trigger ttbconsumo_requisicao_pai_b01d for tbconsumo_requisicao_pai
active before delete position 1
AS
BEGIN
    
    DELETE FROM TBCONSUMO_REQUISICAO T WHERE T.CONSUMO_REQUISICAO_PAI_ID = OLD.ID;

END;

COMMENT ON TRIGGER TTBCONSUMO_REQUISICAO_PAI_B01D IS 'EXCLUIR ITENS DA REQUISICAO';