ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '524567' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '524567' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '524567']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 524567 AND InstitucionPropia = 'S'
UNION
SELECT Adscripciones.Entidad FROM PublicacionesObras
JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion
JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado
WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 524567]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Sustainable Development Goals And Sustainable Supply Chains In The Post-Global Economy Título del capítulo: Streamlined Life Cycle Assessment for the Environmental Evaluation of Products in the Supply Chain
In this chapter, the use of streamlined life cycle assessment (LCA)
methods for the evaluation of supply chains are analysed in order to
reach SDG 12 (responsible production and consumption). In order to meet
the objective, a bibliographical review was performed; afterwards, those
cases that fulfilled the criteria were subject to a deeper analysis. The
relationship of supply chains in the context of SDG and streamlined LCA
was examined as well. The outcomes of the investigation are divided into
five sections, four of them are focused in different types of LCA that
aids in the communication of environmental aspects of products: (1) the
development of a full LCA, (2) different types of direct LCA such as
carbon and water footprint, (3) the use of environmental labelling and
(4) the use of streamlined LCA and computational tools to display and
support in the interpretations of results. In the fifth part of the
results section, a reflection on sustainable supply chains in the SDG
context is given. Based on this analysis, there are two notable
conclusions: streamlined LCA helps in the fulfilment of SDG in
organizations and furthermore, full LCA and streamlined LCA are
complementary to each other.
Entidades citadas de la UNAM:
Fuente:
ISBN: 9783030150662 Editorial: SPRINGER INTERNATIONAL PUBLISHING AG
