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_SEC_INVESTOR_REVENUE_UV

Object Details

Object Name:	OKL_SEC_INVESTOR_REVENUE_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_SEC_INVESTOR_REVENUE_UV
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
ID	NUMBER		Yes	Investor revenue line identifier
TOP_LINE_ID	NUMBER		Yes	Investor agreement top line identifier
PERCENT_STAKE	NUMBER	(5)		Investor percent stake
AMOUNT_STAKE	NUMBER	(14)		Investor amount stake
LSE_ID	NUMBER		Yes	Line style identifier for revenue share line
DNZ_CHR_ID	NUMBER		Yes	Investor agreement header identifier
DATE_TERMINATED	DATE			Revenue share termination date
START_DATE	DATE			Revenue share start date
END_DATE	DATE			Revenue share end date
STS_CODE	VARCHAR2	(30)	Yes	Revenue share Line status code
CURRENCY_CODE	VARCHAR2	(15)		Revenue share currency code
LINE_NUMBER	VARCHAR2	(150)	Yes	Revenue share line number
DISPLAY_SEQUENCE	NUMBER	(7)	Yes	Line display sequence
EXCEPTION_YN	VARCHAR2	(3)	Yes	Exception flag
STY_SUBCLASS_CODE	VARCHAR2	(30)		Sub-class code of the stream type
STREAM_TYPE_SUBCLASS	VARCHAR2	(80)	Yes	The meaning of the sub-class of the stream type

Query Text

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


SELECT ID
,      TOP_LINE_ID
,      PERCENT_STAKE
,      AMOUNT_STAKE
,      LSE_ID
,      DNZ_CHR_ID
,      DATE_TERMINATED
,      START_DATE
,      END_DATE
,      STS_CODE
,      CURRENCY_CODE
,      LINE_NUMBER
,      DISPLAY_SEQUENCE
,      EXCEPTION_YN
,      STY_SUBCLASS_CODE
,      STREAM_TYPE_SUBCLASS
FROM APPS.OKL_SEC_INVESTOR_REVENUE_UV;

Dependencies

[top of page]

APPS.OKL_SEC_INVESTOR_REVENUE_UV references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; OKC_K_LINES_B; OKC_LINE_STYLES_B; OKL_K_LINES

APPS.OKL_SEC_INVESTOR_REVENUE_UV is not referenced by any database object