Payment Method Master Query with all Tab Details

SELECT popmf.org_payment_method_id,

       popmf.org_payment_method_name,

       pea.external_account_id, -- Bank information --> Get Segment Information from "Bank Details KeyFlexField" KF in regard with your legislation

       pea.segment1 bank_segment1, -- Check the KFF, get the look ups used and decode the values of segments

       pea.segment2 bank_segment2,

       pea.segment4 bank_segment4,

       pea.segment5 bank_segment5,

       ppga.set_of_books_id,

       (SELECT name

          FROM gl_ledgers

         WHERE ledger_id = ppga.set_of_books_id)

          ledger_name,

       ppga.gl_cash_ac_id,

       (SELECT    segment1

               || '.'

               || segment2

               || '.'

               || segment3

               || '.'

               || segment4

               || '.'

               || segment5

               || '.'

               || segment6

               || '.'

               || segment7

          FROM gl_code_combinations

         WHERE code_combination_id = ppga.gl_cash_ac_id)

          gl_cash_account,

       ppga.gl_cash_clearing_ac_id,

       (SELECT    segment1

               || '.'

               || segment2

               || '.'

               || segment3

               || '.'

               || segment4

               || '.'

               || segment5

               || '.'

               || segment6

               || '.'

               || segment7

          FROM gl_code_combinations

         WHERE code_combination_id = ppga.gl_cash_clearing_ac_id)

          cash_clearning_account,

       ppga.gl_control_ac_id,

       (SELECT    segment1

               || '.'

               || segment2

               || '.'

               || segment3

               || '.'

               || segment4

               || '.'

               || segment5

               || '.'

               || segment6

               || '.'

               || segment7

          FROM gl_code_combinations

         WHERE code_combination_id = ppga.gl_cash_clearing_ac_id)

          payroll_control_account,

       cbaua.bank_account_id cash_mgmt_bank_account_id,

       cba.bank_account_name cash_mgmt_bank_account_name,

       popmf.transfer_to_gl_flag,

       popmf.cost_payment,

       popmf.cost_cleared_payment,

       popmf.cost_cleared_void_payment

  FROM pay_org_payment_methods_f popmf,

       pay_external_accounts pea,

       pay_payment_gl_accounts_f ppga,

       ce_bank_acct_uses_all cbaua,

       ce_bank_accounts cba

WHERE     popmf.business_group_id = 81

       AND popmf.org_payment_method_id = 72

       AND popmf.external_account_id = pea.external_account_id

       AND TRUNC (SYSDATE) BETWEEN popmf.effective_start_date

                               AND popmf.effective_end_date

       AND pea.enabled_flag = 'Y'

       AND ppga.org_payment_method_id = popmf.org_payment_method_id

       AND TRUNC (SYSDATE) BETWEEN ppga.effective_start_date

                               AND ppga.effective_end_date

       AND cbaua.payroll_bank_account_id = popmf.external_account_id

       AND cba.bank_account_id = cbaua.bank_account_id