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_HEADERS_B

Line 4491: okc_k_headers_b khr,

4487: khl.pdt_id pdt_id
4488: FROM OKL_STRM_ELEMENTS ste,
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

Line 4612: FROM okc_k_headers_b khr

4608: -- Line level Bill to Site
4609: CURSOR line_bill_to_csr(p_khr_id IN NUMBER,
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

Line 4624: FROM okc_k_headers_b khr

4620: AND cle.BILL_TO_SITE_USE_ID = cs.id1
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

Line 4765: khr_id okc_k_headers_b.id%TYPE,

4761: AND NVL(end_date_active, cp_bill_date);
4762:
4763: -- cursor c_streams data structure
4764: TYPE bill_rec_type IS RECORD (
4765: khr_id okc_k_headers_b.id%TYPE,
4766: bill_date okl_strm_elements.stream_element_date%TYPE,
4767: kle_id okl_streams.kle_id%TYPE,
4768: sel_id okl_strm_elements.id%TYPE,
4769: sty_id okl_streams.sty_id%TYPE,

Line 4770: contract_number okc_k_headers_b.contract_number%TYPE,

4766: bill_date okl_strm_elements.stream_element_date%TYPE,
4767: kle_id okl_streams.kle_id%TYPE,
4768: sel_id okl_strm_elements.id%TYPE,
4769: sty_id okl_streams.sty_id%TYPE,
4770: contract_number okc_k_headers_b.contract_number%TYPE,
4771: currency_code okc_k_headers_b.currency_code%TYPE,
4772: authoring_org_id okc_k_headers_b.authoring_org_id%TYPE,
4773: sty_name okl_strm_type_v.NAME%TYPE,
4774: taxable_default_yn okl_strm_type_v.taxable_default_yn%TYPE,

Line 4771: currency_code okc_k_headers_b.currency_code%TYPE,

4767: kle_id okl_streams.kle_id%TYPE,
4768: sel_id okl_strm_elements.id%TYPE,
4769: sty_id okl_streams.sty_id%TYPE,
4770: contract_number okc_k_headers_b.contract_number%TYPE,
4771: currency_code okc_k_headers_b.currency_code%TYPE,
4772: authoring_org_id okc_k_headers_b.authoring_org_id%TYPE,
4773: sty_name okl_strm_type_v.NAME%TYPE,
4774: taxable_default_yn okl_strm_type_v.taxable_default_yn%TYPE,
4775: amount okl_strm_elements.amount%TYPE,

Line 4772: authoring_org_id okc_k_headers_b.authoring_org_id%TYPE,

4768: sel_id okl_strm_elements.id%TYPE,
4769: sty_id okl_streams.sty_id%TYPE,
4770: contract_number okc_k_headers_b.contract_number%TYPE,
4771: currency_code okc_k_headers_b.currency_code%TYPE,
4772: authoring_org_id okc_k_headers_b.authoring_org_id%TYPE,
4773: sty_name okl_strm_type_v.NAME%TYPE,
4774: taxable_default_yn okl_strm_type_v.taxable_default_yn%TYPE,
4775: amount okl_strm_elements.amount%TYPE,
4776: sts_code okc_k_headers_b.sts_code%TYPE,

Line 4776: sts_code okc_k_headers_b.sts_code%TYPE,

4772: authoring_org_id okc_k_headers_b.authoring_org_id%TYPE,
4773: sty_name okl_strm_type_v.NAME%TYPE,
4774: taxable_default_yn okl_strm_type_v.taxable_default_yn%TYPE,
4775: amount okl_strm_elements.amount%TYPE,
4776: sts_code okc_k_headers_b.sts_code%TYPE,
4777: pdt_id okl_k_headers.pdt_id%TYPE);
4778:
4779: TYPE bill_tbl_type IS TABLE OF bill_rec_type
4780: INDEX BY BINARY_INTEGER;