JMF_IN_TRANSACTION_CODE

Details

Schema: FUSION
Object owner: JMF
Object type: VIEW

Columns

Name
TRANSACTION_CODE_ID RULE_TYPE TRANSACTION_CODE LANGUAGE SOURCE_LANG TRANSACTION_CODE_DESC LAST_UPDATED_BY CREATION_DATE LAST_UPDATE_LOGIN LAST_UPDATE_DATE CREATED_BY OBJECT_VERSION_NUMBER

Name

TRANSACTION_CODE_ID

RULE_TYPE

TRANSACTION_CODE

LANGUAGE

SOURCE_LANG

TRANSACTION_CODE_DESC

LAST_UPDATED_BY

CREATION_DATE

LAST_UPDATE_LOGIN

LAST_UPDATE_DATE

CREATED_BY

OBJECT_VERSION_NUMBER

Query

SQL_Statement
SELECT JMF_IN_TRANSACTION_CODE_B.TRANSACTION_CODE_ID, JMF_IN_TRANSACTION_CODE_B.RULE_TYPE, JMF_IN_TRANSACTION_CODE_B.TRANSACTION_CODE, JMF_IN_TRANSACTION_CODE_TL.LANGUAGE, JMF_IN_TRANSACTION_CODE_TL.SOURCE_LANG, JMF_IN_TRANSACTION_CODE_TL.TRANSACTION_CODE_DESC, JMF_IN_TRANSACTION_CODE_B.LAST_UPDATED_BY, JMF_IN_TRANSACTION_CODE_B.CREATION_DATE, JMF_IN_TRANSACTION_CODE_B.LAST_UPDATE_LOGIN, JMF_IN_TRANSACTION_CODE_B.LAST_UPDATE_DATE, JMF_IN_TRANSACTION_CODE_B.CREATED_BY, JMF_IN_TRANSACTION_CODE_B.OBJECT_VERSION_NUMBER FROM JMF_IN_TRANSACTION_CODE_B, JMF_IN_TRANSACTION_CODE_TL WHERE JMF_IN_TRANSACTION_CODE_B.TRANSACTION_CODE_ID = JMF_IN_TRANSACTION_CODE_TL.TRANSACTION_CODE_ID AND JMF_IN_TRANSACTION_CODE_B.RULE_TYPE = JMF_IN_TRANSACTION_CODE_TL.RULE_TYPE AND JMF_IN_TRANSACTION_CODE_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

JMF_IN_TRANSACTION_CODE_B.TRANSACTION_CODE_ID,

JMF_IN_TRANSACTION_CODE_B.RULE_TYPE,

JMF_IN_TRANSACTION_CODE_B.TRANSACTION_CODE,

JMF_IN_TRANSACTION_CODE_TL.LANGUAGE,

JMF_IN_TRANSACTION_CODE_TL.SOURCE_LANG,

JMF_IN_TRANSACTION_CODE_TL.TRANSACTION_CODE_DESC,

JMF_IN_TRANSACTION_CODE_B.LAST_UPDATED_BY,

JMF_IN_TRANSACTION_CODE_B.CREATION_DATE,

JMF_IN_TRANSACTION_CODE_B.LAST_UPDATE_LOGIN,

JMF_IN_TRANSACTION_CODE_B.LAST_UPDATE_DATE,

JMF_IN_TRANSACTION_CODE_B.CREATED_BY,

JMF_IN_TRANSACTION_CODE_B.OBJECT_VERSION_NUMBER

FROM

JMF_IN_TRANSACTION_CODE_B,

JMF_IN_TRANSACTION_CODE_TL

WHERE

JMF_IN_TRANSACTION_CODE_B.TRANSACTION_CODE_ID = JMF_IN_TRANSACTION_CODE_TL.TRANSACTION_CODE_ID AND JMF_IN_TRANSACTION_CODE_B.RULE_TYPE = JMF_IN_TRANSACTION_CODE_TL.RULE_TYPE AND JMF_IN_TRANSACTION_CODE_TL.LANGUAGE = USERENV('LANG')