38: URI_CHECK_DIGIT IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE,
39: EXTERNAL_BANK_ACCOUNT_ID IBY_DOCS_PAYABLE_ALL.EXTERNAL_BANK_ACCOUNT_ID%TYPE,
40:
41:
42: int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,
43: int_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE,
44: int_bank_name_alt CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
45: int_bank_branch_num CE_BANK_BRANCHES_V.branch_number%TYPE,
46: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
39: EXTERNAL_BANK_ACCOUNT_ID IBY_DOCS_PAYABLE_ALL.EXTERNAL_BANK_ACCOUNT_ID%TYPE,
40:
41:
42: int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,
43: int_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE,
44: int_bank_name_alt CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
45: int_bank_branch_num CE_BANK_BRANCHES_V.branch_number%TYPE,
46: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
47: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
40:
41:
42: int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,
43: int_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE,
44: int_bank_name_alt CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
45: int_bank_branch_num CE_BANK_BRANCHES_V.branch_number%TYPE,
46: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
47: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
48: int_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE, -- bug 16007784
41:
42: int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,
43: int_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE,
44: int_bank_name_alt CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
45: int_bank_branch_num CE_BANK_BRANCHES_V.branch_number%TYPE,
46: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
47: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
48: int_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE, -- bug 16007784
49:
42: int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,
43: int_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE,
44: int_bank_name_alt CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
45: int_bank_branch_num CE_BANK_BRANCHES_V.branch_number%TYPE,
46: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
47: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
48: int_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE, -- bug 16007784
49:
50: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,
43: int_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE,
44: int_bank_name_alt CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
45: int_bank_branch_num CE_BANK_BRANCHES_V.branch_number%TYPE,
46: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
47: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
48: int_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE, -- bug 16007784
49:
50: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,
51: int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,
44: int_bank_name_alt CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
45: int_bank_branch_num CE_BANK_BRANCHES_V.branch_number%TYPE,
46: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
47: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
48: int_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE, -- bug 16007784
49:
50: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,
51: int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,
52: int_bank_acc_name_alt CE_BANK_ACCOUNTS.bank_account_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
83:
84: ext_bank_country IBY_EXT_BANK_ACCOUNTS_V.country_code%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
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,
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,
89:
90: ext_bank_acc_num IBY_EXT_BANK_ACCOUNTS_V.
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,
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,
480: IBY_PP_FIRST_PARTY_V.party_address_postal_code%TYPE,
481:
482: /* PAYER BANK */
483: payer_bank_name
484: CE_BANK_BRANCHES_V.bank_name%TYPE,
485: payer_bank_number
486: CE_BANK_BRANCHES_V.bank_number%TYPE,
487: payer_bank_branch_num
488: CE_BANK_BRANCHES_V.branch_number%TYPE,
482: /* PAYER BANK */
483: payer_bank_name
484: CE_BANK_BRANCHES_V.bank_name%TYPE,
485: payer_bank_number
486: CE_BANK_BRANCHES_V.bank_number%TYPE,
487: payer_bank_branch_num
488: CE_BANK_BRANCHES_V.branch_number%TYPE,
489: payer_bank_branch_name
490: CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
484: CE_BANK_BRANCHES_V.bank_name%TYPE,
485: payer_bank_number
486: CE_BANK_BRANCHES_V.bank_number%TYPE,
487: payer_bank_branch_num
488: CE_BANK_BRANCHES_V.branch_number%TYPE,
489: payer_bank_branch_name
490: CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
491: payer_bank_swift_code
492: CE_BANK_BRANCHES_V.eft_swift_code%TYPE,
486: CE_BANK_BRANCHES_V.bank_number%TYPE,
487: payer_bank_branch_num
488: CE_BANK_BRANCHES_V.branch_number%TYPE,
489: payer_bank_branch_name
490: CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
491: payer_bank_swift_code
492: CE_BANK_BRANCHES_V.eft_swift_code%TYPE,
493: payer_bank_add1
494: CE_BANK_BRANCHES_V.address_line1%TYPE,
488: CE_BANK_BRANCHES_V.branch_number%TYPE,
489: payer_bank_branch_name
490: CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
491: payer_bank_swift_code
492: CE_BANK_BRANCHES_V.eft_swift_code%TYPE,
493: payer_bank_add1
494: CE_BANK_BRANCHES_V.address_line1%TYPE,
495: payer_bank_add2
496: CE_BANK_BRANCHES_V.address_line2%TYPE,
490: CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
491: payer_bank_swift_code
492: CE_BANK_BRANCHES_V.eft_swift_code%TYPE,
493: payer_bank_add1
494: CE_BANK_BRANCHES_V.address_line1%TYPE,
495: payer_bank_add2
496: CE_BANK_BRANCHES_V.address_line2%TYPE,
497: payer_bank_add3
498: CE_BANK_BRANCHES_V.address_line3%TYPE,
492: CE_BANK_BRANCHES_V.eft_swift_code%TYPE,
493: payer_bank_add1
494: CE_BANK_BRANCHES_V.address_line1%TYPE,
495: payer_bank_add2
496: CE_BANK_BRANCHES_V.address_line2%TYPE,
497: payer_bank_add3
498: CE_BANK_BRANCHES_V.address_line3%TYPE,
499: payer_bank_city
500: CE_BANK_BRANCHES_V.city%TYPE,
494: CE_BANK_BRANCHES_V.address_line1%TYPE,
495: payer_bank_add2
496: CE_BANK_BRANCHES_V.address_line2%TYPE,
497: payer_bank_add3
498: CE_BANK_BRANCHES_V.address_line3%TYPE,
499: payer_bank_city
500: CE_BANK_BRANCHES_V.city%TYPE,
501: payer_bank_county
502: CE_BANK_BRANCHES_V.province%TYPE,
496: CE_BANK_BRANCHES_V.address_line2%TYPE,
497: payer_bank_add3
498: CE_BANK_BRANCHES_V.address_line3%TYPE,
499: payer_bank_city
500: CE_BANK_BRANCHES_V.city%TYPE,
501: payer_bank_county
502: CE_BANK_BRANCHES_V.province%TYPE,
503: payer_bank_state
504: CE_BANK_BRANCHES_V.state%TYPE,
498: CE_BANK_BRANCHES_V.address_line3%TYPE,
499: payer_bank_city
500: CE_BANK_BRANCHES_V.city%TYPE,
501: payer_bank_county
502: CE_BANK_BRANCHES_V.province%TYPE,
503: payer_bank_state
504: CE_BANK_BRANCHES_V.state%TYPE,
505: payer_bank_country
506: CE_BANK_BRANCHES_V.country%TYPE,
500: CE_BANK_BRANCHES_V.city%TYPE,
501: payer_bank_county
502: CE_BANK_BRANCHES_V.province%TYPE,
503: payer_bank_state
504: CE_BANK_BRANCHES_V.state%TYPE,
505: payer_bank_country
506: CE_BANK_BRANCHES_V.country%TYPE,
507: payer_bank_postcode
508: CE_BANK_BRANCHES_V.zip%TYPE,
502: CE_BANK_BRANCHES_V.province%TYPE,
503: payer_bank_state
504: CE_BANK_BRANCHES_V.state%TYPE,
505: payer_bank_country
506: CE_BANK_BRANCHES_V.country%TYPE,
507: payer_bank_postcode
508: CE_BANK_BRANCHES_V.zip%TYPE,
509: payer_bank_name_alt
510: CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
504: CE_BANK_BRANCHES_V.state%TYPE,
505: payer_bank_country
506: CE_BANK_BRANCHES_V.country%TYPE,
507: payer_bank_postcode
508: CE_BANK_BRANCHES_V.zip%TYPE,
509: payer_bank_name_alt
510: CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
511: payer_bank_branch_name_alt
512: CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
506: CE_BANK_BRANCHES_V.country%TYPE,
507: payer_bank_postcode
508: CE_BANK_BRANCHES_V.zip%TYPE,
509: payer_bank_name_alt
510: CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
511: payer_bank_branch_name_alt
512: CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
513:
514: payer_bank_acct_name_alt
508: CE_BANK_BRANCHES_V.zip%TYPE,
509: payer_bank_name_alt
510: CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
511: payer_bank_branch_name_alt
512: CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
513:
514: payer_bank_acct_name_alt
515: CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
516: payer_bank_acct_type