[Home] [Help]
View: OKX_TRANSACTION_TYPES_V
| Product: | OKX - Contracts Integration |
| Description: | Seeded and user-defined transactions |
| Implementation/DBA Data: |
APPS.OKX_TRANSACTION_TYPES_V
|
View Text
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')
Columns
| Name |
| TRANSACTION_TYPE_ID |
| NAME |
| DESCRIPTION |
| END_DATE_ACTIVE |
| START_DATE_ACTIVE |