In R12 This field has been renamed to set_of_books_id_11i and there is no LEDger_ID field in this table.
After searching a lot, I discovered that it is possible as follows:
SELECT *
FROM GL_JE_BATCHES
WHERE je_batch_id IN
(SELECT DISTINCT h.je_batch_id
FROM gl_je_headers h
WHERE h.ledger_id = :$PROFILES$.GL_SET_OF_BKS_ID
)
ORDER BY NAME
Does anyone there have any solution for this case?