CREATE OR ALTER PROCEDURE [dbo].[mob_plantillaListaChequeo] 
    @p_id_OT int 
AS
BEGIN
    
    SET NOCOUNT ON;

   SELECT CLA.id_atributo id
   ,CLA.cat_atributo_atributo as item
   ,SA.seccionAtributo as seccion
   ,CLA.cat_atributo_id_tipoAtributo as tipo
   ,dbo.f_opcionesAtributo(CLA.id_atributo,1) as IDsOpciones
   ,dbo.f_opcionesAtributo(CLA.id_atributo,0) as textosOpciones
   ,CLA.cat_atributo_esVariable as esVariable
   ,CLA.orden as orden
   ,CLA.id_pruebaCheckList as id_lista
   ,CLA.cat_atributo_esObligatorio as obligatorio
   ,CLA.cat_atributo_valorMinimo as  minimo
   ,CLA.cat_atributo_ValorMaximo as maximo
   ,UNI.unidad as unidad
   ,CLA.pruebaCheckList_atributo as vrDefecto
   ,dbo.esDependiente(CLA.id_atributo) as esDependiente
   ,CLA.cat_pruebaCheckList_pruebaCheckList as lista
   FROM view_cat_pruebaCheckList_atributo CLA
	   INNER JOIN cat_seccionAtributo SA on SA.id=CLA.cat_atributo_id_seccionAtributo
	   INNER JOIN gen_unidad UNI on UNI.id=CLA.cat_atributo_id_unidad
    WHERE 
        CLA.active = 1
        AND (CLA.id_pruebaCheckList IN (318) 
            OR CLA.id_pruebaCheckList IN (
                SELECT id_pruebaCheckList 
                FROM [doc_documento.ot_pruebaChecklist] 
                WHERE active = 1
                AND [id_documento.ot] = @p_id_OT
            )
        )
    ORDER BY 
        CLA.orden ASC;
END