eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_JE_LINES

Product:	PA - Projects
Description:	View of GL journal entry lines for Oracle Projects cost and revenue transactions.
Implementation/DBA Data:	APPS.PA_JE_LINES

View Text

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'

Columns

Name
JE_HEADER_ID
JE_LINE_NUM
LEDGER_ID
CODE_COMBINATION_ID
ENTERED_DR
ENTERED_CR
ACCOUNTED_DR
ACCOUNTED_CR
DESCRIPTION
REFERENCE_1
REFERENCE_2
REFERENCE_3
ORG_ID