General Ledger - EBS (MOSC)

MOSC Banner

Payable

edited Aug 23, 2016 5:00AM in General Ledger - EBS (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center