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 4767: bill_date okl_strm_elements.stream_element_date%TYPE,

4763:
4764: -- cursor c_streams data structure
4765: TYPE bill_rec_type IS RECORD (
4766: khr_id okc_k_headers_b.id%TYPE,
4767: bill_date okl_strm_elements.stream_element_date%TYPE,
4768: kle_id okl_streams.kle_id%TYPE,
4769: sel_id okl_strm_elements.id%TYPE,
4770: sty_id okl_streams.sty_id%TYPE,
4771: contract_number okc_k_headers_b.contract_number%TYPE,

Line 4769: sel_id okl_strm_elements.id%TYPE,

4765: TYPE bill_rec_type IS RECORD (
4766: khr_id okc_k_headers_b.id%TYPE,
4767: bill_date okl_strm_elements.stream_element_date%TYPE,
4768: kle_id okl_streams.kle_id%TYPE,
4769: sel_id okl_strm_elements.id%TYPE,
4770: sty_id okl_streams.sty_id%TYPE,
4771: contract_number okc_k_headers_b.contract_number%TYPE,
4772: currency_code okc_k_headers_b.currency_code%TYPE,
4773: authoring_org_id okc_k_headers_b.authoring_org_id%TYPE,

Line 4776: amount okl_strm_elements.amount%TYPE,

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