SELECT

    A.CODIGO AS ID,
    FN_LPAD(A.CODIGO, 4, '0') AS DESC_ID,
    A.DESCRICAO,

    FN_TO_JSON_V2(
        FN_TO_PAR_JSON_V2('ID', B.CODIGO),
        FN_TO_PAR_JSON_V2('DESC_ID', FN_LPAD(B.CODIGO, 4, '0')),
        FN_TO_PAR_JSON_V2('DESCRICAO', B.CODIGO)
    ) AS LINHAS_JSON
    
FROM TBCENTRO_NEGOCIO_FAMILIA_LINHA T
INNER JOIN TBFAMILIA A ON A.CODIGO = T.FAMILIA_ID
LEFT JOIN TBMODELO_LINHA B ON B.CODIGO = T.LINHA_ID AND B.FAMILIA_CODIGO = A.CODIGO
WHERE T.CENTRO_NEGOCIO_ID = :CENTRO_NEGOCIO_ID