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_INVESTORS_UV

Object Details

Object Name:	OKL_SEC_INVESTORS_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_SEC_INVESTORS_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
CHR_ID	NUMBER		Yes	Securitization agreement header identifier
TOP_LINE_ID	NUMBER		Yes	Securitization agreement top line identifier
STS_CODE	VARCHAR2	(30)	Yes	Agreement status code
STE_CODE	VARCHAR2	(30)	Yes	Agreement contracts core status code
STS_MEANING	VARCHAR2	(90)	Yes	Agreement status meaning
K_ROLE_ID	NUMBER		Yes	Party role identifier
NAME	VARCHAR2	(360)	Yes	Party role name
DESCRIPTION	VARCHAR2	(30)	Yes	Party role description
ID1	NUMBER	(15)	Yes	Party identifier
ID2	CHAR	(1)		Party identifier
DATE_PAY_INVESTOR_START	DATE			Date on which investor payment starts
PAY_INVESTOR_FREQUENCY	VARCHAR2	(30)		Frequency of payment to investor
PAY_INVESTOR_FREQUENCY_MEANING	VARCHAR2	(80)	Yes	Frequency of payment to investor meaning
PAY_INVESTOR_EVENT	VARCHAR2	(30)		Event on which investor payment is made
PAY_INVESTOR_EVENT_MEANING	VARCHAR2	(80)	Yes	Event meaning on which payment to investor is made
PAY_INVESTOR_REMITTANCE_DAYS	NUMBER			Investor payment remittance days
AMOUNT	NUMBER			Investor payment amount
START_DATE	DATE			Investor start date
CURRENCY_CODE	VARCHAR2	(15)		Currency code
BILL_TO_SITE_USE_ID	NUMBER	(15)		Bill to site use identifier
BILL_TO_SITE_USE_NAME	VARCHAR2	(40)		Bill to site use name
CUST_ACCT_ID	NUMBER	(15)		Customer acount identifier
CUST_ACCT_NO	VARCHAR2	(360)	Yes	Customer account number
CUST_ACCT_NAME	VARCHAR2	(30)		Customer account name
AMOUNT_STAKE	NUMBER	(14)		Stake Amount

Query Text

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


SELECT CHR_ID
,      TOP_LINE_ID
,      STS_CODE
,      STE_CODE
,      STS_MEANING
,      K_ROLE_ID
,      NAME
,      DESCRIPTION
,      ID1
,      ID2
,      DATE_PAY_INVESTOR_START
,      PAY_INVESTOR_FREQUENCY
,      PAY_INVESTOR_FREQUENCY_MEANING
,      PAY_INVESTOR_EVENT
,      PAY_INVESTOR_EVENT_MEANING
,      PAY_INVESTOR_REMITTANCE_DAYS
,      AMOUNT
,      START_DATE
,      CURRENCY_CODE
,      BILL_TO_SITE_USE_ID
,      BILL_TO_SITE_USE_NAME
,      CUST_ACCT_ID
,      CUST_ACCT_NO
,      CUST_ACCT_NAME
,      AMOUNT_STAKE
FROM APPS.OKL_SEC_INVESTORS_UV;

Dependencies

[top of page]

APPS.OKL_SEC_INVESTORS_UV references the following:

APPS: ARP_ADDR_LABEL_PKG - show dependent code; FND_GLOBAL - show dependent code; FND_LOOKUPS; HZ_CUST_ACCOUNTS; OKC_K_HEADERS_B; OKC_K_LINES_B; OKC_K_PARTY_ROLES_B; OKC_LINE_STYLES_B; OKC_STATUSES_B; OKC_STATUSES_TL; OKL_K_LINES; OKX_CUST_SITE_USES_V; OKX_PARTIES_V

APPS.OKL_SEC_INVESTORS_UV is referenced by following:

APPS: OKL_SEC_INVESTOR_PVT - show dependent code