DBA Data[Home] [Help]

APPS.OKL_REPORT_PVT dependencies on OKL_STRM_ELEMENTS

Line 4488: FROM OKL_STRM_ELEMENTS ste,

4484: sty.taxable_default_yn taxable_default_yn,
4485: ste.amount amount,
4486: khr.sts_code sts_code,
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,

Line 4766: bill_date okl_strm_elements.stream_element_date%TYPE,

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,
4770: contract_number okc_k_headers_b.contract_number%TYPE,

Line 4768: sel_id okl_strm_elements.id%TYPE,

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

Line 4775: amount okl_strm_elements.amount%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,
4777: pdt_id okl_k_headers.pdt_id%TYPE);
4778:
4779: TYPE bill_tbl_type IS TABLE OF bill_rec_type