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.OKS_USAGE_SETTLE_PUB dependencies on OKS_BILL_CONT_LINES

Line 20: AND not exists (select 1 from oks_bill_cont_lines bcl

16: WHERE line.dnz_chr_id = p_chr_id
17: AND rline.cle_id = line.id
18: AND line.lse_id = 12
19: AND rline.usage_type = 'VRT'
20: AND not exists (select 1 from oks_bill_cont_lines bcl
21: where line.id = bcl.cle_id
22: and bcl.bill_action = 'SRI');
23:
24: CURSOR subline_cur (p_cle_id IN NUMBER)

Line 66: FROM oks_bill_cont_lines bcl,

62: bsl.date_billed_from,
63: bsl.date_billed_to,
64: bsl.amount,
65: bsd.result
66: FROM oks_bill_cont_lines bcl,
67: oks_bill_sub_lines bsl,
68: oks_bill_sub_line_dtls bsd
69: WHERE bcl.id = bsl.bcl_id
70: AND bcl.bill_action = 'RI'