SELECT
    `customer_desc_tbl`.`code` AS `customer`,
    `market_desc_tbl`.`code` AS `market`,
    `variety_desc_tbl`.`code` AS `variety`,
    `package_desc_tbl`.`code` as `package`
FROM
    `cc_matriz_precios_proforma_recibidor` `ccpr`
    JOIN `customer_tbl` `rec` ON (`ccpr`.`id_header` = `rec`.`id_header`)
    JOIN `customer_desc_tbl` ON (`rec`.`idcustomer` = `customer_desc_tbl`.`idcustomer`)
    JOIN `market_tbl` `merc` ON (`ccpr`.`id_header` = `merc`.`id_header`)
    JOIN `market_desc_tbl` ON (`merc`.`idmarket` = `market_desc_tbl`.`idmarket`)
    JOIN `variety_tbl` `var` ON (`ccpr`.`id_header` = `var`.`id_header`)
    JOIN `variety_desc_tbl` ON (`var`.`idvariety` = `variety_desc_tbl`.`idvariety`)
    JOIN `package_tbl` `env` ON (`ccpr`.`id_header` = `package_tbl`.`id_header`)
    JOIN `package_desc_tbl` ON (`package_tbl`.`idpackage` = `package_desc_tbl`.`idpackage`)