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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PA_JE_LINES

Object Details

Object Name:	PA_JE_LINES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_JE_LINES
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
JE_HEADER_ID	NUMBER	(15)	Yes	The identifier of the journal entry header
JE_LINE_NUM	NUMBER	(15)	Yes	The number of the journal entry line
LEDGER_ID	NUMBER	(15)	Yes	The identifier of the ledger under which the journal entry is posted.
CODE_COMBINATION_ID	NUMBER	(15)	Yes	The identifier of the GL account to which the journal entry is posted
ENTERED_DR	NUMBER			The debit amount entered
ENTERED_CR	NUMBER			The credit amount entered
ACCOUNTED_DR	NUMBER			The debit amount accounted for
ACCOUNTED_CR	NUMBER			The credit amount accounted for
DESCRIPTION	VARCHAR2	(240)		The description of the journal entry line
REFERENCE_1	VARCHAR2	(240)		The reference to cost and revenue distribution lines and UBR/UER amounts summarized and transferred from Oracle Projects. This column holds the ccid, gl date, and transfer request id separated by hyphens.
REFERENCE_2	VARCHAR2	(240)		The ccid of the distribution lines summarized and transferred. For cost lines, this holds the liability account. For revenue lines, this holds the ccid of the je line.
REFERENCE_3	VARCHAR2	(240)		The reference to the type of lines transferred. For cost lines, the values may be "Cost" or "Liability". For revenue lines, the values may be "Revenue - Normal Revenue", "Revenue - Event Revenue", "Revenue - UBR", and "Revenue - UER".
ORG_ID	NUMBER	(15)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.PA_JE_LINES;

Dependencies

[top of page]

APPS.PA_JE_LINES references the following:

APPS: GL_JE_HEADERS; GL_JE_LINES; PA_IMPLEMENTATIONS

APPS.PA_JE_LINES is not referenced by any database object