View: OKL_POOL_SRCH_PAYFREQ_V

Product:	OKL - Leasing and Finance Management
Description:	Securitization - pool search streams view.
Implementation/DBA Data:	APPS.OKL_POOL_SRCH_PAYFREQ_V

View Text

SELECT POCS.CUST_OBJECT1_ID1 CUST_OBJECT1_ID1
, POCS.LESSEE LESSEE
, POCS.SIC_CODE SIC_CODE
, POKS.DNZ_CHR_ID DNZ_CHR_ID
, POKS.CONTRACT_NUMBER CONTRACT_NUMBER
, POKS.PRE_TAX_YIELD PRE_TAX_YIELD
, POKS.BOOK_CLASSIFICATION BOOK_CLASSIFICATION
, POKS.PDT_ID PDT_ID
, POKS.ASSIGNABLE_YN ASSIGNABLE_YN
, POKS.STS_CODE STS_CODE
, POKS.START_DATE START_DATE
, POKS.END_DATE END_DATE
, POKS.OPERATING_UNIT OPERATING_UNIT
, POKS.CURRENCY_CODE CURRENCY_CODE
, POKS.AUTHORING_ORG_ID AUTHORING_ORG_ID
, POKS.TAX_OWNER TAX_OWNER
, POAS.KLE_ID KLE_ID
, POAS.ASSET_ID ASSET_ID
, POAS.ASSET_NUMBER ASSET_NUMBER
, POAS.MODEL_NUMBER MODEL_NUMBER
, POAS.MANUFACTURER_NAME MANUFACTURER_NAME
, POAS.ITEM_ID1 ITEM_ID1
, POAS.VENDOR_ID1 VENDOR_ID1
, POAS.OEC OEC
, POAS.RESIDUAL_PERCENTAGE RESIDUAL_PERCENTAGE
, POSP.STY_ID STY_ID
, POSP.STREAM_TYPE_CODE STREAM_TYPE_CODE
, POSP.STREAM_TYPE_NAME STREAM_TYPE_NAME
, POSP.STREAM_TYPE_SUBCLASS
, POSP.STREAM_SAY_CODE STREAM_SAY_CODE
, POSP.STREAM_ACTIVE_YN STREAM_ACTIVE_YN
, POSP.STREAM_ELEMENT_DUE_DATE STREAM_ELEMENT_DUE_DATE
, POSP.STREAM_ELEMENT_AMOUNT STREAM_ELEMENT_AMOUNT
, POSP.STREAM_ELEMENT_DATE_BILLED STREAM_ELEMENT_DATE_BILLED
, POSP.PAYMENT_FREQ PAYMENT_FREQ
, POSP.STM_ID STM_ID
FROM OKL_POOL_CUSTOMERS_UV POCS
, OKL_POOL_CONTRACTS_UV POKS
, OKL_POOL_ASSETS_UV POAS
, OKL_POOL_STREAMS_PAY_UV POSP
WHERE POKS.DNZ_CHR_ID = POCS.DNZ_CHR_ID
AND POKS.DNZ_CHR_ID = POAS.DNZ_CHR_ID
AND POAS.KLE_ID = POSP.KLE_ID

Columns