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 OKC_K_HEADERS_V

Line 84: OKC_K_HEADERS_V KHR,

80: SELECT --SEL.stream_element_date last_bill_date
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

Line 157: OKC_K_HEADERS_V KHR,

153: SELECT distinct STM.LINK_HIST_STREAM_ID
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

Line 184: OKC_K_HEADERS_V KHR,

180: CURSOR c_last_bill_date_4 (c_stm_id in NUMBER, c_khr_id IN NUMBER,c_transaction_date in DATE) IS
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

Line 209: OKC_K_HEADERS_V KHR,

205: CURSOR c_last_bill_date_4 (c_stm_id in NUMBER, c_khr_id IN NUMBER,c_transaction_date in DATE) IS
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

Line 341: OKC_K_HEADERS_V KHR,

337: CURSOR c_last_sch_bill_date(c_khr_id in NUMBER, c_transaction_date DATE) IS
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

Line 365: OKC_K_HEADERS_V KHR,

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,
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