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_V

Line 62: OKL_STRM_TYPE_V STY

58: SELECT MAX(SEL.stream_element_date) last_bill_date
59: FROM OKL_STREAMS STM,
60: OKL_STRM_ELEMENTS SEL,
61: OKC_K_HEADERS_B KHR,
62: OKL_STRM_TYPE_V STY
63: WHERE KHR.id = c_khr_id
64: AND SEL.stream_element_date <=c_transaction_date
65: AND KHR.id = STM.khr_id
66: AND STM.id = SEL.stm_id

Line 85: OKL_STRM_TYPE_V STY

81: MAX(SEL.date_billed) last_bill_date
82: FROM OKL_STREAMS_V STM,
83: OKL_STRM_ELEMENTS_V SEL,
84: OKC_K_HEADERS_V KHR,
85: OKL_STRM_TYPE_V STY
86: WHERE KHR.id = c_khr_id
87: AND SEL.stream_element_date <=c_transaction_date
88: AND KHR.id = STM.khr_id
89: AND STM.id = SEL.stm_id

Line 158: OKL_STRM_TYPE_V STY

154: --Bug 5050707:end
155: FROM OKL_STREAMS_V STM,
156: OKL_STRM_ELEMENTS_V SEL,
157: OKC_K_HEADERS_V KHR,
158: OKL_STRM_TYPE_V STY
159: WHERE KHR.id = c_khr_id
160: AND SEL.stream_element_date <= c_transaction_date
161: AND STM.id = SEL.stm_id
162: AND KHR.id = STM.khr_id

Line 185: OKL_STRM_TYPE_V STY,

181: SELECT distinct(SEL.ID)
182: FROM OKL_STREAMS_V STM,
183: OKL_STRM_ELEMENTS_V SEL,
184: OKC_K_HEADERS_V KHR,
185: OKL_STRM_TYPE_V STY,
186: okl_cnsld_ar_strms_b cnsld
187: WHERE KHR.id = c_khr_id
188: AND SEL.stream_element_date <= c_transaction_date
189: AND STM.id = SEL.stm_id

Line 210: OKL_STRM_TYPE_V STY,

206: SELECT distinct(SEL.ID)
207: FROM OKL_STREAMS_V STM,
208: OKL_STRM_ELEMENTS_V SEL,
209: OKC_K_HEADERS_V KHR,
210: OKL_STRM_TYPE_V STY,
211: --okl_cnsld_ar_strms_b cnsld
212: okl_txd_ar_ln_dtls_b tld
213: WHERE KHR.id = c_khr_id
214: AND SEL.stream_element_date <= c_transaction_date

Line 361: OKL_STRM_TYPE_V STY

357: SELECT sel.id stream_id,
358: sel.stream_element_date last_sche_bill_date
359: FROM OKL_STREAMS_V STM,
360: OKL_STRM_ELEMENTS_V SEL,
361: OKL_STRM_TYPE_V STY
362: WHERE sel.stream_element_date = (SELECT max(SEL.stream_element_date) last_sche_bill_date
363: FROM OKL_STREAMS_V STM,
364: OKL_STRM_ELEMENTS_V SEL,
365: OKC_K_HEADERS_V KHR,

Line 366: OKL_STRM_TYPE_V STY

362: WHERE sel.stream_element_date = (SELECT max(SEL.stream_element_date) last_sche_bill_date
363: FROM OKL_STREAMS_V STM,
364: OKL_STRM_ELEMENTS_V SEL,
365: OKC_K_HEADERS_V KHR,
366: OKL_STRM_TYPE_V STY
367: WHERE KHR.id = c_khr_id
368: AND SEL.stream_element_date <= c_transaction_date
369: AND KHR.id = STM.khr_id
370: AND STM.id = SEL.stm_id