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_REPORT_PVT dependencies on OKC_K_LINES_B

Line 4493: okc_k_lines_b kle,

4489: OKL_STREAMS stm,
4490: okl_strm_type_v sty,
4491: okc_k_headers_b khr,
4492: OKL_K_HEADERS khl,
4493: okc_k_lines_b kle,
4494: okc_statuses_b khs,
4495: okc_statuses_b kls
4496: WHERE TRUNC(ste.stream_element_date) >=
4497: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 4577: FROM okc_k_lines_b cle

4573: rul.rule_information_category = 'LAPMTH' AND
4574: rgp.dnz_chr_id = p_khr_id
4575: UNION
4576: SELECT rul.object1_id1
4577: FROM okc_k_lines_b cle
4578: , okc_k_items_v item
4579: , okc_k_lines_b linked_asset
4580: , OKC_RULES_B rul
4581: , Okc_rule_groups_B rgp

Line 4579: , okc_k_lines_b linked_asset

4575: UNION
4576: SELECT rul.object1_id1
4577: FROM okc_k_lines_b cle
4578: , okc_k_items_v item
4579: , okc_k_lines_b linked_asset
4580: , OKC_RULES_B rul
4581: , Okc_rule_groups_B rgp
4582: WHERE cle.dnz_chr_id = p_khr_id AND
4583: cle.id = p_kle_id AND

Line 4614: , okc_k_lines_b cle

4610: p_kle_id IN NUMBER) IS
4611: SELECT cs.cust_acct_site_id
4612: FROM okc_k_headers_b khr
4613: , okx_cust_site_uses_v cs
4614: , okc_k_lines_b cle
4615: , hz_customer_profiles cp
4616: WHERE khr.id = p_khr_id
4617: AND cle.dnz_chr_id = khr.id
4618: AND cle.chr_id IS NOT NULL

Line 4625: , okc_k_lines_b cle

4621: AND khr.bill_to_site_use_id = cp.site_use_id(+)
4622: UNION
4623: SELECT cs.cust_acct_site_id
4624: FROM okc_k_headers_b khr
4625: , okc_k_lines_b cle
4626: , okc_k_items item
4627: , okc_k_lines_b linked_asset
4628: , okx_cust_site_uses_v cs
4629: , hz_customer_profiles cp

Line 4627: , okc_k_lines_b linked_asset

4623: SELECT cs.cust_acct_site_id
4624: FROM okc_k_headers_b khr
4625: , okc_k_lines_b cle
4626: , okc_k_items item
4627: , okc_k_lines_b linked_asset
4628: , okx_cust_site_uses_v cs
4629: , hz_customer_profiles cp
4630: WHERE khr.id = p_khr_id
4631: AND cle.dnz_chr_id = khr.id

Line 4704: FROM okc_k_lines_b cle

4700: rul.rule_information_category = 'LABACC' AND
4701: rgp.dnz_chr_id = cp_khr_id
4702: UNION
4703: SELECT rul.object1_id1
4704: FROM okc_k_lines_b cle
4705: , okc_k_items_v item
4706: , okc_k_lines_b linked_asset
4707: , OKC_RULES_B rul
4708: , Okc_rule_groups_B rgp

Line 4706: , okc_k_lines_b linked_asset

4702: UNION
4703: SELECT rul.object1_id1
4704: FROM okc_k_lines_b cle
4705: , okc_k_items_v item
4706: , okc_k_lines_b linked_asset
4707: , OKC_RULES_B rul
4708: , Okc_rule_groups_B rgp
4709: WHERE cle.dnz_chr_id = cp_khr_id AND
4710: cle.id = cp_kle_id AND