VIEW: APPS.IBY_SEC_EXT_BANK_ACCOUNT_V

Source

View Text - Preformatted

SELECT b.ext_bank_account_id, iby_ext_bankacct_pub.Uncipher_Bank_Number (b.bank_account_num, b.ba_num_sec_segment_id, iby_utility_pvt.get_view_param('SYS_KEY'), bak.subkey_cipher_text, bas.segment_cipher_text, bas.encoding_scheme, b.ba_mask_setting, b.ba_unmask_length), iby_ext_bankacct_pub.Uncipher_Bank_Number (b.iban, b.iban_sec_segment_id, iby_utility_pvt.get_view_param('SYS_KEY'), ibk.subkey_cipher_text, ibs.segment_cipher_text, ibs.encoding_scheme, b.ba_mask_setting, b.ba_unmask_length), iby_ext_bankacct_pub.Uncipher_Bank_Number (b.bank_account_num_electronic, b.ba_num_elec_sec_segment_id, iby_utility_pvt.get_view_param('SYS_KEY'), baek.subkey_cipher_text, baes.segment_cipher_text, baes.encoding_scheme, b.ba_mask_setting, b.ba_unmask_length) FROM IBY_EXT_BANK_ACCOUNTS B,IBY_SECURITY_SEGMENTS IBS,IBY_SYS_SECURITY_SUBKEYS IBK,IBY_SECURITY_SEGMENTS BAS,IBY_SYS_SECURITY_SUBKEYS BAK,IBY_SECURITY_SEGMENTS BAES,IBY_SYS_SECURITY_SUBKEYS BAEK WHERE (b.ba_num_sec_segment_id = bas.sec_segment_id(+)) AND (bas.sec_subkey_id = bak.sec_subkey_id(+)) AND (b.iban_sec_segment_id = ibs.sec_segment_id(+)) AND (ibs.sec_subkey_id = ibk.sec_subkey_id(+)) AND (b.ba_num_elec_sec_segment_id = baes.sec_segment_id(+)) AND (baes.sec_subkey_id = baek.sec_subkey_id(+))

View Text - HTML Formatted

SELECT B.EXT_BANK_ACCOUNT_ID
, IBY_EXT_BANKACCT_PUB.UNCIPHER_BANK_NUMBER (B.BANK_ACCOUNT_NUM
, B.BA_NUM_SEC_SEGMENT_ID
, IBY_UTILITY_PVT.GET_VIEW_PARAM('SYS_KEY')
, BAK.SUBKEY_CIPHER_TEXT
, BAS.SEGMENT_CIPHER_TEXT
, BAS.ENCODING_SCHEME
, B.BA_MASK_SETTING
, B.BA_UNMASK_LENGTH)
, IBY_EXT_BANKACCT_PUB.UNCIPHER_BANK_NUMBER (B.IBAN
, B.IBAN_SEC_SEGMENT_ID
, IBY_UTILITY_PVT.GET_VIEW_PARAM('SYS_KEY')
, IBK.SUBKEY_CIPHER_TEXT
, IBS.SEGMENT_CIPHER_TEXT
, IBS.ENCODING_SCHEME
, B.BA_MASK_SETTING
, B.BA_UNMASK_LENGTH)
, IBY_EXT_BANKACCT_PUB.UNCIPHER_BANK_NUMBER (B.BANK_ACCOUNT_NUM_ELECTRONIC
, B.BA_NUM_ELEC_SEC_SEGMENT_ID
, IBY_UTILITY_PVT.GET_VIEW_PARAM('SYS_KEY')
, BAEK.SUBKEY_CIPHER_TEXT
, BAES.SEGMENT_CIPHER_TEXT
, BAES.ENCODING_SCHEME
, B.BA_MASK_SETTING
, B.BA_UNMASK_LENGTH)
FROM IBY_EXT_BANK_ACCOUNTS B
, IBY_SECURITY_SEGMENTS IBS
, IBY_SYS_SECURITY_SUBKEYS IBK
, IBY_SECURITY_SEGMENTS BAS
, IBY_SYS_SECURITY_SUBKEYS BAK
, IBY_SECURITY_SEGMENTS BAES
, IBY_SYS_SECURITY_SUBKEYS BAEK
WHERE (B.BA_NUM_SEC_SEGMENT_ID = BAS.SEC_SEGMENT_ID(+))
AND (BAS.SEC_SUBKEY_ID = BAK.SEC_SUBKEY_ID(+))
AND (B.IBAN_SEC_SEGMENT_ID = IBS.SEC_SEGMENT_ID(+))
AND (IBS.SEC_SUBKEY_ID = IBK.SEC_SUBKEY_ID(+))
AND (B.BA_NUM_ELEC_SEC_SEGMENT_ID = BAES.SEC_SEGMENT_ID(+))
AND (BAES.SEC_SUBKEY_ID = BAEK.SEC_SUBKEY_ID(+))