|
SELECT a.SETID , a.PRODUCT_ID , a.DESCR254 , ( SELECT CFR.DESCR254 FROM PS_PROD_ITEM_LNG CFR WHERE a.SETID = CFR.SETID AND a.PRODUCT_ID = CFR.PRODUCT_ID AND CFR.LANGUAGE_CD = 'CFR') AS DESCR254_CFR, ( SELECT DUT.DESCR254 FROM PS_PROD_ITEM_LNG DUT WHERE a.SETID = DUT.SETID AND a.PRODUCT_ID = DUT.PRODUCT_ID AND DUT.LANGUAGE_CD = 'DUT') AS DESCR254_DUT, ( SELECT ESP.DESCR254 FROM PS_PROD_ITEM_LNG ESP WHERE a.SETID = ESP.SETID AND a.PRODUCT_ID = ESP.PRODUCT_ID AND ESP.LANGUAGE_CD = 'ESP') AS DESCR254_ESP, ( SELECT FRA.DESCR254 FROM PS_PROD_ITEM_LNG FRA WHERE a.SETID = FRA.SETID AND a.PRODUCT_ID = FRA.PRODUCT_ID AND FRA.LANGUAGE_CD = 'FRA') AS DESCR254_FRA, ( SELECT GER.DESCR254 FROM PS_PROD_ITEM_LNG GER WHERE a.SETID = GER.SETID AND a.PRODUCT_ID = GER.PRODUCT_ID AND GER.LANGUAGE_CD = 'GER') AS DESCR254_GER, ( SELECT ITA.DESCR254 FROM PS_PROD_ITEM_LNG ITA WHERE a.SETID = ITA.SETID AND a.PRODUCT_ID = ITA.PRODUCT_ID AND ITA.LANGUAGE_CD = 'ITA') AS DESCR254_ITA, ( SELECT JPN.DESCR254 FROM PS_PROD_ITEM_LNG JPN WHERE a.SETID = JPN.SETID AND a.PRODUCT_ID = JPN.PRODUCT_ID AND JPN.LANGUAGE_CD = 'JPN') AS DESCR254_JPN, ( SELECT KOR.DESCR254 FROM PS_PROD_ITEM_LNG KOR WHERE a.SETID = KOR.SETID AND a.PRODUCT_ID = KOR.PRODUCT_ID AND KOR.LANGUAGE_CD = 'KOR') AS DESCR254_KOR, ( SELECT SVE.DESCR254 FROM PS_PROD_ITEM_LNG SVE WHERE a.SETID = SVE.SETID AND a.PRODUCT_ID = SVE.PRODUCT_ID AND SVE.LANGUAGE_CD = 'SVE') AS DESCR254_SVE, ( SELECT ZHS.DESCR254 FROM PS_PROD_ITEM_LNG ZHS WHERE a.SETID = ZHS.SETID AND a.PRODUCT_ID = ZHS.PRODUCT_ID AND ZHS.LANGUAGE_CD = 'ZHS') AS DESCR254_ZHS FROM PS_PROD_ITEM a
|