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 = '519016' 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 = '519016' 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 = '519016']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 519016 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= 519016]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Xii Congreso De Ingenieria Del Transporte Título del capítulo: Corporative Trends in Urban Distribution of Goods in Mexico City
Autores UNAM: JUAN PABLO ANTUN CALLABA;
Autores externos: Idioma: Año de publicación: 2016Palabras clave:
Logistics; supply chain; urban distribution of goods; urban freight
Resumen:
The Logistics processes in urban-metropolitan distribution are
constantly changing, both technological support and technical
implementation in the processes themselves and in the management of
these. It is necessary to monitor the substantive changes outlined in
the metropolitan urban-physical distribution of goods, because they
contribute to a better competitive position of companies in the market,
and also to a better development of city life. It is a professional
scientific and technical task that contributes, by its impact on
``benchmarking'', the improvement of engineering practices in the
professional community of executives in logistics and supply chains.
Based on three extensive field research (ANTUN, JP; LOZANO, A;
HERNANDEZ, R; ALARCON, R et al 2007; ANTUN, JP; LOZANO, A; MAGALLANES,
R; ALARCON, R; GRANADOS, F 2009, ANTUN JP ALARCON R; 2014) on Logistics
Distribution of Goods in Mexico City, this article presents and
discusses major corporate trends on a set of key logistics processes,
and bring examples from Case Studies.
