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_POOL_SRCH_V

Object Details

Object Name:	OKL_POOL_SRCH_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_POOL_SRCH_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Securitization - Pool search view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CUST_OBJECT1_ID1	NUMBER	(15)	Yes	Customer account identifier
LESSEE	VARCHAR2	(360)	Yes	Customer or lessee name
SIC_CODE	VARCHAR2	(30)		Service industry code
DNZ_CHR_ID	NUMBER		Yes	Securitized Contract header identifier
CONTRACT_NUMBER	VARCHAR2	(120)	Yes	Contract number
PRE_TAX_YIELD	NUMBER			Pre-tax yield
BOOK_CLASSIFICATION	VARCHAR2	(30)		Contract deal type
PDT_ID	NUMBER			Lease financial product identifier
ASSIGNABLE_YN	VARCHAR2	(3)		Assignable yes no flag. this determines whether the lese contract can be securitized or not
STS_CODE	VARCHAR2	(30)	Yes	Contract status code
START_DATE	DATE			Contract effective from date
END_DATE	DATE			Contract effective to date
OPERATING_UNIT	NUMBER		Yes	Operating unit
CURRENCY_CODE	VARCHAR2	(15)		Currency code
AUTHORING_ORG_ID	NUMBER		Yes	Operating unit identifier
TAX_OWNER	VARCHAR2	(450)		Contract tax owner
KLE_ID	NUMBER			Fianacial asset line identifier
ASSET_ID	NUMBER			Fixed asset identifier
ASSET_NUMBER	VARCHAR2	(15)		Asset number
MODEL_NUMBER	VARCHAR2	(40)		Model number
MANUFACTURER_NAME	VARCHAR2	(360)		Manufacturer name
ITEM_ID1	NUMBER			Inventory item identifier for the financial asset
VENDOR_ID1	NUMBER			Supplier identifier
OEC	NUMBER			Original equipment cost for the financial asset
RESIDUAL_PERCENTAGE	NUMBER	(5)		Residual percentage
STY_ID	NUMBER		Yes	Stream type identifier
STREAM_TYPE_CODE	VARCHAR2	(150)	Yes	Stream type code
STREAM_TYPE_NAME	VARCHAR2	(150)	Yes	Stream type name
STREAM_TYPE_SUBCLASS	VARCHAR2	(30)		Stream type subclass
STREAM_SAY_CODE	VARCHAR2	(30)	Yes	Stream status code
STREAM_ACTIVE_YN	VARCHAR2	(3)	Yes	Stream active flag. Indicates whether streams are active or not
STREAM_ELEMENT_DUE_DATE	DATE		Yes	Stream element due date
STREAM_ELEMENT_AMOUNT	NUMBER		Yes	Stream element amount
STREAM_ELEMENT_DATE_BILLED	DATE			Stream element date billed
STM_ID	NUMBER		Yes	Unique identifier for streams

Query Text

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


SELECT CUST_OBJECT1_ID1
,      LESSEE
,      SIC_CODE
,      DNZ_CHR_ID
,      CONTRACT_NUMBER
,      PRE_TAX_YIELD
,      BOOK_CLASSIFICATION
,      PDT_ID
,      ASSIGNABLE_YN
,      STS_CODE
,      START_DATE
,      END_DATE
,      OPERATING_UNIT
,      CURRENCY_CODE
,      AUTHORING_ORG_ID
,      TAX_OWNER
,      KLE_ID
,      ASSET_ID
,      ASSET_NUMBER
,      MODEL_NUMBER
,      MANUFACTURER_NAME
,      ITEM_ID1
,      VENDOR_ID1
,      OEC
,      RESIDUAL_PERCENTAGE
,      STY_ID
,      STREAM_TYPE_CODE
,      STREAM_TYPE_NAME
,      STREAM_TYPE_SUBCLASS
,      STREAM_SAY_CODE
,      STREAM_ACTIVE_YN
,      STREAM_ELEMENT_DUE_DATE
,      STREAM_ELEMENT_AMOUNT
,      STREAM_ELEMENT_DATE_BILLED
,      STM_ID
FROM APPS.OKL_POOL_SRCH_V;

Dependencies

[top of page]

APPS.OKL_POOL_SRCH_V references the following:

APPS: OKL_ACCOUNTING_UTIL - show dependent code; OKL_POOL_ASSETS_UV; OKL_POOL_CONTRACTS_UV; OKL_POOL_CUSTOMERS_UV; OKL_POOL_STREAMS_UV

APPS.OKL_POOL_SRCH_V is referenced by following:

APPS: OKL_POOL_PVT - show dependent code