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_LA_SALES_TAX_PVT dependencies on OKC_STATUSES_B

Line 6178: okc_statuses_b sts

6174: SELECT cle.id,
6175: name
6176: FROM okc_k_lines_v cle,
6177: okc_line_styles_b sty,
6178: okc_statuses_b sts
6179: WHERE cle.lse_id = sty.id
6180: AND cle.dnz_chr_id = p_chr_id
6181: AND lty_code = 'FREE_FORM1'
6182: AND cle.sts_code = sts.code

Line 6238: okc_statuses_b sts

6234: SELECT COUNT(cleb.id)
6235: FROM okc_k_lines_b cleb,
6236: okl_k_lines kle,
6237: okc_line_styles_b sty,
6238: okc_statuses_b sts
6239: WHERE cleb.lse_id = sty.id
6240: AND sty.lty_code = 'FEE'
6241: AND cleb.sts_code = sts.code
6242: AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')

Line 7022: okc_statuses_b okcsts,

7018: --Bug# 12807203
7019: kle.fee_type
7020: FROM okc_k_lines_v clev,
7021: okl_k_lines kle,
7022: okc_statuses_b okcsts,
7023: okc_line_styles_v lsev
7024: WHERE clev.dnz_chr_id = p_chr_id
7025: AND clev.chr_id = p_chr_id
7026: AND kle.id = clev.id

Line 7044: okc_statuses_b okcsts

7040: cleb.end_date,
7041: cleb.start_date
7042: FROM okc_k_lines_b cleb,
7043: okl_k_lines kle,
7044: okc_statuses_b okcsts
7045: WHERE cleb.dnz_chr_id = p_chr_id
7046: AND kle.id = cleb.id
7047: AND cleb.cle_id = p_fee_line_id
7048: AND okcsts.code = cleb.sts_code