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.XLA_JE_EXTRACT_V

Object Details

Object Name:	XLA_JE_EXTRACT_V
Object Type:	VIEW
Owner:	APPS
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
APPLICATION_ID	NUMBER	(15)	Yes	Internal identifier of the application associated with the event.
ACCOUNTING_DATE	DATE		Yes	Accounting Date
LEDGER_ID	NUMBER	(15)	Yes	Ledger identifier
AE_HEADER_ID	NUMBER	(15)	Yes	Accounting entry id
GROUP_ID	NUMBER	(15)		Interface group identifying column.
ACCOUNTING_ENTRY_STATUS_CODE	VARCHAR2	(30)	Yes	Accounting entry status code
GL_TRANSFER_STATUS_CODE	VARCHAR2	(30)	Yes	General Ledger transfer status code
AE_LINE_NUM	NUMBER	(15)	Yes	Line number
FOREIGN_AMOUNT	NUMBER			Foreign amount
MONETARY_AMOUNT	NUMBER			Monetary amount
RT_TYPE	VARCHAR2	(30)		RT Type
RT_MULT	NUMBER			RT Mult
FOREIGN_CURRENCY	VARCHAR2	(15)	Yes	Foreign Currency
CURRENCY_CD	VARCHAR2	(15)	Yes	Currency CD
LINE_DESCRIPTION	VARCHAR2	(30)		Line description
MOVEMENT	CHAR	(1)		Movement
GL_SL_LINK_ID	NUMBER	(15)		Identifier used for maintaining audit trail upon transfer of the accounting entry line to GL
GL_SL_LINK_TABLE	VARCHAR2	(30)		Table containing associated subledger data
CODE_COMBINATION_ID	NUMBER	(15)	Yes	Account code combination Id
SEGMENT1	VARCHAR2	(25)		Code Combination Segment value
SEGMENT2	VARCHAR2	(25)		Code Combination Segment value
SEGMENT3	VARCHAR2	(25)		Code Combination Segment value
SEGMENT4	VARCHAR2	(25)		Code Combination Segment value
SEGMENT5	VARCHAR2	(25)		Code Combination Segment value
SEGMENT6	VARCHAR2	(25)		Code Combination Segment value
SEGMENT7	VARCHAR2	(25)		Code Combination Segment value
SEGMENT8	VARCHAR2	(25)		Code Combination Segment value
SEGMENT9	VARCHAR2	(25)		Code Combination Segment value
SEGMENT10	VARCHAR2	(25)		Code Combination Segment value
SEGMENT11	VARCHAR2	(25)		Code Combination Segment value
SEGMENT12	VARCHAR2	(25)		Code Combination Segment value
SEGMENT13	VARCHAR2	(25)		Code Combination Segment value
SEGMENT14	VARCHAR2	(25)		Code Combination Segment value
SEGMENT15	VARCHAR2	(25)		Code Combination Segment value
SEGMENT16	VARCHAR2	(25)		Code Combination Segment value
SEGMENT17	VARCHAR2	(25)		Code Combination Segment value
SEGMENT18	VARCHAR2	(25)		Code Combination Segment value
SEGMENT19	VARCHAR2	(25)		Code Combination Segment value
SEGMENT20	VARCHAR2	(25)		Code Combination Segment value
SEGMENT21	VARCHAR2	(25)		Code Combination Segment value
SEGMENT22	VARCHAR2	(25)		Code Combination Segment value
SEGMENT23	VARCHAR2	(25)		Code Combination Segment value
SEGMENT24	VARCHAR2	(25)		Code Combination Segment value
SEGMENT25	VARCHAR2	(25)		Code Combination Segment value
SEGMENT26	VARCHAR2	(25)		Code Combination Segment value
SEGMENT27	VARCHAR2	(25)		Code Combination Segment value
SEGMENT28	VARCHAR2	(25)		Code Combination Segment value
SEGMENT29	VARCHAR2	(25)		Code Combination Segment value
SEGMENT30	VARCHAR2	(25)		Code Combination Segment value
JOURNAL_REF	VARCHAR2	(50)	Yes	Journal Reference
BUSINESS_UNIT_GL	VARCHAR2	(20)	Yes	Business Unit GL
BUSINESS_UNIT	VARCHAR2	(20)	Yes	Business Unit
APPL_JRNL_ID	VARCHAR2	(0)		Application Journal ID
EVENT_ID	NUMBER	(15)	Yes	Event id
INTERUNIT_AFFILIATE	VARCHAR2	(0)		InterUnit Affiliate

Query Text

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


SELECT APPLICATION_ID
,      ACCOUNTING_DATE
,      LEDGER_ID
,      AE_HEADER_ID
,      GROUP_ID
,      ACCOUNTING_ENTRY_STATUS_CODE
,      GL_TRANSFER_STATUS_CODE
,      AE_LINE_NUM
,      FOREIGN_AMOUNT
,      MONETARY_AMOUNT
,      RT_TYPE
,      RT_MULT
,      FOREIGN_CURRENCY
,      CURRENCY_CD
,      LINE_DESCRIPTION
,      MOVEMENT
,      GL_SL_LINK_ID
,      GL_SL_LINK_TABLE
,      CODE_COMBINATION_ID
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      JOURNAL_REF
,      BUSINESS_UNIT_GL
,      BUSINESS_UNIT
,      APPL_JRNL_ID
,      EVENT_ID
,      INTERUNIT_AFFILIATE
FROM APPS.XLA_JE_EXTRACT_V;

Dependencies

[top of page]

APPS.XLA_JE_EXTRACT_V references the following:

APPS: FND_APPLICATION; GL_CODE_COMBINATIONS; GL_DAILY_CONVERSION_TYPES; GL_LEDGERS; XLA_AE_HEADERS; XLA_AE_LINES

APPS.XLA_JE_EXTRACT_V is not referenced by any database object