11i_Bank_Details

        
SELECT   D.NAME OPERATING_UNIT,
         SHORT_NAME SOB_NAME,
         A.BANK_ACCOUNT_NAME,
         A.BANK_ACCOUNT_TYPE,
         A.BANK_ACCOUNT_NUM,
         A.DESCRIPTION,
         A.MAX_CHECK_AMOUNT,
         A.MIN_CHECK_AMOUNT,
         A.MULTI_CURRENCY_FLAG,
         A.CURRENCY_CODE,
         A.ACCOUNT_TYPE,
         A.ACCOUNT_HOLDER_NAME,
         C.BANK_NAME,
         C.ADDRESS_LINE1,
         C.ADDRESS_LINE2,
         C.ADDRESS_LINE3,
         C.CITY,
         C.STATE,
         C.ZIP,
         C.PROVINCE,
         C.COUNTRY,
         C.BANK_BRANCH_NAME,
         F.CONCATENATED_SEGMENTS
  FROM   AP_BANK_ACCOUNTS_ALL A,
         AP_BANK_ACCOUNT_USES_ALL B,
         AP_BANK_BRANCHES C,
         HR_OPERATING_UNITS D,
         gl_sets_of_books E,
         gl_code_combinations_kfv F
 WHERE       A.BANK_ACCOUNT_ID = B.BANK_ACCOUNT_USES_ID(+)
         AND A.BANK_BRANCH_ID = C.BANK_BRANCH_ID
         AND A.ORG_ID = D.ORGANIZATION_ID
         AND D.SET_OF_BOOKS_ID = E.SET_OF_BOOKS_ID
         AND A.ON_ACCOUNT_CCID = f.CODE_COMBINATION_ID(+)
         AND A.SET_OF_BOOKS_ID = 5