DBA Data[Home] [Help]

APPS.IBY_VALIDATIONSETS_PUB dependencies on CE_BANK_BRANCHES_V

Line 42: int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,

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,

Line 43: int_bank_name CE_BANK_BRANCHES_V.bank_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,

Line 44: int_bank_name_alt CE_BANK_BRANCHES_V.bank_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

Line 45: int_bank_branch_num CE_BANK_BRANCHES_V.branch_number%TYPE,

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:

Line 46: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,

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,

Line 47: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%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,

Line 48: int_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE, -- bug 16007784

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,

Line 80: ext_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_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,

Line 82: ext_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE, -- bug 16007784

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,

Line 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.

Line 88: ext_bank_branch_country CE_BANK_BRANCHES_V.country%TYPE,

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,

Line 484: CE_BANK_BRANCHES_V.bank_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,

Line 486: CE_BANK_BRANCHES_V.bank_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,

Line 488: CE_BANK_BRANCHES_V.branch_number%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,

Line 490: CE_BANK_BRANCHES_V.bank_branch_name%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,

Line 492: CE_BANK_BRANCHES_V.eft_swift_code%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,

Line 494: CE_BANK_BRANCHES_V.address_line1%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,

Line 496: CE_BANK_BRANCHES_V.address_line2%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,

Line 498: CE_BANK_BRANCHES_V.address_line3%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,

Line 500: CE_BANK_BRANCHES_V.city%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,

Line 502: CE_BANK_BRANCHES_V.province%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,

Line 504: CE_BANK_BRANCHES_V.state%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,

Line 506: CE_BANK_BRANCHES_V.country%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,

Line 508: CE_BANK_BRANCHES_V.zip%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,

Line 510: CE_BANK_BRANCHES_V.bank_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

Line 512: CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,

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