eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_VALIDATIONSETS_PUB dependencies on IBY_EXT_BANK_ACCOUNTS_V

Line 72: ext_bank_num IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,

68: payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE,
69: payer_phone IBY_PP_FIRST_PARTY_V.party_phone%TYPE,
70: payer_registration_number IBY_PP_FIRST_PARTY_V.party_registration_number%TYPE, --added by asarada (SEPA Credit Transfer 3.3)
71: payer_tax_registration_number IBY_PAYMENTS_ALL.payer_tax_registration_num%TYPE, --added by asarada (SEPA Credit Transfer 3.3)
72: ext_bank_num IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
73: ext_bank_name IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,
74:
75: ext_bank_name_alt CE_BANKS_V.bank_name_alt%TYPE,
76:

Line 73: ext_bank_name IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,

69: payer_phone IBY_PP_FIRST_PARTY_V.party_phone%TYPE,
70: payer_registration_number IBY_PP_FIRST_PARTY_V.party_registration_number%TYPE, --added by asarada (SEPA Credit Transfer 3.3)
71: payer_tax_registration_number IBY_PAYMENTS_ALL.payer_tax_registration_num%TYPE, --added by asarada (SEPA Credit Transfer 3.3)
72: ext_bank_num IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
73: ext_bank_name IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,
74:
75: ext_bank_name_alt CE_BANKS_V.bank_name_alt%TYPE,
76:
77: ext_bank_branch_num IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,

Line 77: ext_bank_branch_num IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,

73: ext_bank_name IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,
74:
75: ext_bank_name_alt CE_BANKS_V.bank_name_alt%TYPE,
76:
77: ext_bank_branch_num IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,
78: ext_bank_branch_name IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,
79:
80: ext_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
81:

Line 78: ext_bank_branch_name IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,

74:
75: ext_bank_name_alt CE_BANKS_V.bank_name_alt%TYPE,
76:
77: ext_bank_branch_num IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,
78: ext_bank_branch_name IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,
79:
80: ext_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
81:
82: ext_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE, -- bug 16007784

Line 84: ext_bank_country IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,

80: ext_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
81:
82: ext_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE, -- bug 16007784
83:
84: ext_bank_country IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,
85:
86: ext_bank_branch_addr1 CE_BANK_BRANCHES_V.address_line1%TYPE,
87:
88: ext_bank_branch_country CE_BANK_BRANCHES_V.country%TYPE,

Line 90: ext_bank_acc_num IBY_EXT_BANK_ACCOUNTS_V.

86: ext_bank_branch_addr1 CE_BANK_BRANCHES_V.address_line1%TYPE,
87:
88: ext_bank_branch_country CE_BANK_BRANCHES_V.country%TYPE,
89:
90: ext_bank_acc_num IBY_EXT_BANK_ACCOUNTS_V.
91: bank_account_number%TYPE,
92: ext_bank_acc_name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
93: ext_bank_acc_name_alt IBY_EXT_BANK_ACCOUNTS_V.
94: alternate_account_name%TYPE,

Line 92: ext_bank_acc_name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,

88: ext_bank_branch_country CE_BANK_BRANCHES_V.country%TYPE,
89:
90: ext_bank_acc_num IBY_EXT_BANK_ACCOUNTS_V.
91: bank_account_number%TYPE,
92: ext_bank_acc_name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
93: ext_bank_acc_name_alt IBY_EXT_BANK_ACCOUNTS_V.
94: alternate_account_name%TYPE,
95: ext_bank_acc_type IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
96: ext_bank_acc_iban IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE, -- Payee IBAN

Line 93: ext_bank_acc_name_alt IBY_EXT_BANK_ACCOUNTS_V.

89:
90: ext_bank_acc_num IBY_EXT_BANK_ACCOUNTS_V.
91: bank_account_number%TYPE,
92: ext_bank_acc_name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
93: ext_bank_acc_name_alt IBY_EXT_BANK_ACCOUNTS_V.
94: alternate_account_name%TYPE,
95: ext_bank_acc_type IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
96: ext_bank_acc_iban IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE, -- Payee IBAN
97: ext_bank_acc_chk_dgts IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,

