View gl_je_journal_lines_v not returning any data in R12
Hello All,
Database view View gl_je_journal_lines_v not returning any data in R12. Is this view still relevant? What can be done to retrieve data from query like below:
SELECT BATCH_NAME as batch, HEADER_NAME as Juneral_Entry, JE_SOURCE as Source,
LINE_JE_LINE_NUM, LINE_ENTERED_DR_NUM as Entered_Debit,
LINE_ENTERED_CR_NUM as Entered_Credit, JE_HEADER_ID, PERIOD_NAME
FROM apps.GL_JE_JOURNAL_LINES_V,
apps.GL_SUMMARY_COMBINATIONS_V
WHERE GL_JE_JOURNAL_LINES_V.line_code_combination_id = GL_SUMMARY_COMBINATIONS_V.CODE_COMBINATION_ID
and nvl(batch_status, ' ') = 'P'