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.

APPS.OKL_AM_SECURITIZATION_PVT dependencies on OKL_STRM_TYPE_V

Line 342: OKL_STRM_TYPE_V STY

338: sum(ste.amount)
339: FROM
340: OKL_STRM_ELEMENTS STE,
341: OKL_STREAMS STM,
342: OKL_STRM_TYPE_V STY
343: WHERE ste.amount <> 0
344: AND stm.id = ste.stm_id
345: AND sty.id IN (p_invdisbas_sty_id) -- pick INVESTOR RENT DISB BASIS streams only
346: AND ste.date_billed IS NOT NULL -- already disbursed (fake and real both)

Line 367: OKL_STRM_TYPE_V STY,

363: sum(ste.amount)
364: FROM
365: OKL_STRM_ELEMENTS STE,
366: OKL_STREAMS STM,
367: OKL_STRM_TYPE_V STY,
368: OKL_STRM_ELEMENTS BILLED_STE
369: WHERE ste.amount <> 0
370: AND stm.id = ste.stm_id
371: AND sty.id IN (p_invdisbas_sty_id) -- pick INVESTOR RENT DISB BASIS streams only

Line 667: OKL_STRM_TYPE_V STY

663: sum(ste.amount)
664: FROM
665: OKL_STRM_ELEMENTS STE,
666: OKL_STREAMS STM,
667: OKL_STRM_TYPE_V STY
668: WHERE ste.amount <> 0
669: AND stm.id = ste.stm_id
670: AND sty.id IN (p_invdisbas_sty_id,p_intdisbas_sty_id) -- pick INVESTOR Principal,interest DISB BASIS streams only
671: AND ste.date_billed IS NOT NULL -- already disbursed (fake and real both)

Line 693: OKL_STRM_TYPE_V STY,

689: sum(ste.amount)
690: FROM
691: OKL_STRM_ELEMENTS STE,
692: OKL_STREAMS STM,
693: OKL_STRM_TYPE_V STY,
694: OKL_STRM_ELEMENTS BILLED_STE
695: WHERE ste.amount <> 0
696: AND stm.id = ste.stm_id
697: AND sty.id IN (p_invdisbas_sty_id,p_intdisbas_sty_id) -- pick INVESTOR Principal,interest DISB BASIS streams only