General Ledger - EBS (MOSC)

MOSC Banner

Query for finding Journals with no attachments

edited Aug 14, 2018 9:39AM in General Ledger - EBS (MOSC) 3 commentsAnswered ✓

I am trying to get  query written up that will find manual journals that are posted and do not have attachments. So far I have:

select * from gl_je_batches

where je_batch_id in

    (select pk1_value

    from fnd_attached_documents

    WHERE entity_name = 'GL_JE_HEADERS')

and

select * from gl_je_headers

where JE_batch_id = 9975

and je_batch_id in

    (select pk2_value

    from fnd_attached_documents

    WHERE entity_name = 'GL_JE_HEADERS');

The 2nd one will be blank if my JE_BATCH_ID does not have an attachment. However, I am trying to get it to show all journals that do not have an attachment and this is where I am getting stuck.

Tagged:

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