VIEW: APPS.OKX_TRANSACTION_TYPES_V

Source

View Text - Preformatted

SELECT B.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, TL.NAME NAME, TL.DESCRIPTION DESCRIPTION, B.END_DATE_ACTIVE END_DATE_ACTIVE, B.START_DATE_ACTIVE START_DATE_ACTIVE FROM CS_TRANSACTION_TYPES_B B,CS_TRANSACTION_TYPES_TL TL WHERE B.TRANSACTION_TYPE_ID = TL.TRANSACTION_TYPE_ID AND TL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, TL.NAME NAME
, TL.DESCRIPTION DESCRIPTION
, B.END_DATE_ACTIVE END_DATE_ACTIVE
, B.START_DATE_ACTIVE START_DATE_ACTIVE
FROM CS_TRANSACTION_TYPES_B B
, CS_TRANSACTION_TYPES_TL TL
WHERE B.TRANSACTION_TYPE_ID = TL.TRANSACTION_TYPE_ID
AND TL.LANGUAGE = USERENV('LANG')