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_AR_REC_APP_IA_REF_V

Object Details

Object Name:	OKL_AR_REC_APP_IA_REF_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_AR_REC_APP_IA_REF_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
OKL_REC_APP_ID	NUMBER	(15)	Yes	Identifies the receivable application
OKL_TXD_ID	NUMBER		Yes	Source Table Identifier
OKL_KHR_ID	NUMBER		Yes	Contract Identifier
OKL_KLE_ID	NUMBER			Contract Line Identifier
OKL_TRY_ID	NUMBER			Transaction Type Identifier
TCL_STY_ID	NUMBER			Stream Type Identifier
TEH_INV_AGRMNT_NUMBER	VARCHAR2	(120)		Investor Agreement Number
TEH_INV_AGRMNT_EFFECTIVE_FROM	DATE			Investor Agreement Effective From Date
TCN_INV_AGRMNT_PRODUCT_NAME	VARCHAR2	(150)		Investor Agreement Product Name
TEH_INV_AGRMNT_CURRENCY_CODE	VARCHAR2	(80)		Investor Agreement Currency Code
TEH_INV_AGRMNT_SYND_CODE	VARCHAR2	(30)		Investor Agreement Type
TEH_INV_AGRMNT_POOL_NUMBER	VARCHAR2	(120)		Investor Agrreement Pool Number
TEH_INV_AGRMNT_STATUS_CODE	VARCHAR2	(30)		Investor Agreement Status Code
TEH_TRX_TYPE_CLASS_CODE	VARCHAR2	(30)		Transaction Type Class Code
DIST_ACCOUNTING_TEMPLATE_NAME	VARCHAR2	(150)		Accounting Template Name
OKL_CONTINGENCY_CODE	VARCHAR2	(80)		Stream Type Collectibility Contingency
TEL_MEMO_FLAG	VARCHAR2	(3)		Accounting Template Memo Indicator
TCL_INV_STREAM_TYPE_CODE	VARCHAR2	(150)		Stream Type Code
TCL_INV_STREAM_TYPE_PURPOSE	VARCHAR2	(30)		Stream Type Purpose Code

Query Text

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


SELECT OKL_REC_APP_ID
,      OKL_TXD_ID
,      OKL_KHR_ID
,      OKL_KLE_ID
,      OKL_TRY_ID
,      TCL_STY_ID
,      TEH_INV_AGRMNT_NUMBER
,      TEH_INV_AGRMNT_EFFECTIVE_FROM
,      TCN_INV_AGRMNT_PRODUCT_NAME
,      TEH_INV_AGRMNT_CURRENCY_CODE
,      TEH_INV_AGRMNT_SYND_CODE
,      TEH_INV_AGRMNT_POOL_NUMBER
,      TEH_INV_AGRMNT_STATUS_CODE
,      TEH_TRX_TYPE_CLASS_CODE
,      DIST_ACCOUNTING_TEMPLATE_NAME
,      OKL_CONTINGENCY_CODE
,      TEL_MEMO_FLAG
,      TCL_INV_STREAM_TYPE_CODE
,      TCL_INV_STREAM_TYPE_PURPOSE
FROM APPS.OKL_AR_REC_APP_IA_REF_V;

Dependencies

[top of page]

APPS.OKL_AR_REC_APP_IA_REF_V references the following:

APPS: AR_ACTIVITY_DETAILS; AR_RECEIVABLE_APPLICATIONS_ALL; OKL_EXT_AR_HEADER_SOURCES_B; OKL_EXT_AR_LINE_SOURCES_B; RA_CUSTOMER_TRX_LINES_ALL

APPS.OKL_AR_REC_APP_IA_REF_V is not referenced by any database object