In
Release 12, each internal bank account is assigned to a Legal Entity.
Any or all operating units associated with that legal entity are
permitted to use that bank account.
- The link between PO_VENDORS and HZ_PARTIES is PO_VENDORS.party_id
- PO_VENDOR_SITES_ALL.party_site_id = HZ_PARTY_SITES.party_site_id
- When a Supplier is created, Record will be Inserted in HZ_PARTIES. When the Supplier Site is created, Record will be Inserted in HZ_PARTY_SITES. When Address is created, Record will be stored in HZ_LOCATIONS
- When a bank is Created, information will be stored in IBY_EXT_BANK_ACCOUNTS
IBY_EXT_BANK_ACCOUNTS.bank_id = HZ_PARTIES.party_id - When the Bank is assigned to Vendors then it will be updated in HZ_CODE_ASSIGNMENTS. HZ_CODE_ASSIGNMENTS.owner_table_id = IBY_EXT_BANK_ACCOUNTS.branch_id
CE_BANK_ACCOUNT: Stores bank account attributesCE_BANK_ACCT_USES_ALL: Stores the bank account use attributes specific to Operating Unit (AR, AP) and Legal Entity (Treasury).
CE_GL_ACCOUNTS_CCID: The accounting data pertaining to the bank account use will be stored in the table