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_AP_MANUAL_AEL_V

Object Details

Object Name:	JAI_AP_MANUAL_AEL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JA.JAI_AP_MANUAL_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	Mandatory	Comments
APPLICATION_ID	NUMBER			Identifier of Application
EVENT_TYPE	VARCHAR2	(24)		Event Type
TRX_CLASS	CHAR	(15)		Transaction class
TRX_CLASS_NAME	CHAR	(19)		Transaction class name
TRX_HDR_ID	NUMBER	(15)	Yes	Transaction header id
TRX_HDR_TABLE	CHAR	(19)		Transaction header table
TRX_TYPE	CHAR	(12)		Transaction type
INVENTORY_ORG_ID	NUMBER	(15)	Yes	Identifies the inventory item
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Identifier for the Set of Books
JE_CATEGORY	VARCHAR2	(25)	Yes	Journal Category
USER_JE_CATEGORY_NAME	VARCHAR2	(25)	Yes	Journal Category Name
JE_SOURCE	VARCHAR2	(25)	Yes	Journal Source for GL
USER_JE_SOURCE_NAME	VARCHAR2	(25)	Yes	Journal Source name
JE_HEADER_ID	NUMBER	(15)	Yes	Journal header id
JE_LINE_NUM	NUMBER	(15)	Yes	Journal line number
ENTERED_CURRENCY	VARCHAR2	(15)	Yes	Currency Code
ENTERED_DR	NUMBER			Debit amount
ENTERED_CR	NUMBER			Credit amount
ACCOUNTED_DR	NUMBER			Accounted debit amount
ACCOUNTED_CR	NUMBER			Accounted credit amount
CURRENCY_CONVERSION_DATE	DATE			Currency conversion date
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency conversion type
CURRENCY_USER_CONVERSION_TYPE	VARCHAR2	(30)	Yes	User conversion type
ACCOUNT_ID	NUMBER	(15)	Yes	Account ID
ACCOUNTING_DATE	DATE		Yes	Accounting Date
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	(9)		Standard who column
INVOICE_NUMBER	VARCHAR2	(50)		The invoice number
ITEM_ID	NUMBER			Identifies the Item
ITEM_CLASS	VARCHAR2	(100)		Item class
PARTY_NAME	VARCHAR2	(360)		The party name
REMARKS	VARCHAR2	(240)		Remarks
SERVICE_TYPE	VARCHAR2	(80)		The service type
PARTY_TYPE	VARCHAR2	(80)	Yes	Party type
PARTY_NUMBER	VARCHAR2	(30)		The party number
PARTY_SITE	VARCHAR2	(40)		Identifies the party site
REGIME	VARCHAR2	(80)		Regime
TRANSACTION_NUMBER	NUMBER	(15)	Yes	The transaction number
TRANSACTION_TYPE	VARCHAR2	(80)	Yes	The type of the transaction
TRANSACTION_DATE	DATE		Yes	The transaction date

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
,      TRX_TYPE
,      INVENTORY_ORG_ID
,      SET_OF_BOOKS_ID
,      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
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_USER_CONVERSION_TYPE
,      ACCOUNT_ID
,      ACCOUNTING_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVOICE_NUMBER
,      ITEM_ID
,      ITEM_CLASS
,      PARTY_NAME
,      REMARKS
,      SERVICE_TYPE
,      PARTY_TYPE
,      PARTY_NUMBER
,      PARTY_SITE
,      REGIME
,      TRANSACTION_NUMBER
,      TRANSACTION_TYPE
,      TRANSACTION_DATE
FROM APPS.JAI_AP_MANUAL_AEL_V;

Dependencies

[top of page]

APPS.JAI_AP_MANUAL_AEL_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUP_VALUES; GL_DAILY_CONVERSION_TYPES; GL_IMPORT_REFERENCES; GL_JE_CATEGORIES; GL_JE_HEADERS; GL_JE_LINES; GL_JE_SOURCES; HZ_CUST_SITE_USES_ALL; JAI_CUSTOMERS_V; JAI_RGM_DEFINITIONS; JAI_RGM_LOOKUPS; JAI_RGM_MANUAL_TRXS; JAI_RGM_PARTIES; JA_LOOKUPS; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.JAI_AP_MANUAL_AEL_V is referenced by following:

APPS: JAI_AP_MANUAL_AEL_GL_V; JAI_AP_MANUAL_AEL_SL_V