PHP - CHECKBOX

DECODE('".$valueCustomer."',

              'EXT',

              'CUM',

              'CUM',

              'EF',

              'CV',

              'EF',

              'LAM',

              'CUMT',

              'CUMT',

              'EF') AS OPT1,

       DECODE('".$valueCustomer."', 'CUM', 'E.COM', 'CV', 'E.COM', 'CUMT', 'E.COM') AS OPT2,

    DECODE('".$valueCustomer."', 'CUM', 'EXT', 'CV', ' ', 'CUMT', 'LAM') AS OPT3

echo"<td><input  name='option01'  type='checkbox'/>".$fila['OPT1'];

echo"</br>";

echo"<input  name='option02' type='checkbox'  >".$fila['OPT2'];

echo"</br>";

echo"<input name='option03' type='checkbox' >".$fila['OPT3'];

$p1 = '';

$p2 = '';

$p3 = $valueCustomer; //Departamento de salida de material 

$p4 = ' '; // Departamento de entrada de material aqui es en donde ira el parametro del check box 

$p5 = ''; //lOC_CODE

$p6 = $valueInqPart;//Numero de parte

$p7 = ' ';//LOT_CODE 

$p8 = $valueIssQty; //Cantidad de salida 

$p9 =' ';//Usurio ingresado en el sistema para el registratr poner el del login 

SELECT parts_code AS PARTS_CODE,

       (parts_nm) AS PARTS_NM,

       (parts_descr) AS PARTS_DESCR,

       (loc_code) AS LOC_CODE,

       (lot_code) AS LOT_CODE,

       (stock_qty) AS STOCK_QTY,

       DECODE('".$valueCustomer."',

              'EXT',

              'CUM',

              'CUM',

              'EF',

              'CV',

              'EF',

              'LAM',

              'CUMT',

              'CUMT',

              'EF') AS OPT1,

       DECODE('".$valueCustomer."', 'CUM', 'E.COM', 'CV', 'E.COM', 'CUMT', 'E.COM') AS OPT2,

    DECODE('".$valueCustomer."', 'CUM', 'EXT', 'CV', ' ', 'CUMT', 'LAM') AS OPT3

  from (select a.parts_code  as parts_code,

               b.parts_nm    as parts_nm,

               b.parts_descr as parts_descr,

               a.wh_code     as loc_code,

               a.rack_lot    as lot_code,

               a.stok_qty    as stock_qty

          from tmidstok a, tmimmatl b

         where (a.parts_code like 'FM%' or a.parts_code like 'MV%')

           and a.wh_code like 'M-%'

           and a.wh_code <> 'M-000-Z'

           and a.wh_code NOT IN ('M-000-Z','M-000-Y','TOT-U')

           and b.parts_code = a.parts_code

           and b.corp_code = a.corp_code

           and b.fctry_code = a.fctry_code

           and a.parts_code like '".$valueInqPart."' || '%'

           and a.corp_code = 'PTM'

           and a.fctry_code = 'MX'

           and '".$valueCustomer."'= 'EXT'

        UNION ALL

        select a.parts_code  as parts_code,

               b.parts_nm    as parts_nm,

               b.parts_descr as parts_descr,

               a.wh_code     as loc_code,

               a.rack_lot    as lot_code,

               a.stok_qty    as stock_qty

          from tmidstok a, tmimmatl b

         where (a.parts_code like 'MB%')

           and a.wh_code  = 'T-000-X'

           and b.parts_code = a.parts_code

           and b.corp_code = a.corp_code

           and b.fctry_code = a.fctry_code

           and a.parts_code like '".$valueInqPart."'|| '%'

           and a.corp_code = 'PTM'

           and a.fctry_code = 'MX'

           and '".$valueCustomer."'= 'LAM'

        UNION ALL

        select a.parts_code  as parts_code,

               b.parts_nm    as parts_nm,

               b.parts_descr as parts_descr,

               a.wh_code     as loc_code,

               a.rack_lot    as lot_code,

               a.stok_qty    as stock_qty

          from tmidstok a, tmimmatl b

         where (a.parts_code like 'MB%')

           and a.wh_code = 'T-000-Y'

           and b.parts_code = a.parts_code

           and b.corp_code = a.corp_code

           and b.fctry_code = a.fctry_code

           and a.parts_code like '".$valueInqPart."'|| '%'

           and a.corp_code = 'PTM'

           and a.fctry_code = 'MX'

           and '".$valueCustomer."'= 'CUMT'

        UNION ALL

        select a.parts_code  as parts_code,

               b.parts_nm    as parts_nm,

               b.parts_descr as parts_descr,

               a.wh_code     as loc_code,

               a.rack_lot    as lot_code,

               a.stok_qty    as stock_qty

          from tmidstok a, tmimmatl b

         where (a.parts_code like 'FM%' or a.parts_code like 'MV%')

           and a.wh_code  = 'M-000-Y'

           and b.parts_code = a.parts_code

           and b.corp_code = a.corp_code

           and b.fctry_code = a.fctry_code

           and a.parts_code like '".$valueInqPart."' || '%'

           and a.corp_code = 'PTM'

           and a.fctry_code = 'MX'

           and '".$valueCustomer."'= 'CUM'

        UNION ALL

        select a.parts_code  as parts_code,

               b.parts_nm    as parts_nm,

               b.parts_descr as parts_descr,

               a.wh_code     as loc_code,

               a.rack_lot    as lot_code,

               a.stok_qty    as stock_qty

          from tmidstok a, tmimmatl b

         where a.wh_code  = 'WHGL-U'

           and b.parts_code = a.parts_code

           and b.corp_code = a.corp_code

           and b.fctry_code = a.fctry_code

           and a.parts_code like '".$valueInqPart."'|| '%'

           and a.corp_code = 'PTM'

           and a.fctry_code = 'MX'

           and '".$valueCustomer."' = 'CV')

        order by 1, 3"