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_IA_EXTRACT_HDR_V

Object Details

Object Name:	OKL_IA_EXTRACT_HDR_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_IA_EXTRACT_HDR_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
EVENT_ID	NUMBER	(15)
TCN_ID	NUMBER		Yes
TEH_INV_AGRMNT_NUMBER	VARCHAR2	(120)
TEH_INV_AGRMNT_EFFECTIVE_FROM	DATE
TCN_INV_AGRMNT_PRODUCT_NAME	VARCHAR2	(150)
TEH_INV_AGRMNT_CURRENCY_CODE	VARCHAR2	(80)
TCN_AMOUNT	NUMBER
TCN_CURRENCY_CODE	VARCHAR2	(150)
TCN_CURR_CONVERSION_DATE	DATE
TCN_CURR_CONVERSION_RATE	NUMBER
TCN_CURR_CONVERSION_TYPE	VARCHAR2	(30)
TCN_DATE_TRANSACTION_OCCURRED	DATE		Yes
TCN_TRX_NUMBER	VARCHAR2	(30)	Yes
TCN_STATUS_CODE	VARCHAR2	(30)	Yes
TEH_INV_AGRMNT_SYND_CODE	VARCHAR2	(30)
TCN_TYPE	VARCHAR2	(10)	Yes
TEH_INV_AGRMNT_POOL_NUMBER	VARCHAR2	(120)
TCN_ACCOUNTING_REVERSAL_FLAG	VARCHAR2	(3)
TCN_REPRESENTATION_CODE	VARCHAR2	(20)
TCN_REPRESENTATION_NAME	VARCHAR2	(30)
GL_DATE	DATE
TCN_ORG_ID	NUMBER	(15)
TEH_INV_AGRMNT_STATUS_CODE	VARCHAR2	(90)		Investor Agreement Status Code

Query Text

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


SELECT EVENT_ID
,      TCN_ID
,      TEH_INV_AGRMNT_NUMBER
,      TEH_INV_AGRMNT_EFFECTIVE_FROM
,      TCN_INV_AGRMNT_PRODUCT_NAME
,      TEH_INV_AGRMNT_CURRENCY_CODE
,      TCN_AMOUNT
,      TCN_CURRENCY_CODE
,      TCN_CURR_CONVERSION_DATE
,      TCN_CURR_CONVERSION_RATE
,      TCN_CURR_CONVERSION_TYPE
,      TCN_DATE_TRANSACTION_OCCURRED
,      TCN_TRX_NUMBER
,      TCN_STATUS_CODE
,      TEH_INV_AGRMNT_SYND_CODE
,      TCN_TYPE
,      TEH_INV_AGRMNT_POOL_NUMBER
,      TCN_ACCOUNTING_REVERSAL_FLAG
,      TCN_REPRESENTATION_CODE
,      TCN_REPRESENTATION_NAME
,      GL_DATE
,      TCN_ORG_ID
,      TEH_INV_AGRMNT_STATUS_CODE
FROM APPS.OKL_IA_EXTRACT_HDR_V;

Dependencies

[top of page]

APPS.OKL_IA_EXTRACT_HDR_V references the following:

APPS: OKL_TRX_CONTRACTS_ALL; OKL_TRX_EXTENSION_B; XLA_EVENTS_GT

APPS.OKL_IA_EXTRACT_HDR_V is referenced by following:

APPS: XLA_00540_AAD_S_000014_PKG - show dependent code