query
-----
SELECT ALL PRODUCT_DESCRIPTIONS.PRODUCT_ID, 
PRODUCT_DESCRIPTIONS.LANGUAGE_ID, 
PRODUCT_DESCRIPTIONS.TRANSLATED_NAME, 
PRODUCT_DESCRIPTIONS.TRANSLATED_DESCRIPTION
FROM PRODUCT_DESCRIPTIONS


query with the condition
------------------------
SELECT ALL PRODUCT_DESCRIPTIONS.PRODUCT_ID, 
PRODUCT_DESCRIPTIONS.LANGUAGE_ID, 
PRODUCT_DESCRIPTIONS.TRANSLATED_NAME, 
PRODUCT_DESCRIPTIONS.TRANSLATED_DESCRIPTION
FROM PRODUCT_DESCRIPTIONS
where language_id = :p_lang_id