SELECT distinct a.name, a.description from oe_transaction_types_tl a, oe_transaction_types_all b WHERE b.transaction_type_code = 'LINE' and b.order_category_code = 'RETURN' and a.language = userenv('LANG') and a.transaction_type_id = b.transaction_type_id
SELECT DISTINCT A.NAME
, A.DESCRIPTION
FROM OE_TRANSACTION_TYPES_TL A
, OE_TRANSACTION_TYPES_ALL B
WHERE B.TRANSACTION_TYPE_CODE = 'LINE'
AND B.ORDER_CATEGORY_CODE = 'RETURN'
AND A.LANGUAGE = USERENV('LANG')
AND A.TRANSACTION_TYPE_ID = B.TRANSACTION_TYPE_ID
|
|
|