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]

TABLE: GL.GL_IEA_INTERFACE

Object Details

Object Name:	GL_IEA_INTERFACE
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_IEA_INTERFACE
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.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_IEA_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	GROUP_ID TRANSACTION_TYPE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_ID	NUMBER	(15)	Yes	Interface group defining column
TRANSACTION_TYPE_ID	NUMBER	(15)	Yes	Transaction type defining column
TRANSACTION_STATUS_CODE	VARCHAR2	(1)	Yes	Transaction status
CURRENCY_CODE	VARCHAR2	(15)	Yes	Transaction currency
GL_DATE	DATE		Yes	Accounting date for the transaction
SENDER_SUBSIDIARY_ID	NUMBER	(15)	Yes	Sending subsidiary defining column
RECEIVER_SUBSIDIARY_ID	NUMBER	(15)	Yes	Receiving subsidiary defining column
LINE_TYPE	VARCHAR2	(1)	Yes	Line type defining column (clearing or distribution)
TRANSACTION_NUMBER	VARCHAR2	(20)		Transaction number
DESCRIPTION	VARCHAR2	(240)		Intercompany transaction description
NOTE	VARCHAR2	(2000)		Intercompany transaction note
SENDER_CODE_COMBINATION_ID	NUMBER	(15)		Sending subsidiary key flexfield defining column
RECEIVER_CODE_COMBINATION_ID	NUMBER	(15)		Receiving subsidiary key flexfield defining column
SENDER_SEGMENT1	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT2	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT3	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT4	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT5	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT6	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT7	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT8	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT9	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT10	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT11	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT12	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT13	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT14	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT15	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT16	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT17	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT18	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT19	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT20	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT21	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT22	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT23	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT24	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT25	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT26	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT27	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT28	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT29	VARCHAR2	(25)		Sending subsidiary key flexfield segment
SENDER_SEGMENT30	VARCHAR2	(25)		Sending subsidiary key flexfield segment
RECEIVER_SEGMENT1	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT2	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT3	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT4	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT5	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT6	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT7	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT8	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT9	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT10	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT11	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT12	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT13	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT14	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT15	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT16	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT17	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT18	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT19	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT20	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT21	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT22	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT23	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT24	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT25	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT26	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT27	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT28	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT29	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT30	VARCHAR2	(25)		Receiving subsidiary key flexfield segment
LINE_DEBIT	NUMBER			Transaction line debit amount
LINE_CREDIT	NUMBER			Transaction line credit amount
LAST_MODIFIED_BY	NUMBER	(15)		Defining column for user who last modified the row
LAST_MODIFICATION_DATE	DATE			Last modified date
SENDER_CHART_OF_ACCOUNTS_ID	NUMBER	(15)		Sending subsidiary Key flexfield structure defining column
RECEIVER_CHART_OF_ACCOUNTS_ID	NUMBER	(15)		Receiving subsidiary key flexfield structure defining column
REQUEST_ID	NUMBER	(15)		Concurrent program request ID
COMPLETION_STATUS_CODE	VARCHAR2	(1000)		Status of row at completion

Query Text

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


SELECT GROUP_ID
,      TRANSACTION_TYPE_ID
,      TRANSACTION_STATUS_CODE
,      CURRENCY_CODE
,      GL_DATE
,      SENDER_SUBSIDIARY_ID
,      RECEIVER_SUBSIDIARY_ID
,      LINE_TYPE
,      TRANSACTION_NUMBER
,      DESCRIPTION
,      NOTE
,      SENDER_CODE_COMBINATION_ID
,      RECEIVER_CODE_COMBINATION_ID
,      SENDER_SEGMENT1
,      SENDER_SEGMENT2
,      SENDER_SEGMENT3
,      SENDER_SEGMENT4
,      SENDER_SEGMENT5
,      SENDER_SEGMENT6
,      SENDER_SEGMENT7
,      SENDER_SEGMENT8
,      SENDER_SEGMENT9
,      SENDER_SEGMENT10
,      SENDER_SEGMENT11
,      SENDER_SEGMENT12
,      SENDER_SEGMENT13
,      SENDER_SEGMENT14
,      SENDER_SEGMENT15
,      SENDER_SEGMENT16
,      SENDER_SEGMENT17
,      SENDER_SEGMENT18
,      SENDER_SEGMENT19
,      SENDER_SEGMENT20
,      SENDER_SEGMENT21
,      SENDER_SEGMENT22
,      SENDER_SEGMENT23
,      SENDER_SEGMENT24
,      SENDER_SEGMENT25
,      SENDER_SEGMENT26
,      SENDER_SEGMENT27
,      SENDER_SEGMENT28
,      SENDER_SEGMENT29
,      SENDER_SEGMENT30
,      RECEIVER_SEGMENT1
,      RECEIVER_SEGMENT2
,      RECEIVER_SEGMENT3
,      RECEIVER_SEGMENT4
,      RECEIVER_SEGMENT5
,      RECEIVER_SEGMENT6
,      RECEIVER_SEGMENT7
,      RECEIVER_SEGMENT8
,      RECEIVER_SEGMENT9
,      RECEIVER_SEGMENT10
,      RECEIVER_SEGMENT11
,      RECEIVER_SEGMENT12
,      RECEIVER_SEGMENT13
,      RECEIVER_SEGMENT14
,      RECEIVER_SEGMENT15
,      RECEIVER_SEGMENT16
,      RECEIVER_SEGMENT17
,      RECEIVER_SEGMENT18
,      RECEIVER_SEGMENT19
,      RECEIVER_SEGMENT20
,      RECEIVER_SEGMENT21
,      RECEIVER_SEGMENT22
,      RECEIVER_SEGMENT23
,      RECEIVER_SEGMENT24
,      RECEIVER_SEGMENT25
,      RECEIVER_SEGMENT26
,      RECEIVER_SEGMENT27
,      RECEIVER_SEGMENT28
,      RECEIVER_SEGMENT29
,      RECEIVER_SEGMENT30
,      LINE_DEBIT
,      LINE_CREDIT
,      LAST_MODIFIED_BY
,      LAST_MODIFICATION_DATE
,      SENDER_CHART_OF_ACCOUNTS_ID
,      RECEIVER_CHART_OF_ACCOUNTS_ID
,      REQUEST_ID
,      COMPLETION_STATUS_CODE
FROM GL.GL_IEA_INTERFACE;

Dependencies

[top of page]

GL.GL_IEA_INTERFACE does not reference any database object

GL.GL_IEA_INTERFACE is referenced by following:

APPS: GL_IEA_INTERFACE