Line 95: ext_bank_acc_type IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,

91: bank_account_number%TYPE,
92: ext_bank_acc_name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
93: ext_bank_acc_name_alt IBY_EXT_BANK_ACCOUNTS_V.
94: alternate_account_name%TYPE,
95: ext_bank_acc_type IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
96: ext_bank_acc_iban IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE, -- Payee IBAN
97: ext_bank_acc_chk_dgts IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,
98: ext_bank_acc_short_name IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,
99: ext_bank_acc_holder_name IBY_EXT_BANK_ACCOUNTS_V.

Line 96: ext_bank_acc_iban IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE, -- Payee IBAN

92: ext_bank_acc_name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
93: ext_bank_acc_name_alt IBY_EXT_BANK_ACCOUNTS_V.
94: alternate_account_name%TYPE,
95: ext_bank_acc_type IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
96: ext_bank_acc_iban IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE, -- Payee IBAN
97: ext_bank_acc_chk_dgts IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,
98: ext_bank_acc_short_name IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,
99: ext_bank_acc_holder_name IBY_EXT_BANK_ACCOUNTS_V.
100: primary_acct_owner_name%TYPE,

Line 97: ext_bank_acc_chk_dgts IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,

93: ext_bank_acc_name_alt IBY_EXT_BANK_ACCOUNTS_V.
94: alternate_account_name%TYPE,
95: ext_bank_acc_type IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
96: ext_bank_acc_iban IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE, -- Payee IBAN
97: ext_bank_acc_chk_dgts IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,
98: ext_bank_acc_short_name IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,
99: ext_bank_acc_holder_name IBY_EXT_BANK_ACCOUNTS_V.
100: primary_acct_owner_name%TYPE,
101:

Line 98: ext_bank_acc_short_name IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,

94: alternate_account_name%TYPE,
95: ext_bank_acc_type IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
96: ext_bank_acc_iban IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE, -- Payee IBAN
97: ext_bank_acc_chk_dgts IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,
98: ext_bank_acc_short_name IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,
99: ext_bank_acc_holder_name IBY_EXT_BANK_ACCOUNTS_V.
100: primary_acct_owner_name%TYPE,
101:
102: ext_bank_acc_holder_name_alt

Line 99: ext_bank_acc_holder_name IBY_EXT_BANK_ACCOUNTS_V.

95: ext_bank_acc_type IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
96: ext_bank_acc_iban IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE, -- Payee IBAN
97: ext_bank_acc_chk_dgts IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,
98: ext_bank_acc_short_name IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,
99: ext_bank_acc_holder_name IBY_EXT_BANK_ACCOUNTS_V.
100: primary_acct_owner_name%TYPE,
101:
102: ext_bank_acc_holder_name_alt
103: CE_BANK_ACCOUNTS_V.bank_account_name_alt%TYPE,

Line 569: IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,

565: HZ_LOCATIONS.postal_code%TYPE,
566:
567: /* PAYEE BANK */
568: payee_bank_name
569: IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,
570: payee_bank_number
571: IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
572: payee_bank_branch_num
573: IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,

Line 571: IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,

567: /* PAYEE BANK */
568: payee_bank_name
569: IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,
570: payee_bank_number
571: IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
572: payee_bank_branch_num
573: IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,
574: payee_bank_branch_name
575: IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,

Line 573: IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,

569: IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,
570: payee_bank_number
571: IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
572: payee_bank_branch_num
573: IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,
574: payee_bank_branch_name
575: IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,
576: payee_bank_acct_holder_name
577: IBY_EXT_BANK_ACCOUNTS_V.primary_acct_owner_name%TYPE,

Line 575: IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,

