Details

ChatLog


UserQuestion
Dame la lista de los Productos finales y su numero de parte?
GeneratedSql
SELECT mp.NumeroProducto, mnp.NumeroParte FROM octavio.MaestroProductos AS mp JOIN octavio.MasterNumeroParte AS mnp ON mp.NumeroProducto = mnp.NumeroProducto WHERE mp.NivelBOM = 0.00 ORDER BY mp.NumeroProducto, mnp.NumeroParte;
ExecutionResult
NumeroProducto | NumeroParte ------------------------------- MX01LIC01HP2AZL | ACE002KA78352 MX01LIC01HP2AZL | ALA002KA89120 MX01LIC01HP2AZL | ALA002KA89222 MX01LIC01HP2AZL | CAB002KA89456 MX01LIC01HP2AZL | CAC001SE91953 MX01LIC01HP2AZL | CAC002KA91754 MX01LIC01HP2AZL | CAJ007SE70703 MX01LIC01HP2AZL | CAR025KA12001 MX01LIC01HP2AZL | CIT023KA13001 MX01LIC01HP2AZL | EMP002FN30120 MX01LIC01HP2AZL | EST001SE71804 MX01LIC01HP2AZL | FLE001SE71706 MX01LIC01HP2AZL | FLE002SE89111 MX01LIC0...
Timestamp
10/20/2025 6:05:04 PM
Edit | Back to List