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_STREAMS_UV

Source

View Text - Preformatted


SELECT STMB.KHR_ID KHR_ID , STMB.KLE_ID KLE_ID , STMB.STY_ID STY_ID , STYV.CODE STREAM_TYPE_CODE , STYV.NAME STREAM_TYPE_NAME , STYV.STREAM_TYPE_SUBCLASS , STMB.SAY_CODE STREAM_SAY_CODE , STMB.ACTIVE_YN STREAM_ACTIVE_YN , SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DUE_DATE , SELB.AMOUNT STREAM_ELEMENT_AMOUNT , SELB.DATE_BILLED STREAM_ELEMENT_DATE_BILLED, STMB.ID STM_ID FROM OKL_STREAMS STMB,OKL_STRM_ELEMENTS SELB,OKL_STRM_TYPE_V STYV WHERE STMB.ID = SELB.STM_ID AND STMB.STY_ID = STYV.ID

View Text - HTML Formatted

SELECT STMB.KHR_ID KHR_ID
, STMB.KLE_ID KLE_ID
, STMB.STY_ID STY_ID
, STYV.CODE STREAM_TYPE_CODE
, STYV.NAME STREAM_TYPE_NAME
, STYV.STREAM_TYPE_SUBCLASS
, STMB.SAY_CODE STREAM_SAY_CODE
, STMB.ACTIVE_YN STREAM_ACTIVE_YN
, SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DUE_DATE
, SELB.AMOUNT STREAM_ELEMENT_AMOUNT
, SELB.DATE_BILLED STREAM_ELEMENT_DATE_BILLED
, STMB.ID STM_ID
FROM OKL_STREAMS STMB
, OKL_STRM_ELEMENTS SELB
, OKL_STRM_TYPE_V STYV
WHERE STMB.ID = SELB.STM_ID
AND STMB.STY_ID = STYV.ID