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

Object Details

Object Name:	GLEX_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMF.GLEX_VIEW
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Glex view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DEBIT_CREDIT_SIGN	NUMBER	(5)	Yes	Debit Credit Sign
AMOUNT_TRANS	NUMBER			GL amount in Transaction currency.
AMOUNT_BASE	NUMBER			GL amount in Base currency.
QUANTITY	NUMBER			quantity
CURRENCY_TRANS	VARCHAR2	(4)	Yes	Currency of transaction.
CURRENCY_BASE	VARCHAR2	(4)	Yes	Base currency of transaction.
QUANTITY_UM	VARCHAR2	(4)		Unit of measure of quantity.
DOC_TYPE	VARCHAR2	(4)	Yes	Document type.
TRANS_SOURCE_CODE	VARCHAR2	(4)	Yes	Subsystem of transaction.
SUB_EVENT_CODE	VARCHAR2	(4)	Yes	Transaction identifier.
EXCHANGE_RATE	NUMBER			Exchange Rate
DOC_ID	NUMBER	(10)	Yes	Document identifier within doc type.
VOUCHER_ID	NUMBER	(10)		voucher identifier
ACCTG_UNIT_ID	NUMBER	(10)	Yes	accouting unit idetifier
ACCT_ID	NUMBER	(10)	Yes	account identifier
LEDGER_CODE	VARCHAR2	(4)	Yes	ledger code
SUBLEDGER_ID	NUMBER			subledger identifier
CO_CODE	VARCHAR2	(4)	Yes	company code
FISCAL_YEAR	NUMBER	(5)	Yes	Fiscal year of gl posting.
PERIOD	NUMBER	(5)	Yes	Period of gl posting.
LINE_ID	NUMBER			Detail line identifier.
REFERENCE_NO	NUMBER			ref number
SUB_EVENT_TYPE	NUMBER	(10)	Yes	Transaction identifier.
TRANS_SOURCE_TYPE	NUMBER	(5)	Yes	Subsystem of transaction.
GL_TRANS_DATE	DATE		Yes	GL transaction date
PROJECT_NO	NUMBER			Project Number
SEGMENT	VARCHAR2	(481)		segment description
DESCRIPTION	VARCHAR2	(141)		accouting unit description

Query Text

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


SELECT DEBIT_CREDIT_SIGN
,      AMOUNT_TRANS
,      AMOUNT_BASE
,      QUANTITY
,      CURRENCY_TRANS
,      CURRENCY_BASE
,      QUANTITY_UM
,      DOC_TYPE
,      TRANS_SOURCE_CODE
,      SUB_EVENT_CODE
,      EXCHANGE_RATE
,      DOC_ID
,      VOUCHER_ID
,      ACCTG_UNIT_ID
,      ACCT_ID
,      LEDGER_CODE
,      SUBLEDGER_ID
,      CO_CODE
,      FISCAL_YEAR
,      PERIOD
,      LINE_ID
,      REFERENCE_NO
,      SUB_EVENT_TYPE
,      TRANS_SOURCE_TYPE
,      GL_TRANS_DATE
,      PROJECT_NO
,      SEGMENT
,      DESCRIPTION
FROM APPS.GLEX_VIEW;

Dependencies

[top of page]

APPS.GLEX_VIEW references the following:

APPS: GL_ACCT_MST; GL_ACCU_MST; GL_PLCY_MST; GL_SEVT_MST; GL_SRCE_MST; GL_SUBR_LED

APPS.GLEX_VIEW is not referenced by any database object