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_AR_TRX_AEL_V

Object Details

Object Name:	JAI_AR_TRX_AEL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JA.JAI_AR_TRX_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	Comments
APPLICATION_ID	NUMBER		Identifier of Application
EVENT_TYPE	VARCHAR2	(48)	Event Type
TRX_CLASS	CHAR	(10)	Transaction class
TRX_CLASS_NAME	CHAR	(10)	Transaction class name
TRX_HDR_ID	NUMBER	(15)	Transaction header id
TRX_HDR_TABLE	CHAR	(11)	Transaction header table
JE_CATEGORY	VARCHAR2	(25)	Journal Category
USER_JE_CATEGORY_NAME	VARCHAR2	(25)	Journal Category Name
JE_SOURCE	VARCHAR2	(25)	Journal Source for GL
USER_JE_SOURCE_NAME	VARCHAR2	(25)	Journal Source name
LEDGER_ID	NUMBER	(15)	Ledger ID
JE_BATCH_ID	NUMBER	(15)	Journal Batch ID
JE_HEADER_ID	NUMBER	(15)	Journal header id
JE_LINE_NUM	NUMBER	(15)	Journal line number
CURRENCY_CODE	VARCHAR2	(15)	Currency Code
ENTERED_CR	NUMBER		Credit amount
ENTERED_DR	NUMBER		Debit amount
ACCOUNTED_CR	NUMBER		Accounted credit amount
ACCOUNTED_DR	NUMBER		Accounted debit amount
CURRENCY_CONVERSION_DATE	DATE		Currency conversion date
CURRENCY_CONVERSION_RATE	NUMBER		Currency conversion rate
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)	Currency conversion type
CODE_COMBINATION_ID	NUMBER	(15)	The code combination ID
ACCOUNTING_DATE	DATE		Accounting Date
USER_CONVERSION_TYPE	VARCHAR2	(30)	The conversion type of the user
SOURCE_TABLE	VARCHAR2	(30)	Source table
LAST_UPDATE_DATE	DATE		Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Standard who column
CREATION_DATE	DATE		Standard who column
CREATED_BY	NUMBER	(15)	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard who column
GL_TRANSFER_STATUS	CHAR	(1)	The status of the GL transfer
GL_TRANSFER_STATUS_NAME	VARCHAR2	(80)	The status name of the GL transfer
TRX_DATE	DATE		The transaction date
PARTY_NAME	VARCHAR2	(360)	The party name
PARTY_NUMBER	VARCHAR2	(30)	The party number
VAT_INVOICE_NO	VARCHAR2	(240)	The vat invoice number
CUST_SHIP_TO	VARCHAR2	(40)	The customer ship to location
CUST_BILL_TO	VARCHAR2	(40)	The customer bill to location
TRX_NUMBER	VARCHAR2	(20)	The transaction number
SOURCE_NAME	VARCHAR2	(50)	The source name
TRANSACTION_TYPE_NAME	VARCHAR2	(20)	The name of the transaction type
ORGANIZATION_ID	NUMBER		Identifies the organization
LOCATION_ID	NUMBER		Identifies the location

Query Text

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


SELECT APPLICATION_ID
,      EVENT_TYPE
,      TRX_CLASS
,      TRX_CLASS_NAME
,      TRX_HDR_ID
,      TRX_HDR_TABLE
,      JE_CATEGORY
,      USER_JE_CATEGORY_NAME
,      JE_SOURCE
,      USER_JE_SOURCE_NAME
,      LEDGER_ID
,      JE_BATCH_ID
,      JE_HEADER_ID
,      JE_LINE_NUM
,      CURRENCY_CODE
,      ENTERED_CR
,      ENTERED_DR
,      ACCOUNTED_CR
,      ACCOUNTED_DR
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CODE_COMBINATION_ID
,      ACCOUNTING_DATE
,      USER_CONVERSION_TYPE
,      SOURCE_TABLE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      GL_TRANSFER_STATUS
,      GL_TRANSFER_STATUS_NAME
,      TRX_DATE
,      PARTY_NAME
,      PARTY_NUMBER
,      VAT_INVOICE_NO
,      CUST_SHIP_TO
,      CUST_BILL_TO
,      TRX_NUMBER
,      SOURCE_NAME
,      TRANSACTION_TYPE_NAME
,      ORGANIZATION_ID
,      LOCATION_ID
FROM APPS.JAI_AR_TRX_AEL_V;

Dependencies

[top of page]

APPS.JAI_AR_TRX_AEL_V references the following:

APPS: AR_LOOKUPS; AR_RECEIVABLE_APPLICATIONS_ALL; GL_DAILY_CONVERSION_TYPES; GL_IMPORT_REFERENCES; GL_JE_CATEGORIES; GL_JE_HEADERS; GL_JE_LINES; GL_JE_SOURCES; HZ_CUST_ACCOUNTS; HZ_CUST_SITE_USES_ALL; HZ_PARTIES; JAI_AR_TRXS; JAI_AR_TRX_LINES; JAI_AR_TRX_TAX_LINES; RA_BATCH_SOURCES_ALL; RA_CUSTOMER_TRX_ALL; RA_CUSTOMER_TRX_LINES_ALL; RA_CUST_TRX_TYPES_ALL

APPS.JAI_AR_TRX_AEL_V is referenced by following:

APPS: JAI_AR_TRX_AEL_GL_V; JAI_AR_TRX_AEL_SL_V