Payable
Dear All,
I want to try a select query to all accounts that don't have any transaction
I did this query to all that have less than 5 transactions & it works but how can I know the list of all accounts that doesn't have any transaction
select
cc.SEGMENT1 ||'-' || cc.SEGMENT2||'-' ||cc.SEGMENT3||'-' ||cc.SEGMENT4||'-' ||
cc.SEGMENT5||'-' ||cc.SEGMENT6 ||'-' ||cc.SEGMENT7 ACCOUNTING_FLEXFIELD,
--h.currency_code,
jel.period_name,
count(*)
from
gl_code_combinations cc,
gl_je_lines jel,
gl_je_headers h,
gl_je_batches b,
gl_ledger_relationships lr
Where
cc.code_combination_id(+) = jel.code_combination_id