PLSQL Query to find Journal Line Types (JLT) for Event Classes - Oracle RBS R12

https://systemadministratorsys.blogspot.com/2018/07/plsql-query-to-find-journal-line-types.html

PLSQL Query to find Journal Line Types (JLT) for Event Classes

SELECT accounting_line_code,
name,
l.meaning accounting_line_type,
event_class_name,
event_class_code,
entity_code
FROM xla_acct_line_types_fvl s,
xla_lookups l
WHERE s.amb_context_code = 'DEFAULT'
AND s.application_id = '222' -- Receivables
AND s.accounting_line_type_code = 'S'
AND s.accounting_line_type_code = l.lookup_code
AND l.lookup_type = 'XLA_OWNER_TYPE'
ORDER BY accounting_line_code,
name,
event_class_name,
accounting_line_type