SELECT t.transaction_type_id id, tl.name value from oe_transaction_types_all t, oe_transaction_types_tl tl WHERE t.transaction_type_id = tl.transaction_type_id and t.sales_document_type_code = 'B' and tl.language = userenv('LANG')
SELECT T.TRANSACTION_TYPE_ID ID
, TL.NAME VALUE
FROM OE_TRANSACTION_TYPES_ALL T
, OE_TRANSACTION_TYPES_TL TL
WHERE T.TRANSACTION_TYPE_ID = TL.TRANSACTION_TYPE_ID
AND T.SALES_DOCUMENT_TYPE_CODE = 'B'
AND TL.LANGUAGE = USERENV('LANG')
|
|
|