FND Design Data [Home] [Help]

View: IBY_ACCT_PMT_PROFILES_VL

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

SELECT B.ROWID
, B.PAYMENT_PROFILE_ID
, T.PAYMENT_PROFILE_NAME
, B.SYSTEM_PROFILE_CODE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.BEP_ACCOUNT_ID
, B.SECURITY_CONFIGURATION_ID
, B.TRANSMIT_CONFIGURATION_ID
, B.RESET_VALUE_1
, B.LAST_USED_NUMBER_1
, B.RESET_REQUEST_1
, B.RESET_VALUE_2
, B.LAST_USED_NUMBER_2
, B.RESET_REQUEST_2
, B.RESET_VALUE_3
, B.LAST_USED_NUMBER_3
, B.RESET_REQUEST_3
, B.INACTIVE_DATE
, B.ACK_SEC_CONFIG_ID
, B.ACK_TRANSMIT_CONFIG_ID
FROM IBY_ACCT_PMT_PROFILES_TL T
, IBY_ACCT_PMT_PROFILES_B B
WHERE B.PAYMENT_PROFILE_ID = T.PAYMENT_PROFILE_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
PAYMENT_PROFILE_ID
PAYMENT_PROFILE_NAME
SYSTEM_PROFILE_CODE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
BEP_ACCOUNT_ID
SECURITY_CONFIGURATION_ID
TRANSMIT_CONFIGURATION_ID
RESET_VALUE_1
LAST_USED_NUMBER_1
RESET_REQUEST_1
RESET_VALUE_2
LAST_USED_NUMBER_2
RESET_REQUEST_2
RESET_VALUE_3
LAST_USED_NUMBER_3
RESET_REQUEST_3
INACTIVE_DATE
ACK_SEC_CONFIG_ID
ACK_TRANSMIT_CONFIG_ID