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_AE_LINES_UPDT_UV

Object Details

Object Name:	OKL_AE_LINES_UPDT_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_AE_LINES_UPDT_UV
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	Mandatory	Comments
AE_LINE_ID	NUMBER		Yes
TRX_NUMBER	VARCHAR2	(30)	Yes
LINE_NUMBER	NUMBER		Yes	Line Number
AE_LINE_TYPE_CODE	VARCHAR2	(30)	Yes
AE_LINE_TYPE_MEANING	VARCHAR2	(4000)
ACCOUNT	VARCHAR2	(155)
ACCOUNT_DESC	VARCHAR2	(4000)
CODE_COMBINATION_ID	NUMBER		Yes	Key flexfield combination defining column
ENTERED_DR	NUMBER
ENTERED_CR	NUMBER
ACCOUNTED_DR	NUMBER
ACCOUNTED_CR	NUMBER
CURRENCY_CODE	VARCHAR2	(3)	Yes	Currency Code
SOURCE_TABLE	VARCHAR2	(90)	Yes
SOURCE_ID	NUMBER		Yes
PERIOD_NAME	VARCHAR2	(45)	Yes
ACCOUNTING_DATE	DATE		Yes
ACCOUNTING_ERROR_CODE	VARCHAR2	(90)
EVENT_NUMBER	NUMBER	(15)	Yes
EVENT_TYPE_CODE	VARCHAR2	(30)	Yes
EVENT_TYPE_CODE_DESC	VARCHAR2	(4000)
EVENT_STATUS_CODE	VARCHAR2	(90)	Yes
EVENT_STATUS_CODE_DESC	VARCHAR2	(4000)

Query Text

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


SELECT AE_LINE_ID
,      TRX_NUMBER
,      LINE_NUMBER
,      AE_LINE_TYPE_CODE
,      AE_LINE_TYPE_MEANING
,      ACCOUNT
,      ACCOUNT_DESC
,      CODE_COMBINATION_ID
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      CURRENCY_CODE
,      SOURCE_TABLE
,      SOURCE_ID
,      PERIOD_NAME
,      ACCOUNTING_DATE
,      ACCOUNTING_ERROR_CODE
,      EVENT_NUMBER
,      EVENT_TYPE_CODE
,      EVENT_TYPE_CODE_DESC
,      EVENT_STATUS_CODE
,      EVENT_STATUS_CODE_DESC
FROM APPS.OKL_AE_LINES_UPDT_UV;

Dependencies

[top of page]

APPS.OKL_AE_LINES_UPDT_UV references the following:

APPS: GL_CODE_COMBINATIONS_KFV; OKL_ACCOUNTING_UTIL - show dependent code; OKL_ACC_EVENTS_ALL; OKL_AE_HEADERS; OKL_AE_LINES_ALL; OKL_TRX_CONTRACTS_ALL; OKL_TXL_CNTRCT_LNS_ALL

APPS.OKL_AE_LINES_UPDT_UV is not referenced by any database object