FND Design Data [Home] [Help]

View: IBY_TRXN_TYPES_VL

Product: IBY - Payments
Description:
Implementation/DBA Data: ViewAPPS.IBY_TRXN_TYPES_VL
View Text

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')

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