Tuesday, January 25, 2022

Query to get Supplier Site Level Bank Account in Oracle APPS

SELECT bank_account_name
              ,bank_account_num
  FROM iby_ext_bank_accounts
 WHERE ext_bank_account_id IN ( SELECT ext_bank_account_id
                                  FROM iby_account_owners
                                 WHERE account_owner_party_id
                                    IN ( SELECT party_id
      FROM hz_party_sites
   WHERE party_site_name = 'SUPPLIER_SITE_NAME'
)
)

2 comments:

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...