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: GL.GL_IEA_INTERFACE#

Object Details

Object Name:	GL_IEA_INTERFACE#
Object Type:	VIEW
Owner:	GL
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
GROUP_ID	NUMBER	(15)	Yes
TRANSACTION_TYPE_ID	NUMBER	(15)	Yes
TRANSACTION_STATUS_CODE	VARCHAR2	(1)	Yes
CURRENCY_CODE	VARCHAR2	(15)	Yes
GL_DATE	DATE		Yes
SENDER_SUBSIDIARY_ID	NUMBER	(15)	Yes
RECEIVER_SUBSIDIARY_ID	NUMBER	(15)	Yes
LINE_TYPE	VARCHAR2	(1)	Yes
TRANSACTION_NUMBER	VARCHAR2	(20)
DESCRIPTION	VARCHAR2	(240)
NOTE	VARCHAR2	(2000)
SENDER_CODE_COMBINATION_ID	NUMBER	(15)
RECEIVER_CODE_COMBINATION_ID	NUMBER	(15)
SENDER_SEGMENT1	VARCHAR2	(25)
SENDER_SEGMENT2	VARCHAR2	(25)
SENDER_SEGMENT3	VARCHAR2	(25)
SENDER_SEGMENT4	VARCHAR2	(25)
SENDER_SEGMENT5	VARCHAR2	(25)
SENDER_SEGMENT6	VARCHAR2	(25)
SENDER_SEGMENT7	VARCHAR2	(25)
SENDER_SEGMENT8	VARCHAR2	(25)
SENDER_SEGMENT9	VARCHAR2	(25)
SENDER_SEGMENT10	VARCHAR2	(25)
SENDER_SEGMENT11	VARCHAR2	(25)
SENDER_SEGMENT12	VARCHAR2	(25)
SENDER_SEGMENT13	VARCHAR2	(25)
SENDER_SEGMENT14	VARCHAR2	(25)
SENDER_SEGMENT15	VARCHAR2	(25)
SENDER_SEGMENT16	VARCHAR2	(25)
SENDER_SEGMENT17	VARCHAR2	(25)
SENDER_SEGMENT18	VARCHAR2	(25)
SENDER_SEGMENT19	VARCHAR2	(25)
SENDER_SEGMENT20	VARCHAR2	(25)
SENDER_SEGMENT21	VARCHAR2	(25)
SENDER_SEGMENT22	VARCHAR2	(25)
SENDER_SEGMENT23	VARCHAR2	(25)
SENDER_SEGMENT24	VARCHAR2	(25)
SENDER_SEGMENT25	VARCHAR2	(25)
SENDER_SEGMENT26	VARCHAR2	(25)
SENDER_SEGMENT27	VARCHAR2	(25)
SENDER_SEGMENT28	VARCHAR2	(25)
SENDER_SEGMENT29	VARCHAR2	(25)
SENDER_SEGMENT30	VARCHAR2	(25)
RECEIVER_SEGMENT1	VARCHAR2	(25)
RECEIVER_SEGMENT2	VARCHAR2	(25)
RECEIVER_SEGMENT3	VARCHAR2	(25)
RECEIVER_SEGMENT4	VARCHAR2	(25)
RECEIVER_SEGMENT5	VARCHAR2	(25)
RECEIVER_SEGMENT6	VARCHAR2	(25)
RECEIVER_SEGMENT7	VARCHAR2	(25)
RECEIVER_SEGMENT8	VARCHAR2	(25)
RECEIVER_SEGMENT9	VARCHAR2	(25)
RECEIVER_SEGMENT10	VARCHAR2	(25)
RECEIVER_SEGMENT11	VARCHAR2	(25)
RECEIVER_SEGMENT12	VARCHAR2	(25)
RECEIVER_SEGMENT13	VARCHAR2	(25)
RECEIVER_SEGMENT14	VARCHAR2	(25)
RECEIVER_SEGMENT15	VARCHAR2	(25)
RECEIVER_SEGMENT16	VARCHAR2	(25)
RECEIVER_SEGMENT17	VARCHAR2	(25)
RECEIVER_SEGMENT18	VARCHAR2	(25)
RECEIVER_SEGMENT19	VARCHAR2	(25)
RECEIVER_SEGMENT20	VARCHAR2	(25)
RECEIVER_SEGMENT21	VARCHAR2	(25)
RECEIVER_SEGMENT22	VARCHAR2	(25)
RECEIVER_SEGMENT23	VARCHAR2	(25)
RECEIVER_SEGMENT24	VARCHAR2	(25)
RECEIVER_SEGMENT25	VARCHAR2	(25)
RECEIVER_SEGMENT26	VARCHAR2	(25)
RECEIVER_SEGMENT27	VARCHAR2	(25)
RECEIVER_SEGMENT28	VARCHAR2	(25)
RECEIVER_SEGMENT29	VARCHAR2	(25)
RECEIVER_SEGMENT30	VARCHAR2	(25)
LINE_DEBIT	NUMBER
LINE_CREDIT	NUMBER
LAST_MODIFIED_BY	NUMBER	(15)
LAST_MODIFICATION_DATE	DATE
SENDER_CHART_OF_ACCOUNTS_ID	NUMBER	(15)
RECEIVER_CHART_OF_ACCOUNTS_ID	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
COMPLETION_STATUS_CODE	VARCHAR2	(1000)

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# references the following:

GL: GL_IEA_INTERFACE

GL.GL_IEA_INTERFACE# is referenced by following:

APPS: GL_IEA_INTERFACE