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

Object Details

Object Name:	OKL_AEL_SL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_AEL_SL_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
APPLICATION_ID	NUMBER		Unique Application identification number
SET_OF_BOOKS_ID	NUMBER		Accounting books defining column
ORG_ID	NUMBER		Operating unit identifier
AEH_ID	NUMBER		Accounting Event Header Identification number
AEL_ID	NUMBER		Accounting Event Line Identification number
ACCOUNTING_EVENT_NUMBER	NUMBER	(15)	Accounting Event number
ACCOUNTING_LINE_NUMBER	NUMBER	(15)	Accounting Line Number
ACCT_LINE_TYPE	VARCHAR2	(30)	Accounting Line Type
ACCT_LINE_TYPE_NAME	VARCHAR2	(4000)	Accounting Line Type name
CODE_COMBINATION_ID	NUMBER		Key flexfield combination defining column
ACCOUNTED_DR	NUMBER		Accounted Debit Amount
ACCOUNTED_CR	NUMBER		Accounted Credit Amount
TRX_LINE_NUMBER	NUMBER		Transaction Line number
CURRENCY_CODE	VARCHAR2	(150)	Currency code
ENTERED_DR	NUMBER		Entered Debit Amount
ENTERED_CR	NUMBER		Entered Credit Amount
CURRENCY_CONVERSION_RATE	NUMBER		Currency conversion rate
CURRENCY_CONVERSION_DATE	DATE		Currency conversion date
CURRENCY_USER_CONVERSION_TYPE	VARCHAR2	(30)	Currency conversion type
SOURCE_ID	NUMBER		Source Identification Number
SOURCE_TABLE	VARCHAR2	(90)	Name of source table
ASSET_DESCRIPTION	VARCHAR2	(150)	Template Name
ACCOUNTING_EVENT_TYPE	VARCHAR2	(30)	Accounting Event type
ACCOUNTING_EVENT_TYPE_NAME	VARCHAR2	(4000)	Accounting Event type name
ACCOUNTING_DATE	DATE		Date on which the transaction is accounted
GL_TRANSFER_STATUS	VARCHAR2	(3)	General Ledger transfer status
GL_TRANSFER_STATUS_NAME	VARCHAR2	(4000)	General Ledger transfer status description
JE_CATEGORY	VARCHAR2	(90)	Journal entry category
AEH_ACCOUNTING_ERROR_CODE	VARCHAR2	(90)	Accounting Event Header Accounting Error code
AEL_ACCOUNTING_ERROR_CODE	VARCHAR2	(90)	Accounting Event Line Accounting Error code
USER_JE_CATEGORY_NAME	VARCHAR2	(25)	Journal entry category description
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
REQUEST_ID	NUMBER	(15)	Concurrent Manager Column
PROGRAM_APPLICATION_ID	NUMBER	(15)	Concurrent Manager Column
PROGRAM_ID	NUMBER	(15)	Concurrent Manager Column
PROGRAM_UPDATE_DATE	DATE		Concurrent Manager Column
TRX_DATE	DATE		Date on Which Transaction occured
TRX_CLASS	VARCHAR2	(30)	Transaction Class
TRX_CLASS_NAME	VARCHAR2	(4000)	Transaction Class description
COST_ELEMENT_NAME	VARCHAR2	(150)	Stream type
PO_ORDER_NUMBER	VARCHAR2	(4000)	Stream Type Purpose

Query Text

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


SELECT APPLICATION_ID
,      SET_OF_BOOKS_ID
,      ORG_ID
,      AEH_ID
,      AEL_ID
,      ACCOUNTING_EVENT_NUMBER
,      ACCOUNTING_LINE_NUMBER
,      ACCT_LINE_TYPE
,      ACCT_LINE_TYPE_NAME
,      CODE_COMBINATION_ID
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      TRX_LINE_NUMBER
,      CURRENCY_CODE
,      ENTERED_DR
,      ENTERED_CR
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_USER_CONVERSION_TYPE
,      SOURCE_ID
,      SOURCE_TABLE
,      ASSET_DESCRIPTION
,      ACCOUNTING_EVENT_TYPE
,      ACCOUNTING_EVENT_TYPE_NAME
,      ACCOUNTING_DATE
,      GL_TRANSFER_STATUS
,      GL_TRANSFER_STATUS_NAME
,      JE_CATEGORY
,      AEH_ACCOUNTING_ERROR_CODE
,      AEL_ACCOUNTING_ERROR_CODE
,      USER_JE_CATEGORY_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TRX_DATE
,      TRX_CLASS
,      TRX_CLASS_NAME
,      COST_ELEMENT_NAME
,      PO_ORDER_NUMBER
FROM APPS.OKL_AEL_SL_V;

Dependencies

[top of page]

APPS.OKL_AEL_SL_V references the following:

APPS: GL_DAILY_CONVERSION_TYPES; GL_JE_CATEGORIES; GL_JE_CATEGORIES_VL; OKL_ACCOUNTING_UTIL - show dependent code; OKL_ACC_EVENTS_ALL; OKL_AE_HEADERS; OKL_AE_LINES_ALL; OKL_AE_TEMPLATES_ALL; OKL_STRM_TYPE_V; OKL_TRX_ASSETS; OKL_TRX_CONTRACTS_ALL; OKL_TRX_TYPES_B; OKL_TXL_ASSETS_B; OKL_TXL_CNTRCT_LNS_ALL

APPS.OKL_AEL_SL_V is referenced by following:

APPS: XLA_OKL_AEL_SL_V