EDR_TRANSACTION_TYPES_VL

Details

• Schema: FUSION

• Object owner: EDR

• Object type: VIEW

Columns

Name
TRANSACTION_TYPE_ID TRANSACTION_TYPE_MEANING TRANSACTION_TYPE_DESCRIPTION TRANSACTION_TYPE_CODE TRANSACTION_TYPE_SHORT_CODE BPM_TASK_NAMESPACE SIGNATURE_MODE BI_REPORT_PATH BI_TEMPLATE_NAME BI_OUTPUT_FORMAT OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.TRANSACTION_TYPE_ID, T.TRANSACTION_TYPE_MEANING, T.TRANSACTION_TYPE_DESCRIPTION, B.TRANSACTION_TYPE_CODE, B.TRANSACTION_TYPE_SHORT_CODE, B.BPM_TASK_NAMESPACE, B.SIGNATURE_MODE, B.BI_REPORT_PATH, B.BI_TEMPLATE_NAME, B.BI_OUTPUT_FORMAT, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM EDR_TRANSACTION_TYPES_TL T, EDR_TRANSACTION_TYPES_B B WHERE T.TRANSACTION_TYPE_ID = B.TRANSACTION_TYPE_ID AND T.LANGUAGE = USERENV('LANG')