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_UBB_PVT dependencies on OKL_STREAMS_V

Line 682: FROM OKL_STREAMS_V STM,

678: and til.tai_id = tai.id
679: and til.id = tld.til_id_details
680: and tai.description in ('Regular Stream Billing')
681: and cnsld.sel_id in (SELECT SEL.id
682: FROM OKL_STREAMS_V STM,
683: OKL_STRM_ELEMENTS_V SEL,
684: OKC_K_HEADERS_V KHR,
685: OKL_STRM_TYPE_V STY
686: WHERE KHR.id = c_khr_id

Line 701: FROM OKL_STREAMS_V STM,

697:
698: /*
699: CURSOR c_last_sch_bill_date(c_khr_id in NUMBER, c_transaction_date DATE) IS
700: SELECT max(SEL.stream_element_date) last_sche_bill_date, sel.id
701: FROM OKL_STREAMS_V STM,
702: OKL_STRM_ELEMENTS_V SEL,
703: OKC_K_HEADERS_V KHR,
704: OKL_STRM_TYPE_B STY
705: WHERE KHR.id = c_khr_id

Line 721: FROM OKL_STREAMS_V STM,

717:
718: CURSOR c_last_sch_bill_date(c_khr_id in NUMBER, c_transaction_date DATE) IS
719: SELECT sel.id stream_id,
720: sel.stream_element_date last_sche_bill_date
721: FROM OKL_STREAMS_V STM,
722: OKL_STRM_ELEMENTS_V SEL,
723: OKL_STRM_TYPE_V STY
724: WHERE sel.stream_element_date = (SELECT max(SEL.stream_element_date) last_sche_bill_date
725: FROM OKL_STREAMS_V STM,

Line 725: FROM OKL_STREAMS_V STM,

721: FROM OKL_STREAMS_V STM,
722: OKL_STRM_ELEMENTS_V SEL,
723: OKL_STRM_TYPE_V STY
724: WHERE sel.stream_element_date = (SELECT max(SEL.stream_element_date) last_sche_bill_date
725: FROM OKL_STREAMS_V STM,
726: OKL_STRM_ELEMENTS_V SEL,
727: OKC_K_HEADERS_V KHR,
728: OKL_STRM_TYPE_V STY
729: WHERE KHR.id = c_khr_id