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 67: ext_bank_num IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,

63: payer_le_name IBY_PP_FIRST_PARTY_V.party_legal_name%TYPE,
64: payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE,
65: payer_phone IBY_PP_FIRST_PARTY_V.party_phone%TYPE,
66:
67: ext_bank_num IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
68: ext_bank_name IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,
69:
70: ext_bank_name_alt CE_BANKS_V.bank_name_alt%TYPE,
71:

Line 68: ext_bank_name IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,

64: payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE,
65: payer_phone IBY_PP_FIRST_PARTY_V.party_phone%TYPE,
66:
67: ext_bank_num IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
68: ext_bank_name IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,
69:
70: ext_bank_name_alt CE_BANKS_V.bank_name_alt%TYPE,
71:
72: ext_bank_branch_num IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,

Line 72: ext_bank_branch_num IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,

68: ext_bank_name IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,
69:
70: ext_bank_name_alt CE_BANKS_V.bank_name_alt%TYPE,
71:
72: ext_bank_branch_num IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,
73: ext_bank_branch_name IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,
74:
75: ext_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
76:

Line 73: ext_bank_branch_name IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,

69:
70: ext_bank_name_alt CE_BANKS_V.bank_name_alt%TYPE,
71:
72: ext_bank_branch_num IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,
73: ext_bank_branch_name IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,
74:
75: ext_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
76:
77: ext_bank_country IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,

Line 77: ext_bank_country IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,

73: ext_bank_branch_name IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,
74:
75: ext_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
76:
77: ext_bank_country IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,
78:
79: ext_bank_branch_addr1 CE_BANK_BRANCHES_V.address_line1%TYPE,
80:
81: ext_bank_branch_country CE_BANK_BRANCHES_V.country%TYPE,

Line 83: ext_bank_acc_num IBY_EXT_BANK_ACCOUNTS_V.

79: ext_bank_branch_addr1 CE_BANK_BRANCHES_V.address_line1%TYPE,
80:
81: ext_bank_branch_country CE_BANK_BRANCHES_V.country%TYPE,
82:
83: ext_bank_acc_num IBY_EXT_BANK_ACCOUNTS_V.
84: bank_account_number%TYPE,
85: ext_bank_acc_name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
86: ext_bank_acc_name_alt IBY_EXT_BANK_ACCOUNTS_V.
87: alternate_account_name%TYPE,

Line 85: ext_bank_acc_name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,

81: ext_bank_branch_country CE_BANK_BRANCHES_V.country%TYPE,
82:
83: ext_bank_acc_num IBY_EXT_BANK_ACCOUNTS_V.
84: bank_account_number%TYPE,
85: ext_bank_acc_name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
86: ext_bank_acc_name_alt IBY_EXT_BANK_ACCOUNTS_V.
87: alternate_account_name%TYPE,
88: ext_bank_acc_type IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
89: ext_bank_acc_iban IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE, -- Payee IBAN

Line 86: ext_bank_acc_name_alt IBY_EXT_BANK_ACCOUNTS_V.

82:
83: ext_bank_acc_num IBY_EXT_BANK_ACCOUNTS_V.
84: bank_account_number%TYPE,
85: ext_bank_acc_name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
86: ext_bank_acc_name_alt IBY_EXT_BANK_ACCOUNTS_V.
87: alternate_account_name%TYPE,
88: ext_bank_acc_type IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
89: ext_bank_acc_iban IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE, -- Payee IBAN
90: ext_bank_acc_chk_dgts IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,

Line 88: ext_bank_acc_type IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,

84: bank_account_number%TYPE,
85: ext_bank_acc_name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
86: ext_bank_acc_name_alt IBY_EXT_BANK_ACCOUNTS_V.
87: alternate_account_name%TYPE,
88: ext_bank_acc_type IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
89: ext_bank_acc_iban IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE, -- Payee IBAN
90: ext_bank_acc_chk_dgts IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,
91: ext_bank_acc_short_name IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,
92: ext_bank_acc_holder_name IBY_EXT_BANK_ACCOUNTS_V.

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

