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 CE_BANK_BRANCHES_V

Line 40: int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,

36: REMITTANCE_MESSAGE3 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE3%TYPE,
37: URI_CHECK_DIGIT IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE,
38:
39:
40: int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,
41: int_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE,
42: int_bank_name_alt CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
43: int_bank_branch_num CE_BANK_BRANCHES_V.branch_number%TYPE,
44: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,

Line 41: int_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE,

37: URI_CHECK_DIGIT IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE,
38:
39:
40: int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,
41: int_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE,
42: int_bank_name_alt CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
43: int_bank_branch_num CE_BANK_BRANCHES_V.branch_number%TYPE,
44: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
45: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,

Line 42: int_bank_name_alt CE_BANK_BRANCHES_V.bank_name_alt%TYPE,

38:
39:
40: int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,
41: int_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE,
42: int_bank_name_alt CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
43: int_bank_branch_num CE_BANK_BRANCHES_V.branch_number%TYPE,
44: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
45: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
46:

Line 43: int_bank_branch_num CE_BANK_BRANCHES_V.branch_number%TYPE,

39:
40: int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,
41: int_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE,
42: int_bank_name_alt CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
43: int_bank_branch_num CE_BANK_BRANCHES_V.branch_number%TYPE,
44: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
45: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
46:
47: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,

Line 44: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,

40: int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,
41: int_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE,
42: int_bank_name_alt CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
43: int_bank_branch_num CE_BANK_BRANCHES_V.branch_number%TYPE,
44: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
45: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
46:
47: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,
48: int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,

Line 45: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,

41: int_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE,
42: int_bank_name_alt CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
43: int_bank_branch_num CE_BANK_BRANCHES_V.branch_number%TYPE,
44: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
45: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
46:
47: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,
48: int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,
49: int_bank_acc_name_alt CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,

Line 75: ext_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_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,
78:
79: ext_bank_branch_addr1 CE_BANK_BRANCHES_V.address_line1%TYPE,

Line 79: ext_bank_branch_addr1 CE_BANK_BRANCHES_V.address_line1%TYPE,

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,
82:
83: ext_bank_acc_num IBY_EXT_BANK_ACCOUNTS_V.

Line 81: ext_bank_branch_country CE_BANK_BRANCHES_V.country%TYPE,

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,
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,

Line 266: int_bank_country_cd CE_BANK_BRANCHES_V.

262: int_bank_acct_id IBY_DOCS_PAYABLE_ALL.
263: internal_bank_account_id%TYPE,
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.

Line 449: CE_BANK_BRANCHES_V.bank_name%TYPE,

445: IBY_PP_FIRST_PARTY_V.party_address_postal_code%TYPE,
446:
447: /* PAYER BANK */
448: payer_bank_name
449: CE_BANK_BRANCHES_V.bank_name%TYPE,
450: payer_bank_number
451: CE_BANK_BRANCHES_V.bank_number%TYPE,
452: payer_bank_branch_num
453: CE_BANK_BRANCHES_V.branch_number%TYPE,

Line 451: CE_BANK_BRANCHES_V.bank_number%TYPE,

447: /* PAYER BANK */
448: payer_bank_name
449: CE_BANK_BRANCHES_V.bank_name%TYPE,
450: payer_bank_number
451: CE_BANK_BRANCHES_V.bank_number%TYPE,
452: payer_bank_branch_num
453: CE_BANK_BRANCHES_V.branch_number%TYPE,
454: payer_bank_branch_name
455: CE_BANK_BRANCHES_V.bank_branch_name%TYPE,

Line 453: CE_BANK_BRANCHES_V.branch_number%TYPE,

449: CE_BANK_BRANCHES_V.bank_name%TYPE,
450: payer_bank_number
451: CE_BANK_BRANCHES_V.bank_number%TYPE,
452: payer_bank_branch_num
453: CE_BANK_BRANCHES_V.branch_number%TYPE,
454: payer_bank_branch_name
455: CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
456: payer_bank_swift_code
457: CE_BANK_BRANCHES_V.eft_swift_code%TYPE,

Line 455: CE_BANK_BRANCHES_V.bank_branch_name%TYPE,

451: CE_BANK_BRANCHES_V.bank_number%TYPE,
452: payer_bank_branch_num
453: CE_BANK_BRANCHES_V.branch_number%TYPE,
454: payer_bank_branch_name
455: CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
456: payer_bank_swift_code
457: CE_BANK_BRANCHES_V.eft_swift_code%TYPE,
458: payer_bank_add1
459: CE_BANK_BRANCHES_V.address_line1%TYPE,

Line 457: CE_BANK_BRANCHES_V.eft_swift_code%TYPE,

453: CE_BANK_BRANCHES_V.branch_number%TYPE,
454: payer_bank_branch_name
455: CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
456: payer_bank_swift_code
457: CE_BANK_BRANCHES_V.eft_swift_code%TYPE,
458: payer_bank_add1
459: CE_BANK_BRANCHES_V.address_line1%TYPE,
460: payer_bank_add2
461: CE_BANK_BRANCHES_V.address_line2%TYPE,

