Thursday, February 2, 2017

Query to find Bank details is R12


SELECT    HOU.NAME OPERATING_UNIT,
                  BNK.BANK_ACCOUNT_NUM,
                  BRNCH.BANK_NAME,
                  BRNCH.BANK_BRANCH_TYPE,
                  BRNCH.BANK_BRANCH_NAME,
                  BRNCH.DESCRIPTION
  FROM   CE_BANK_ACCOUNTS BNK,
         CE_BANK_ACCT_USES_ALL SITE,
         CEFV_BANK_BRANCHES BRNCH,
         HR_OPERATING_UNITS HOU
 WHERE       BNK.BANK_ACCOUNT_ID = SITE.BANK_ACCOUNT_ID
         AND BRNCH.BANK_BRANCH_ID = BNK.BANK_BRANCH_ID
         AND HOU.ORGANIZATION_ID = SITE.ORG_ID

==========================================================================


SELECT   HOU.NAME OPERATING_UNIT,
         sob.SHORT_NAME sob_name,
         BRNCH.BANK_NAME,                                 
         BRNCH.BANK_BRANCH_NAME,                  
         BNK.DESCRIPTION,
         BRNCH.ADDRESS_LINE1,
         BRNCH.ADDRESS_LINE2,
         BRNCH.ADDRESS_LINE3,
         BRNCH.ADDRESS_LINE4,
         BRNCH.CITY,
         BRNCH.STATE,
         BRNCH.ZIP_CODE,
         BRNCH.COUNTRY,
         BNK.BANK_ACCOUNT_NAME,
         BNK.BANK_ACCOUNT_TYPE,
         BNK.BANK_ACCOUNT_NUM,
         BNK.MULTI_CURRENCY_ALLOWED_FLAG,
         BNK.MULTI_CURRENCY_ALLOWED_FLAG,
         BNK.ACCOUNT_CLASSIFICATION,
         BNK.ZERO_AMOUNT_ALLOWED,
         BNK.MAX_CHECK_AMOUNT,
         BNK.RECEIPT_MULTI_CURRENCY_FLAG,
         BNK.CURRENCY_CODE,
         BNK.ACCOUNT_HOLDER_NAME,
         gcf.CONCATENATED_SEGMENTS
  FROM   CE_BANK_ACCOUNTS BNK,
         CE_BANK_ACCT_USES_ALL SITE,
         CEFV_BANK_BRANCHES BRNCH,
         HR_OPERATING_UNITS HOU,
         gl_sets_of_books sob,
         gl_code_combinations_kfv gcf
 WHERE       BNK.BANK_ACCOUNT_ID = SITE.BANK_ACCOUNT_ID
         AND BRNCH.BANK_BRANCH_ID = BNK.BANK_BRANCH_ID
         AND HOU.ORGANIZATION_ID = SITE.ORG_ID
         AND sob.SET_OF_BOOKS_ID = HOU.SET_OF_BOOKS_ID
         AND BNK.ASSET_CODE_COMBINATION_ID = gcf.CODE_COMBINATION_ID

No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...