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.

VIEW: APPS.OKL_POOL_SRCH_PAYFREQ_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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