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

Object Details

Object Name:	JAI_RG_FUND_TRF_AEL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JA.JAI_RG_FUND_TRF_AEL_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
EVENT_TYPE	CHAR	(16)
APPLICATION_ID	NUMBER
SET_OF_BOOKS_ID	NUMBER	(15)
JE_BATCH_ID	NUMBER	(15)
TRX_CLASS	VARCHAR2	(16)
TRX_CLASS_NAME	CHAR	(20)
TRX_HDR_TABLE	VARCHAR2	(23)
JE_CATEGORY	VARCHAR2	(25)
USER_JE_CATEGORY_NAME	VARCHAR2	(25)
JE_SOURCE	VARCHAR2	(25)
USER_JE_SOURCE_NAME	VARCHAR2	(25)
JE_HEADER_ID	NUMBER	(15)
JE_LINE_NUM	NUMBER	(15)
ENTERED_CURRENCY	VARCHAR2	(15)
ENTERED_DR	NUMBER
ENTERED_CR	NUMBER
ACCOUNTED_DR	NUMBER
ACCOUNTED_CR	NUMBER
ACCOUNT_ID	NUMBER	(15)
ACCOUNTING_DATE	DATE
ACCOUNT_DESCRIPTION	VARCHAR2	(240)
CURRENCY_CONVERSION_RATE	NUMBER
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)
CURRENCY_USER_CONVERSION_TYPE	VARCHAR2	(30)
CURRENCY_CONVERSION_DATE	DATE
SOURCE_TABLE	CHAR	(20)
GL_TRANSFER_STATUS	CHAR	(1)
OPERATING_UNIT	VARCHAR2	(240)
TRX_HDR_ID	NUMBER
FROM_ORGANIZATION	VARCHAR2	(240)
FROM_LOCATION	VARCHAR2	(60)
TO_ORGANIZATION	VARCHAR2	(240)
TO_LOCATION	VARCHAR2	(60)
TRANSFER_DATE	DATE
REGISTER_TYPE	VARCHAR2	(5)
TRANSFER_EXCISE_AMOUNT	NUMBER
TRANSFER_CESS_AMOUNT	NUMBER
TRANSFER_SH_CESS_AMOUNT	NUMBER
FROM_ORGANIZATION_ID	NUMBER
TRANSFER_ID	NUMBER

Query Text

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


SELECT EVENT_TYPE
,      APPLICATION_ID
,      SET_OF_BOOKS_ID
,      JE_BATCH_ID
,      TRX_CLASS
,      TRX_CLASS_NAME
,      TRX_HDR_TABLE
,      JE_CATEGORY
,      USER_JE_CATEGORY_NAME
,      JE_SOURCE
,      USER_JE_SOURCE_NAME
,      JE_HEADER_ID
,      JE_LINE_NUM
,      ENTERED_CURRENCY
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      ACCOUNT_ID
,      ACCOUNTING_DATE
,      ACCOUNT_DESCRIPTION
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_USER_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      SOURCE_TABLE
,      GL_TRANSFER_STATUS
,      OPERATING_UNIT
,      TRX_HDR_ID
,      FROM_ORGANIZATION
,      FROM_LOCATION
,      TO_ORGANIZATION
,      TO_LOCATION
,      TRANSFER_DATE
,      REGISTER_TYPE
,      TRANSFER_EXCISE_AMOUNT
,      TRANSFER_CESS_AMOUNT
,      TRANSFER_SH_CESS_AMOUNT
,      FROM_ORGANIZATION_ID
,      TRANSFER_ID
FROM APPS.JAI_RG_FUND_TRF_AEL_V;