SUBITEM SUBITEM DESCRIPTION FECHA   TOTAL   Linea   Arearesponsable Area de Uso PLANNER NAME    ITEMTYPE    SurtimientoKitKBHeijunka    Warehouse
01-0215/01  STEM,SS,5/32 BARB FOR 1/4 NUT   22/08/2016  1   CED Almacen Compresores Hernandez, Nancy  - Delta, 500, 1500    PUR Heijunka    085
01-0215/01  STEM,SS,5/32 BARB FOR 1/4 NUT   22/08/2016  1   CED Almacen Compresores Hernandez, Nancy  - Delta, 500, 1500    PUR Heijunka    085

SUBITEM SUBITEM DESCRIPTION FECHA   TOTAL   7AM 8AM 9AM 10AM    11AM    12PM    1PM 2PM 3PM 4PM 5PM PLANNER NAME    ITEMTYPE
01-0215/01  STEM,SS,5/32 BARB FOR 1/4 NUT   22/08/2016  1   0   0   0   0   0   1   0   0   0   0   0   Hernandez, Nancy  - Delta, 500, 1500    PUR

SELECT subitem, subitemDescription, fecha, Max(TOTAL), Linea, Arearesponsable, Areauso, PlannerName, ItemType, Surtimiento, Warehouse
FROM (
SELECT
b.SUBITEM as subitem, b.[SUBITEM DESCRIPTION] as subitemDescription, p.FECHA as fecha, Sum(p.CANTIDAD*b.[BUILD REQ]) AS TOTAL,  pf.Linea as Linea, pf.Arearesponsable as Arearesponsable, pf.[Area de Uso] as AreaUso, b.[PLANNER NAME] as PlannerName, b.ITEMTYPE as ItemType, pf.SurtimientoKitKBHeijunka as Surtimiento, oh.Warehouse as Warehouse
FROM
((((PROGRAMA p LEFT JOIN TB_BOM b ON PROGRAMA.ITEM=TB_BOM.BOM)
LEFT JOIN TB_PFEP pf ON TB_BOM.SUBITEM=TB_PFEP.[Numero de Parte])
LEFT JOIN TB_KB kb ON TB_PFEP.[Numero de Parte]=TB_KB.[Item number])
LEFT JOIN TB_ONHAND oh ON TB_BOM.SUBITEM=TB_ONHAND.[Item number])

GROUP BY
b.subitem, b.[SUBITEM DESCRIPTION], p.FECHA, pf.Linea, pf.Arearesponsable, pf.[Area de Uso], b.[PLANNER NAME], b.ITEMTYPE, pf.SurtimientoKitKBHeijunka, oh.Warehouse
)
WHERE p.FECHA=[Buscar requerimento de material de la fecha: (mm/dd/aaaa)] AND oh.Warehouse="085"

GROUP BY subitem, subitemDescription, fecha, Linea, Arearesponsable, Areauso, PlannerName, ItemType, Surtimiento, Warehouse;