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_GL_QTE_V

Object Details

Object Name:	OKL_AEL_GL_QTE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_AEL_GL_QTE_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	Mandatory	Comments
ASSET_NUMBER	NUMBER			A unique identifier for each quote
PA_PERIOD_DATE	DATE			The date the quote is effective from
PAYMENT_DATE	DATE			The date the quote is effective to
ASSET_DESCRIPTION	VARCHAR2	(30)		The quote type code. The FND lookup type is OKL_QUOTE_TYPE
PA_PROJECT_NAME	VARCHAR2	(120)	Yes	Contract (RFP,Proposal etc.) Legal Identifier.
ITEM_DESCRIPTION	VARCHAR2	(30)		The quote status code. The FND lookup type is OKL_QUOTE_STATUS
CC_PROC_METHOD_NAME	VARCHAR2	(4000)		Recipient name
TRX_HDR_ID	NUMBER		Yes	Unique transaction identification number
TRX_NUMBER_DISPLAYED	VARCHAR2	(30)	Yes	Displayed Unique transaction identification number
TRX_HDR_CURRENCY	VARCHAR2	(150)		Transaction Currency Code
TRX_DATE	DATE		Yes	Date on Which Transaction occured
TRX_LINE_TYPE_NAME	VARCHAR2	(30)	Yes	Transaction type name
CC_TYPE_NAME	VARCHAR2	(150)	Yes	Template Name
COST_TYPE_NAME	VARCHAR2	(150)		Formula Name
PO_ORDER_TYPE	VARCHAR2	(150)	Yes	Stream type
PO_ORDER_NUMBER	VARCHAR2	(4000)		Stream Type Purpose
TRX_CLASS	VARCHAR2	(30)	Yes	Transanction type class
TRX_CLASS_NAME	VARCHAR2	(4000)		Transanction type class description
ACCOUNTED_DR	NUMBER			Accounted Debit Amount
ACCOUNTED_CR	NUMBER			Accounted Credit Amount
JE_HEADER_ID	NUMBER	(15)	Yes	Journal entry header defining column
JE_LINE_NUM	NUMBER	(15)	Yes	Journal entry line number
APPLICATION_ID	NUMBER			Unique Application identification number
SET_OF_BOOKS_ID	NUMBER		Yes	Accounting books defining column
ORG_ID	NUMBER			Operating unit identifier
AEH_ID	NUMBER		Yes	Accounting Event Header Identification number
AEL_ID	NUMBER		Yes	Accounting Event Line Identification number
ACCT_LINE_TYPE	VARCHAR2	(30)	Yes	Accounting Line Type
THIRD_PARTY_ID	NUMBER			Third party idenification number
DOC_SEQUENCE_VALUE	NUMBER	(15)		Document Sequence Value
AEL_TABLE	CHAR	(6)		Name of the Accounting Entry Lines table
ENTERED_DR	NUMBER			Entered Debit Amount
ENTERED_CR	NUMBER			Entered Credit Amount
CODE_COMBINATION_ID	NUMBER		Yes	Key flexfield combination defining column
CURRENCY_CODE	VARCHAR2	(3)	Yes	Currency code
CURRENCY_CONVERSION_DATE	DATE			Currency conversion date
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency conversion type
CURRENCY_USER_CONVERSION_TYPE	VARCHAR2	(30)		User currency conversion type
DOC_SEQUENCE_ID	NUMBER			Document sequence identification number
GL_TRANSFER_STATUS	VARCHAR2	(3)	Yes	General Ledger transfer status
JE_CATEGORY	VARCHAR2	(90)	Yes	Journal entry category
ACCOUNTING_DATE	DATE		Yes	Date on which the transaction is accounted
USER_JE_CATEGORY_NAME	VARCHAR2	(25)	Yes	Journal entry category
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	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
ACCOUNTING_EVENT_NUMBER	NUMBER	(15)	Yes	Accounting Event number
ACCOUNTING_EVENT_TYPE	VARCHAR2	(30)	Yes	Accounting Event type
ACCOUNTING_LINE_NUMBER	NUMBER	(15)	Yes	Accounting Line Number
AEH_ACCOUNTING_ERROR_CODE	VARCHAR2	(90)		Accounting Event Header Accounting Error code
AEL_ACCOUNTING_ERROR_CODE	VARCHAR2	(90)		Accounting Event Line Accounting Error code
SOURCE_ID	NUMBER		Yes	Source Identification Number
SOURCE_TABLE	VARCHAR2	(90)	Yes	Name of source table

Query Text

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


SELECT ASSET_NUMBER
,      PA_PERIOD_DATE
,      PAYMENT_DATE
,      ASSET_DESCRIPTION
,      PA_PROJECT_NAME
,      ITEM_DESCRIPTION
,      CC_PROC_METHOD_NAME
,      TRX_HDR_ID
,      TRX_NUMBER_DISPLAYED
,      TRX_HDR_CURRENCY
,      TRX_DATE
,      TRX_LINE_TYPE_NAME
,      CC_TYPE_NAME
,      COST_TYPE_NAME
,      PO_ORDER_TYPE
,      PO_ORDER_NUMBER
,      TRX_CLASS
,      TRX_CLASS_NAME
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      JE_HEADER_ID
,      JE_LINE_NUM
,      APPLICATION_ID
,      SET_OF_BOOKS_ID
,      ORG_ID
,      AEH_ID
,      AEL_ID
,      ACCT_LINE_TYPE
,      THIRD_PARTY_ID
,      DOC_SEQUENCE_VALUE
,      AEL_TABLE
,      ENTERED_DR
,      ENTERED_CR
,      CODE_COMBINATION_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_USER_CONVERSION_TYPE
,      DOC_SEQUENCE_ID
,      GL_TRANSFER_STATUS
,      JE_CATEGORY
,      ACCOUNTING_DATE
,      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
,      ACCOUNTING_EVENT_NUMBER
,      ACCOUNTING_EVENT_TYPE
,      ACCOUNTING_LINE_NUMBER
,      AEH_ACCOUNTING_ERROR_CODE
,      AEL_ACCOUNTING_ERROR_CODE
,      SOURCE_ID
,      SOURCE_TABLE
FROM APPS.OKL_AEL_GL_QTE_V;

Dependencies

[top of page]

APPS.OKL_AEL_GL_QTE_V references the following:

APPS: GL_DAILY_CONVERSION_TYPES; GL_IMPORT_REFERENCES; GL_JE_CATEGORIES_VL; OKC_K_HEADERS_B; OKC_K_PARTY_ROLES_B; OKL_ACCOUNTING_UTIL - show dependent code; OKL_ACC_EVENTS_ALL; OKL_AE_HEADERS_ALL; OKL_AE_LINES_ALL; OKL_AE_TEMPLATES_ALL; OKL_AM_UTIL_PVT - show dependent code; OKL_FORMULAE_B; OKL_QUOTE_PARTIES; OKL_STRM_TYPE_V; OKL_TRX_CONTRACTS_ALL; OKL_TRX_QUOTES_ALL_B; OKL_TRX_TYPES_B; OKL_TXL_CNTRCT_LNS_ALL

APPS.OKL_AEL_GL_QTE_V is referenced by following:

APPS: XLA_OKL_AEL_GL_QTE_V