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

Object Details

Object Name:	GL_JOURNAL_REPORTS_ITF_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLGL.GL_JOURNAL_REPORTS_ITF_V
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
ROW_ID	ROWID	(10)
REQUEST_ID	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
ORGANIZATION_NAME	VARCHAR2	(30)
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)
BATCH_NAME	VARCHAR2	(100)
BATCH_STATUS	VARCHAR2	(80)
BATCH_EFFECTIVE_DATE	DATE
BATCH_POSTED_DATE	DATE
BATCH_RUN_TOTAL_DR	NUMBER
BATCH_RUN_TOTAL_CR	NUMBER
BATCH_RUN_TOTAL_ACCTD_DR	NUMBER
BATCH_RUN_TOTAL_ACCTD_CR	NUMBER
BATCH_PERIOD_NAME	VARCHAR2	(15)
BATCH_ID	NUMBER	(15)
BATCH_TYPE	VARCHAR2	(240)
BATCH_JOURNAL_TYPE	VARCHAR2	(80)
BATCH_APPROVAL_STATUS	VARCHAR2	(80)
BATCH_DESCRIPTION	VARCHAR2	(240)
BATCH_BUDGET_CONTROL_STATUS	VARCHAR2	(80)
BATCH_DATE_CREATED	DATE
HEADER_ID	NUMBER	(15)
HEADER_NAME	VARCHAR2	(100)
HEADER_CATEGORY	VARCHAR2	(25)
HEADER_SOURCE	VARCHAR2	(25)
HEADER_RUN_TOTAL_DR	NUMBER
HEADER_RUN_TOTAL_CR	NUMBER
HEADER_RUN_TOTAL_ACCTD_DR	NUMBER
HEADER_RUN_TOTAL_ACCTD_CR	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
EXCHANGE_RATE	NUMBER
EXCHANGE_DATE	DATE
EXCHANGE_TYPE	VARCHAR2	(30)
HEADER_EXTERNAL_REF	VARCHAR2	(80)
DOC_SEQUENCE_NAME	VARCHAR2	(30)
DOC_SEQUENCE_VALUE	NUMBER
HEADER_LAST_UPDATE_DATE	DATE
HEADER_LAST_UPDATED_BY	VARCHAR2	(100)
TAX_STATUS	VARCHAR2	(80)
HEADER_EFFECTIVE_DATE	DATE
HEADER_DESCRIPTION	VARCHAR2	(240)
HEADER_ENCUMBRANCE_TYPE	VARCHAR2	(30)
HEADER_BUDGET_NAME	VARCHAR2	(15)
JE_LINE_NUM	NUMBER	(15)
SUBLEDGER_DOC_SEQ_NAME	VARCHAR2	(30)
SUBLEDGER_DOC_SEQ_VALUE	NUMBER
ENTERED_DR	NUMBER
ENTERED_CR	NUMBER
ACCOUNTED_DR	NUMBER
ACCOUNTED_CR	NUMBER
CODE_COMBINATION_ID	NUMBER
JE_ACCOUNT	VARCHAR2	(240)
JE_ACCOUNT_DESC	VARCHAR2	(240)
JE_BALANCE	VARCHAR2	(240)
JE_BALANCE_DESC	VARCHAR2	(240)
JE_NATACCT	VARCHAR2	(240)
JE_NATACCT_DESC	VARCHAR2	(240)
JE_CC	VARCHAR2	(240)
JE_CC_DESC	VARCHAR2	(240)
JE_CONTRA_ACCT	VARCHAR2	(240)
JE_CONTRA_ACCT_DESC	VARCHAR2	(240)
JE_SECONDARY_SEG	VARCHAR2	(240)
JE_SECONDARY_DESC	VARCHAR2	(240)
TAX_CODE	VARCHAR2	(50)
TAX_TYPE	VARCHAR2	(80)
LINE_DESCRIPTION	VARCHAR2	(240)
STAT_AMOUNT	NUMBER
EFFECTIVE_DATE	DATE
LINE_REFERENCE	VARCHAR2	(240)
SOURCE_REFERENCE	VARCHAR2	(240)
REFERENCE_1	VARCHAR2	(240)
REFERENCE_2	VARCHAR2	(240)
REFERENCE_3	VARCHAR2	(240)
REFERENCE_4	VARCHAR2	(240)
REFERENCE_5	VARCHAR2	(240)
REFERENCE_6	VARCHAR2	(240)
REFERENCE_7	VARCHAR2	(240)
REFERENCE_8	VARCHAR2	(240)
REFERENCE_9	VARCHAR2	(240)
REFERENCE_10	VARCHAR2	(240)

Query Text

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


SELECT ROW_ID
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_NAME
,      FUNCTIONAL_CURRENCY_CODE
,      BATCH_NAME
,      BATCH_STATUS
,      BATCH_EFFECTIVE_DATE
,      BATCH_POSTED_DATE
,      BATCH_RUN_TOTAL_DR
,      BATCH_RUN_TOTAL_CR
,      BATCH_RUN_TOTAL_ACCTD_DR
,      BATCH_RUN_TOTAL_ACCTD_CR
,      BATCH_PERIOD_NAME
,      BATCH_ID
,      BATCH_TYPE
,      BATCH_JOURNAL_TYPE
,      BATCH_APPROVAL_STATUS
,      BATCH_DESCRIPTION
,      BATCH_BUDGET_CONTROL_STATUS
,      BATCH_DATE_CREATED
,      HEADER_ID
,      HEADER_NAME
,      HEADER_CATEGORY
,      HEADER_SOURCE
,      HEADER_RUN_TOTAL_DR
,      HEADER_RUN_TOTAL_CR
,      HEADER_RUN_TOTAL_ACCTD_DR
,      HEADER_RUN_TOTAL_ACCTD_CR
,      CURRENCY_CODE
,      EXCHANGE_RATE
,      EXCHANGE_DATE
,      EXCHANGE_TYPE
,      HEADER_EXTERNAL_REF
,      DOC_SEQUENCE_NAME
,      DOC_SEQUENCE_VALUE
,      HEADER_LAST_UPDATE_DATE
,      HEADER_LAST_UPDATED_BY
,      TAX_STATUS
,      HEADER_EFFECTIVE_DATE
,      HEADER_DESCRIPTION
,      HEADER_ENCUMBRANCE_TYPE
,      HEADER_BUDGET_NAME
,      JE_LINE_NUM
,      SUBLEDGER_DOC_SEQ_NAME
,      SUBLEDGER_DOC_SEQ_VALUE
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      CODE_COMBINATION_ID
,      JE_ACCOUNT
,      JE_ACCOUNT_DESC
,      JE_BALANCE
,      JE_BALANCE_DESC
,      JE_NATACCT
,      JE_NATACCT_DESC
,      JE_CC
,      JE_CC_DESC
,      JE_CONTRA_ACCT
,      JE_CONTRA_ACCT_DESC
,      JE_SECONDARY_SEG
,      JE_SECONDARY_DESC
,      TAX_CODE
,      TAX_TYPE
,      LINE_DESCRIPTION
,      STAT_AMOUNT
,      EFFECTIVE_DATE
,      LINE_REFERENCE
,      SOURCE_REFERENCE
,      REFERENCE_1
,      REFERENCE_2
,      REFERENCE_3
,      REFERENCE_4
,      REFERENCE_5
,      REFERENCE_6
,      REFERENCE_7
,      REFERENCE_8
,      REFERENCE_9
,      REFERENCE_10
FROM APPS.GL_JOURNAL_REPORTS_ITF_V;