To check Bank Account GL_Code_Combination Assigned

http://aporaclepayables.blogspot.com/2016/10/to-check-bank-location.html

AP

select kk.BANK_ACCOUNT_NAME,
       kk.BANK_ACCOUNT_NUM,
       kk.BANK_ACCOUNT_ID,
       kk.AP_USE_ALLOWED_FLAG,
       gc1.SEGMENT2 General_Controls,
       gc2.SEGMENT2 AP_OPTIONS
  from ce_bank_accounts      kk,
       CE_BANK_ACCT_USES_ALL ll,
       CE_GL_ACCOUNTS_CCID   tt,
       gl_code_combinations  gc1,
       gl_code_combinations  gc2
 where kk.BANK_ACCOUNT_ID = ll.BANK_ACCOUNT_ID
   and ll.BANK_ACCT_USE_ID = tt.BANK_ACCT_USE_ID
   and kk.ASSET_CODE_COMBINATION_ID = gc1.CODE_COMBINATION_ID
   and tt.AP_ASSET_CCID = gc2.CODE_COMBINATION_ID
   and gc1.SEGMENT2!=gc2.SEGMENT2

--------------------------------------------------------------------------------------------------------------------------

AR

select kk.BANK_ACCOUNT_NAME,
       kk.BANK_ACCOUNT_NUM,
       kk.BANK_ACCOUNT_ID,
       kk.AR_USE_ALLOWED_FLAG,
       gc1.SEGMENT2 General_Controls,
       gc2.SEGMENT2 AR_OPTIONS
  from ce_bank_accounts      kk,
       CE_BANK_ACCT_USES_ALL ll,
       CE_GL_ACCOUNTS_CCID   tt,
       gl_code_combinations  gc1,
       gl_code_combinations  gc2
 where kk.BANK_ACCOUNT_ID = ll.BANK_ACCOUNT_ID
   and ll.BANK_ACCT_USE_ID = tt.BANK_ACCT_USE_ID
   and kk.ASSET_CODE_COMBINATION_ID = gc1.CODE_COMBINATION_ID
   and tt.AR_ASSET_CCID = gc2.CODE_COMBINATION_ID
   and gc1.SEGMENT2!=gc2.SEGMENT2