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
No comments:
Post a Comment