[Home] [Help] [Dependency Information]
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 |
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.
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 |
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;
APPS.OKL_SEC_INVESTOR_REVENUE_UV is not referenced by any database object
|
|
|