SELECT CAFES.ITEM_NO, CAFES.ITEM_CAFE AS RECIPE, MOUTURES.LIST_ELEMENT AS MOUTURE, PRODUCT_TYPES.LIST_ELEMENT AS PRODUCT_TYPE, CONSERVATIONS.LIST_ELEMENT AS CONSERVATION, CAFES.NBR_SACS, CAFES.POIDS, CAFES.POIDS_UDM, BOX_DESC.DESCR AS BOX_DESC, FILM_DESC.DESCR AS FILM_DESC, PROD_DESC.DESCR AS PROD_DESC, CAFES.OLD_LABEL_INFO, CAFES.PROD_NOTE, CAFES.NBR_SUB_CONTAINER, CAFES.SUB_CONTAINER_ACTIF, CAFES.ILAPAK_PROG, CAFES.QTE_FILTRES, CONTENANTS.LIST_ELEMENT AS SUB_CONTAINER FROM ZZVITTO_WZ_CAFE CAFES, WZ_LISTS_DTL MOUTURES, WZ_LISTS_DTL PRODUCT_TYPES, WZ_LISTS_DTL CONSERVATIONS, WZ_LISTS_DTL CONTENANTS, ITEM_DESC BOX_DESC, ITEM_DESC FILM_DESC, ITEM_DESC PROD_DESC WHERE CAFES.MOUTURE = MOUTURES.LINE_ORDER AND CAFES.PRODUCT_TYPE = PRODUCT_TYPES.LINE_ORDER AND CAFES.CONSERVATION = CONSERVATIONS.LINE_ORDER AND CAFES.SUB_CONTAINER = CONTENANTS.LINE_ORDER AND CAFES.ITEM_BOITE = BOX_DESC.REF_NO AND CAFES.ITEM_FILM = FILM_DESC.REF_NO AND CAFES.ITEM_NO = PROD_DESC.REF_NO AND (MOUTURES.LIST_NAME = 'MOUTURE') AND (PRODUCT_TYPES.LIST_NAME = 'TYPE_PRODUIT') AND (CONSERVATIONS.LIST_NAME = 'CONSERVATION') AND (CONTENANTS.LIST_NAME = 'CONTENANTS') AND (CAFES.ITEM_NO = :ITEM_NO) AND (BOX_DESC.LANG_NO = 'F') AND (FILM_DESC.LANG_NO = 'F') AND (PROD_DESC.LANG_NO = 'F')