IBY_TRXN_TYPES

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
ROW_ID APPLICATION_ID PAY_PROC_TRXN_TYPE_CODE SEEDED_FLAG PAYMENT_FLOW CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER CREATED_BY NAME DESCRIPTION

Name

ROW_ID

APPLICATION_ID

PAY_PROC_TRXN_TYPE_CODE

SEEDED_FLAG

PAYMENT_FLOW

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

CREATED_BY

NAME

DESCRIPTION

Query

SQL_Statement
SELECT B.ROWID, B.APPLICATION_ID, B.PAY_PROC_TRXN_TYPE_CODE, B.SEEDED_FLAG, B.PAYMENT_FLOW, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, T.NAME, T.DESCRIPTION FROM IBY_TRXN_TYPES_TL T,IBY_TRXN_TYPES_B B WHERE B.PAY_PROC_TRXN_TYPE_CODE = T.PAY_PROC_TRXN_TYPE_CODE AND b.application_id = t.application_id and T.LANGUAGE = userenv('LANG')

SQL_Statement

SELECT B.ROWID, B.APPLICATION_ID, B.PAY_PROC_TRXN_TYPE_CODE, B.SEEDED_FLAG, B.PAYMENT_FLOW, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, T.NAME, T.DESCRIPTION FROM IBY_TRXN_TYPES_TL T,IBY_TRXN_TYPES_B B WHERE B.PAY_PROC_TRXN_TYPE_CODE = T.PAY_PROC_TRXN_TYPE_CODE AND b.application_id = t.application_id and T.LANGUAGE = userenv('LANG')