85: ext_bank_acc_name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
86: ext_bank_acc_name_alt IBY_EXT_BANK_ACCOUNTS_V.
87: alternate_account_name%TYPE,
88: ext_bank_acc_type IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
89: ext_bank_acc_iban IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE, -- Payee IBAN
90: ext_bank_acc_chk_dgts IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,
91: ext_bank_acc_short_name IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,
92: ext_bank_acc_holder_name IBY_EXT_BANK_ACCOUNTS_V.
93: primary_acct_owner_name%TYPE,

Line 90: ext_bank_acc_chk_dgts IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,

86: ext_bank_acc_name_alt IBY_EXT_BANK_ACCOUNTS_V.
87: alternate_account_name%TYPE,
88: ext_bank_acc_type IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
89: ext_bank_acc_iban IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE, -- Payee IBAN
90: ext_bank_acc_chk_dgts IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,
91: ext_bank_acc_short_name IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,
92: ext_bank_acc_holder_name IBY_EXT_BANK_ACCOUNTS_V.
93: primary_acct_owner_name%TYPE,
94:

Line 91: ext_bank_acc_short_name IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,

87: alternate_account_name%TYPE,
88: ext_bank_acc_type IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
89: ext_bank_acc_iban IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE, -- Payee IBAN
90: ext_bank_acc_chk_dgts IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,
91: ext_bank_acc_short_name IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,
92: ext_bank_acc_holder_name IBY_EXT_BANK_ACCOUNTS_V.
93: primary_acct_owner_name%TYPE,
94:
95: ext_bank_acc_holder_name_alt

Line 92: ext_bank_acc_holder_name IBY_EXT_BANK_ACCOUNTS_V.

88: ext_bank_acc_type IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
89: ext_bank_acc_iban IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE, -- Payee IBAN
90: ext_bank_acc_chk_dgts IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,
91: ext_bank_acc_short_name IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,
92: ext_bank_acc_holder_name IBY_EXT_BANK_ACCOUNTS_V.
93: primary_acct_owner_name%TYPE,
94:
95: ext_bank_acc_holder_name_alt
96: CE_BANK_ACCOUNTS_V.bank_account_name_alt%TYPE,

Line 268: ext_bank_country_cd IBY_EXT_BANK_ACCOUNTS_V.

264: pmt_date IBY_DOCS_PAYABLE_ALL.
265: payment_date%TYPE,
266: int_bank_country_cd CE_BANK_BRANCHES_V.
267: country%TYPE,
268: ext_bank_country_cd IBY_EXT_BANK_ACCOUNTS_V.
269: country_code%TYPE,
270: foreign_pmts_ok_flag IBY_EXT_BANK_ACCOUNTS_V.
271: foreign_payment_use_flag%TYPE
272: );

Line 270: foreign_pmts_ok_flag IBY_EXT_BANK_ACCOUNTS_V.

266: int_bank_country_cd CE_BANK_BRANCHES_V.
267: country%TYPE,
268: ext_bank_country_cd IBY_EXT_BANK_ACCOUNTS_V.
269: country_code%TYPE,
270: foreign_pmts_ok_flag IBY_EXT_BANK_ACCOUNTS_V.
271: foreign_payment_use_flag%TYPE
272: );
273:
274: --

Line 534: IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,

530: HZ_LOCATIONS.postal_code%TYPE,
531:
532: /* PAYEE BANK */
533: payee_bank_name
534: IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,
535: payee_bank_number
536: IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
537: payee_bank_branch_num
538: IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,

Line 536: IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,

532: /* PAYEE BANK */
533: payee_bank_name
534: IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,
535: payee_bank_number
536: IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
537: payee_bank_branch_num
538: IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,
539: payee_bank_branch_name
540: IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,

Line 538: IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,

534: IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,
535: payee_bank_number
536: IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
537: payee_bank_branch_num
538: IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,
539: payee_bank_branch_name
540: IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,
541: payee_bank_acct_holder_name
542: IBY_EXT_BANK_ACCOUNTS_V.primary_acct_owner_name%TYPE,

