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_BILL_STATUS_PVT dependencies on OKL_STRM_TYPE_B

Line 39: OKL_STRM_TYPE_B STY

35: -- abindal bug 4529600 start --
36: FROM OKL_STREAMS STM,
37: OKL_STRM_ELEMENTS SEL,
38: OKC_K_HEADERS_B KHR,
39: OKL_STRM_TYPE_B STY
40: -- abindal bug 4529600 end --
41: WHERE KHR.id = c_khr_id
42: AND SEL.stream_element_date <= c_transaction_date
43: AND KHR.id = STM.khr_id

Line 266: OKL_STRM_TYPE_B STY

262: AND EXISTS ( SELECT '1'
263: FROM OKL_STREAMS STM,
264: OKL_STRM_ELEMENTS SEL,
265: -- OKC_K_LINES_B KLE,
266: OKL_STRM_TYPE_B STY
267: WHERE SEL.ID = cnsld.SEL_ID
268: AND SEL.stream_element_date <= TRUNC(c_transaction_date)
269: -- AND KLE.ID = STM.KLE_ID
270: AND STM.KHR_ID = c_khr_id

Line 313: OKL_STRM_TYPE_B STY

309: AND EXISTS ( SELECT '1'
310: FROM OKL_STREAMS STM,
311: OKL_STRM_ELEMENTS SEL,
312: -- OKC_K_LINES_B KLE,
313: OKL_STRM_TYPE_B STY
314: WHERE SEL.ID = RACTRL.SEL_ID
315: AND SEL.stream_element_date <= TRUNC(c_transaction_date)
316: -- AND KLE.ID = STM.KLE_ID
317: AND STM.KHR_ID = c_khr_id

Line 342: OKL_STRM_TYPE_B STY

338: SELECT max(SEL.stream_element_date) last_sche_bill_date, sel.id
339: FROM OKL_STREAMS_V STM,
340: OKL_STRM_ELEMENTS_V SEL,
341: OKC_K_HEADERS_V KHR,
342: OKL_STRM_TYPE_B STY
343: WHERE KHR.id = c_khr_id
344: AND SEL.stream_element_date <= c_transaction_date
345: AND KHR.id = STM.khr_id
346: AND STM.id = SEL.stm_id