DBA Data[Home] [Help]

VIEW: APPS.IBY_ACCT_PMT_PROFILES_VL

Source

View Text - Preformatted

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')
View Text - HTML Formatted

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