Line 540: IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,

536: IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
537: payee_bank_branch_num
538: IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,
539: payee_bank_branch_name
540: IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,
541: payee_bank_acct_holder_name
542: IBY_EXT_BANK_ACCOUNTS_V.primary_acct_owner_name%TYPE,
543: payee_bank_acct_num
544: IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,

Line 542: IBY_EXT_BANK_ACCOUNTS_V.primary_acct_owner_name%TYPE,

538: IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,
539: payee_bank_branch_name
540: IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,
541: payee_bank_acct_holder_name
542: IBY_EXT_BANK_ACCOUNTS_V.primary_acct_owner_name%TYPE,
543: payee_bank_acct_num
544: IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
545: payee_bank_acct_name
546: IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,

Line 544: IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,

540: IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,
541: payee_bank_acct_holder_name
542: IBY_EXT_BANK_ACCOUNTS_V.primary_acct_owner_name%TYPE,
543: payee_bank_acct_num
544: IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
545: payee_bank_acct_name
546: IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
547: payee_bank_acct_iban_num
548: IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE,

Line 546: IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,

542: IBY_EXT_BANK_ACCOUNTS_V.primary_acct_owner_name%TYPE,
543: payee_bank_acct_num
544: IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
545: payee_bank_acct_name
546: IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
547: payee_bank_acct_iban_num
548: IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE,
549: payee_bank_swift_code
550: IBY_EXT_BANK_ACCOUNTS_V.eft_swift_code%TYPE,

Line 548: IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE,

544: IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
545: payee_bank_acct_name
546: IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
547: payee_bank_acct_iban_num
548: IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE,
549: payee_bank_swift_code
550: IBY_EXT_BANK_ACCOUNTS_V.eft_swift_code%TYPE,
551: payee_bank_acct_checkdigits
552: IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,

Line 550: IBY_EXT_BANK_ACCOUNTS_V.eft_swift_code%TYPE,

546: IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
547: payee_bank_acct_iban_num
548: IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE,
549: payee_bank_swift_code
550: IBY_EXT_BANK_ACCOUNTS_V.eft_swift_code%TYPE,
551: payee_bank_acct_checkdigits
552: IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,
553: payee_bank_add1
554: VARCHAR2(240),

Line 552: IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,

548: IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE,
549: payee_bank_swift_code
550: IBY_EXT_BANK_ACCOUNTS_V.eft_swift_code%TYPE,
551: payee_bank_acct_checkdigits
552: IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,
553: payee_bank_add1
554: VARCHAR2(240),
555: payee_bank_add2
556: VARCHAR2(240),

Line 574: IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,

570: VARCHAR2(240),
571: payee_bank_branch_name_alt
572: VARCHAR2(240),
573: payee_bank_country_code
574: IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,
575: payee_bank_account_name_alt
576: IBY_EXT_BANK_ACCOUNTS_V.alternate_account_name%TYPE,
577: payee_bank_account_type
578: IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,

Line 576: IBY_EXT_BANK_ACCOUNTS_V.alternate_account_name%TYPE,

572: VARCHAR2(240),
573: payee_bank_country_code
574: IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,
575: payee_bank_account_name_alt
576: IBY_EXT_BANK_ACCOUNTS_V.alternate_account_name%TYPE,
577: payee_bank_account_type
578: IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
579: payee_bank_account_short_name
580: IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,

Line 578: IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,

574: IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,
575: payee_bank_account_name_alt
576: IBY_EXT_BANK_ACCOUNTS_V.alternate_account_name%TYPE,
577: payee_bank_account_type
578: IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
579: payee_bank_account_short_name
580: IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,
581: payee_bank_acct_hold_name_alt
582: VARCHAR2(240)

Line 580: IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,

576: IBY_EXT_BANK_ACCOUNTS_V.alternate_account_name%TYPE,
577: payee_bank_account_type
578: IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
579: payee_bank_account_short_name
580: IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,
581: payee_bank_acct_hold_name_alt
582: VARCHAR2(240)
583: );
584: