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

Object Details

Object Name:	LNS_AEL_GL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	LNS.LNS_AEL_GL_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			Application ID
JE_HEADER_ID	NUMBER	(15)	Yes	Jornal entry header ID
JE_CATEGORY	VARCHAR2	(25)	Yes	Journal entry category 'Oracle Loans'
USER_JE_CATEGORY	VARCHAR2	(0)		User journal entry category 'Oracle Loans'
JE_LINE_NUM	NUMBER	(15)	Yes	Jounral Entry Line number
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	GL Set of books
ORG_ID	NUMBER	(15)	Yes	Organization ID
TRX_CLASS	VARCHAR2	(0)		Loan Class Code
TRX_CLASS_NAME	VARCHAR2	(4000)		Loan Class code name
TRX_TYPE_NAME	VARCHAR2	(4000)		Loan Type
TRX_NUMBER_DISPLAYED	VARCHAR2	(60)	Yes	Loan Number
TRX_NUMBER_C	VARCHAR2	(0)		Loan Number
TRX_DATE	VARCHAR2	(0)		Loan Start
COMMENTS	VARCHAR2	(250)		loan description
DOC_SEQUENCE_ID	VARCHAR2	(0)		LOAN_id
DOC_SEQUENCE_VALUE	VARCHAR2	(0)		null
TRX_HDR_ID	NUMBER	(15)	Yes	LOAN_id
ACCT_LINE_TYPE	VARCHAR2	(0)		loan distribution account name
ACCT_LINE_TYPE_NAME	VARCHAR2	(0)		loan distribution account name meaning
CODE_COMBINATION_ID	VARCHAR2	(0)		GL Code combination ID
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency Code
ENTERED_DR	NUMBER			Entered debit
ENTERED_CR	NUMBER			Entered credit
ACCOUNTED_DR	NUMBER			Accounted debit
ACCOUNTED_CR	NUMBER			Accounted credit
CURRENCY_CONVERSION_DATE	DATE			Currency conversion date
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency conversion type
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate
CURRENCY_USER_CONVERSION_TYPE	VARCHAR2	(0)
THIRD_PARTY_NUMBER	VARCHAR2	(0)		null
THIRD_PARTY_NAME	VARCHAR2	(360)	Yes	null
THIRD_PARTY_SUB_ID	VARCHAR2	(0)		Primary Borrower ID
ACCOUNTING_DATE	DATE			Gl Date
TRX_LINE_NUMBER	VARCHAR2	(0)		null
TRX_LINE_TYPE	VARCHAR2	(0)		AE_LINE_TYPE_CODE
TRX_LINE_TYPE_NAME	VARCHAR2	(0)		Transaction line type name
REQUEST_ID	VARCHAR2	(0)		Request ID
PROGRAM_APPLICATION_ID	VARCHAR2	(0)		Program application ID
PROGRAM_ID	VARCHAR2	(0)		Program ID
PROGRAM_UPDATE_DATE	VARCHAR2	(0)		Program update date

Query Text

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


SELECT APPLICATION_ID
,      JE_HEADER_ID
,      JE_CATEGORY
,      USER_JE_CATEGORY
,      JE_LINE_NUM
,      SET_OF_BOOKS_ID
,      ORG_ID
,      TRX_CLASS
,      TRX_CLASS_NAME
,      TRX_TYPE_NAME
,      TRX_NUMBER_DISPLAYED
,      TRX_NUMBER_C
,      TRX_DATE
,      COMMENTS
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      TRX_HDR_ID
,      ACCT_LINE_TYPE
,      ACCT_LINE_TYPE_NAME
,      CODE_COMBINATION_ID
,      CURRENCY_CODE
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_USER_CONVERSION_TYPE
,      THIRD_PARTY_NUMBER
,      THIRD_PARTY_NAME
,      THIRD_PARTY_SUB_ID
,      ACCOUNTING_DATE
,      TRX_LINE_NUMBER
,      TRX_LINE_TYPE
,      TRX_LINE_TYPE_NAME
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.LNS_AEL_GL_V;

Dependencies

[top of page]

APPS.LNS_AEL_GL_V references the following:

APPS: GL_IMPORT_REFERENCES; GL_JE_HEADERS; GL_JE_LINES; HZ_PARTIES; LNS_LOAN_HEADERS_ALL; LNS_UTILITY_PUB - show dependent code; XLA_AE_HEADERS; XLA_AE_LINES; XLA_EVENTS; XLA_TRANSACTION_ENTITIES

APPS.LNS_AEL_GL_V is not referenced by any database object