Line 459: CE_BANK_BRANCHES_V.address_line1%TYPE,

455: CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
456: payer_bank_swift_code
457: CE_BANK_BRANCHES_V.eft_swift_code%TYPE,
458: payer_bank_add1
459: CE_BANK_BRANCHES_V.address_line1%TYPE,
460: payer_bank_add2
461: CE_BANK_BRANCHES_V.address_line2%TYPE,
462: payer_bank_add3
463: CE_BANK_BRANCHES_V.address_line3%TYPE,

Line 461: CE_BANK_BRANCHES_V.address_line2%TYPE,

457: CE_BANK_BRANCHES_V.eft_swift_code%TYPE,
458: payer_bank_add1
459: CE_BANK_BRANCHES_V.address_line1%TYPE,
460: payer_bank_add2
461: CE_BANK_BRANCHES_V.address_line2%TYPE,
462: payer_bank_add3
463: CE_BANK_BRANCHES_V.address_line3%TYPE,
464: payer_bank_city
465: CE_BANK_BRANCHES_V.city%TYPE,

Line 463: CE_BANK_BRANCHES_V.address_line3%TYPE,

459: CE_BANK_BRANCHES_V.address_line1%TYPE,
460: payer_bank_add2
461: CE_BANK_BRANCHES_V.address_line2%TYPE,
462: payer_bank_add3
463: CE_BANK_BRANCHES_V.address_line3%TYPE,
464: payer_bank_city
465: CE_BANK_BRANCHES_V.city%TYPE,
466: payer_bank_county
467: CE_BANK_BRANCHES_V.province%TYPE,

Line 465: CE_BANK_BRANCHES_V.city%TYPE,

461: CE_BANK_BRANCHES_V.address_line2%TYPE,
462: payer_bank_add3
463: CE_BANK_BRANCHES_V.address_line3%TYPE,
464: payer_bank_city
465: CE_BANK_BRANCHES_V.city%TYPE,
466: payer_bank_county
467: CE_BANK_BRANCHES_V.province%TYPE,
468: payer_bank_state
469: CE_BANK_BRANCHES_V.state%TYPE,

Line 467: CE_BANK_BRANCHES_V.province%TYPE,

463: CE_BANK_BRANCHES_V.address_line3%TYPE,
464: payer_bank_city
465: CE_BANK_BRANCHES_V.city%TYPE,
466: payer_bank_county
467: CE_BANK_BRANCHES_V.province%TYPE,
468: payer_bank_state
469: CE_BANK_BRANCHES_V.state%TYPE,
470: payer_bank_country
471: CE_BANK_BRANCHES_V.country%TYPE,

Line 469: CE_BANK_BRANCHES_V.state%TYPE,

465: CE_BANK_BRANCHES_V.city%TYPE,
466: payer_bank_county
467: CE_BANK_BRANCHES_V.province%TYPE,
468: payer_bank_state
469: CE_BANK_BRANCHES_V.state%TYPE,
470: payer_bank_country
471: CE_BANK_BRANCHES_V.country%TYPE,
472: payer_bank_postcode
473: CE_BANK_BRANCHES_V.zip%TYPE,

Line 471: CE_BANK_BRANCHES_V.country%TYPE,

467: CE_BANK_BRANCHES_V.province%TYPE,
468: payer_bank_state
469: CE_BANK_BRANCHES_V.state%TYPE,
470: payer_bank_country
471: CE_BANK_BRANCHES_V.country%TYPE,
472: payer_bank_postcode
473: CE_BANK_BRANCHES_V.zip%TYPE,
474: payer_bank_name_alt
475: CE_BANK_BRANCHES_V.bank_name_alt%TYPE,

Line 473: CE_BANK_BRANCHES_V.zip%TYPE,

469: CE_BANK_BRANCHES_V.state%TYPE,
470: payer_bank_country
471: CE_BANK_BRANCHES_V.country%TYPE,
472: payer_bank_postcode
473: CE_BANK_BRANCHES_V.zip%TYPE,
474: payer_bank_name_alt
475: CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
476: payer_bank_branch_name_alt
477: CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,

Line 475: CE_BANK_BRANCHES_V.bank_name_alt%TYPE,

471: CE_BANK_BRANCHES_V.country%TYPE,
472: payer_bank_postcode
473: CE_BANK_BRANCHES_V.zip%TYPE,
474: payer_bank_name_alt
475: CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
476: payer_bank_branch_name_alt
477: CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
478:
479: payer_bank_acct_name_alt

Line 477: CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,

473: CE_BANK_BRANCHES_V.zip%TYPE,
474: payer_bank_name_alt
475: CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
476: payer_bank_branch_name_alt
477: CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
478:
479: payer_bank_acct_name_alt
480: CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
481: payer_bank_acct_type