[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 |