571: IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
572: payee_bank_branch_num
573: IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,
574: payee_bank_branch_name
575: IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,
576: payee_bank_acct_holder_name
577: IBY_EXT_BANK_ACCOUNTS_V.primary_acct_owner_name%TYPE,
578: payee_bank_acct_num
579: IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,

Line 577: IBY_EXT_BANK_ACCOUNTS_V.primary_acct_owner_name%TYPE,

573: IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,
574: payee_bank_branch_name
575: IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,
576: payee_bank_acct_holder_name
577: IBY_EXT_BANK_ACCOUNTS_V.primary_acct_owner_name%TYPE,
578: payee_bank_acct_num
579: IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
580: payee_bank_acct_name
581: IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,

Line 579: IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,

575: IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,
576: payee_bank_acct_holder_name
577: IBY_EXT_BANK_ACCOUNTS_V.primary_acct_owner_name%TYPE,
578: payee_bank_acct_num
579: IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
580: payee_bank_acct_name
581: IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
582: payee_bank_acct_iban_num
583: IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE,

Line 581: IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,

577: IBY_EXT_BANK_ACCOUNTS_V.primary_acct_owner_name%TYPE,
578: payee_bank_acct_num
579: IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
580: payee_bank_acct_name
581: IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
582: payee_bank_acct_iban_num
583: IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE,
584: payee_bank_swift_code
585: IBY_EXT_BANK_ACCOUNTS_V.eft_swift_code%TYPE,

Line 583: IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE,

579: IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
580: payee_bank_acct_name
581: IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
582: payee_bank_acct_iban_num
583: IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE,
584: payee_bank_swift_code
585: IBY_EXT_BANK_ACCOUNTS_V.eft_swift_code%TYPE,
586: payee_bank_acct_checkdigits
587: IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,

Line 585: IBY_EXT_BANK_ACCOUNTS_V.eft_swift_code%TYPE,

581: IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
582: payee_bank_acct_iban_num
583: IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE,
584: payee_bank_swift_code
585: IBY_EXT_BANK_ACCOUNTS_V.eft_swift_code%TYPE,
586: payee_bank_acct_checkdigits
587: IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,
588: payee_bank_add1
589: VARCHAR2(240),

Line 587: IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,

583: IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE,
584: payee_bank_swift_code
585: IBY_EXT_BANK_ACCOUNTS_V.eft_swift_code%TYPE,
586: payee_bank_acct_checkdigits
587: IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,
588: payee_bank_add1
589: VARCHAR2(240),
590: payee_bank_add2
591: VARCHAR2(240),

Line 609: IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,

605: VARCHAR2(240),
606: payee_bank_branch_name_alt
607: VARCHAR2(240),
608: payee_bank_country_code
609: IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,
610: payee_bank_account_name_alt
611: IBY_EXT_BANK_ACCOUNTS_V.alternate_account_name%TYPE,
612: payee_bank_account_type
613: IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,

Line 611: IBY_EXT_BANK_ACCOUNTS_V.alternate_account_name%TYPE,

607: VARCHAR2(240),
608: payee_bank_country_code
609: IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,
610: payee_bank_account_name_alt
611: IBY_EXT_BANK_ACCOUNTS_V.alternate_account_name%TYPE,
612: payee_bank_account_type
613: IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
614: payee_bank_account_short_name
615: IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,

Line 613: IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,

609: IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,
610: payee_bank_account_name_alt
611: IBY_EXT_BANK_ACCOUNTS_V.alternate_account_name%TYPE,
612: payee_bank_account_type
613: IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
614: payee_bank_account_short_name
615: IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,
616: payee_bank_acct_hold_name_alt
617: VARCHAR2(240)

Line 615: IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,

611: IBY_EXT_BANK_ACCOUNTS_V.alternate_account_name%TYPE,
612: payee_bank_account_type
613: IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
614: payee_bank_account_short_name
615: IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,
616: payee_bank_acct_hold_name_alt
617: VARCHAR2(240)
618: );
619: