IBY_ACCT_PMT_PROFILES_VL

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name

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 START_DATE END_DATE

Query

SQL_Statement

SELECT 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, B.START_DATE, B.END_DATE 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')