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_SL_GL_V2

Object Details

Object Name:	LNS_SL_GL_V2
Object Type:	VIEW
Owner:	APPS
FND Design Data:	LNS.LNS_SL_GL_V2
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_CATEGORY	VARCHAR2	(0)		Journal entry category
USER_JE_CATEGORY	VARCHAR2	(0)		User journal entry category
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	GL Set of books ID
ORG_ID	VARCHAR2	(0)		Organization ID
TRX_CLASS	VARCHAR2	(0)		Transaction or Loan class
TRX_CLASS_NAME	VARCHAR2	(0)		Transaction or Loan class meaning
TRX_TYPE_NAME	VARCHAR2	(0)		Loan Type
TRX_NUMBER_DISPLAYED	VARCHAR2	(0)		Loan Number
TRX_NUMBER_C	VARCHAR2	(0)		Loan number
TRX_DATE	VARCHAR2	(0)		Transaction date
COMMENTS	VARCHAR2	(0)
DOC_SEQUENCE_ID	VARCHAR2	(0)		Loan ID
DOC_SEQUENCE_VALUE	VARCHAR2	(60)	Yes	Loan Number
TRX_HDR_ID	NUMBER	(15)	Yes	Loan ID
ACCT_LINE_TYPE	VARCHAR2	(0)		Account Name
ACCT_LINE_TYPE_NAME	VARCHAR2	(4000)		Account name meaning
CODE_COMBINATION_ID	NUMBER	(15)	Yes	GL Code combination ID
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency
ENTERED_DR	NUMBER			Entered debit
ENTERED_CR	NUMBER			Entered credit
ACCOUNTED_DR	NUMBER
ACCOUNTED_CR	NUMBER
CURRENCY_CONVERSION_DATE	DATE			Currency conversion date
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency conversion type
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate
THIRD_PARTY_NAME	VARCHAR2	(0)		null
THIRD_PARTY_NUMBER	VARCHAR2	(0)		null
THIRD_PARTY_SUB_ID	VARCHAR2	(0)		null
ACCOUNTING_DATE	VARCHAR2	(0)		GL Accounting date
TRX_LINE_NUMBER	VARCHAR2	(0)		Transaction line number
TRX_LINE_TYPE	VARCHAR2	(0)		Transaction line type
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
ACCOUNTING_EVENT_TYPE	VARCHAR2	(4000)		Account Code Combination

Query Text

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


SELECT APPLICATION_ID
,      JE_CATEGORY
,      USER_JE_CATEGORY
,      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
,      THIRD_PARTY_NAME
,      THIRD_PARTY_NUMBER
,      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
,      ACCOUNTING_EVENT_TYPE
FROM APPS.LNS_SL_GL_V2;

Dependencies

[top of page]

APPS.LNS_SL_GL_V2 references the following:

APPS: FND_FLEX_EXT - show dependent code; GL_CODE_COMBINATIONS; GL_IMPORT_REFERENCES; GL_JE_HEADERS; GL_JE_LINES; LNS_DISB_HEADERS; LNS_DISTRIBUTIONS; LNS_LOAN_HEADERS_ALL; LNS_UTILITY_PUB - show dependent code; XLA_AE_HEADERS; XLA_AE_LINES; XLA_EVENTS; XLA_TRANSACTION_ENTITIES

APPS.LNS_SL_GL_V2 is not referenced by any database object