VIEW: APPS.PA_JE_LINES

Source

View Text - Preformatted

SELECT l.je_header_id , l.je_line_num , l.ledger_id , l.code_combination_id , l.entered_dr , l.entered_cr , l.accounted_dr , l.accounted_cr , l.description , l.reference_1 , l.reference_2 , l.reference_3 , i.org_id FROM gl_je_lines l, gl_je_headers h, pa_implementations i WHERE l.je_header_id = h.je_header_id AND h.je_source = 'Project Accounting'

View Text - HTML Formatted

SELECT L.JE_HEADER_ID
, L.JE_LINE_NUM
, L.LEDGER_ID
, L.CODE_COMBINATION_ID
, L.ENTERED_DR
, L.ENTERED_CR
, L.ACCOUNTED_DR
, L.ACCOUNTED_CR
, L.DESCRIPTION
, L.REFERENCE_1
, L.REFERENCE_2
, L.REFERENCE_3
, I.ORG_ID
FROM GL_JE_LINES L
, GL_JE_HEADERS H
, PA_IMPLEMENTATIONS I
WHERE L.JE_HEADER_ID = H.JE_HEADER_ID
AND H.JE_SOURCE = 'PROJECT ACCOUNTING'