Details
ChatLog
- UserQuestion
- Dame la lista de los componentes de MX01LIC01HP2AZL
- GeneratedSql
- SELECT NumeroParte, DescripcionParte, NivelBOM, BOMComponente, CantidadBOM, CostoUnitario, (CantidadBOM * CostoUnitario) AS CostoTotal FROM octavio.MasterNumeroParte WHERE NumeroProducto = 'MX01LIC01HP2AZL' AND NivelBOM > 0 ORDER BY NivelBOM, NumeroParte;
- ExecutionResult
- NumeroParte | DescripcionParte | NivelBOM | BOMComponente | CantidadBOM | CostoUnitario | CostoTotal ------------------------------------------------------------------------------------------------------- EMP002FN30120 | Empaque Final 3x12 cm | 0.10 | Empaque Final | 1.0000 | 5.9390 | 5.93900000 CAJ007SE70703 | Caja Dim. 70x20x30 | 0.20 | Caja Carton | 1.0000 | 3.3470 | 3.34700000 CAR025KA12001 | Carton Peso 12 kgs | 0.30 | Carton | 0.6010 | 2.4260 | 1.45802600 CIT023KA13001 | Cinta Adhesiv...
- Timestamp
- 10/20/2025 5:39:46 PM