DBA Data[Home] [Help]

APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_STRM_ELEMENTS

Line 8194: okl_strm_elements selm,

8190: NULL ship_to_siteuseid,
8191: NULL inventory_item_id
8192: FROM okl_strm_type_b typ,
8193: okl_streams strm,
8194: okl_strm_elements selm,
8195: okc_k_lines_b lines,
8196: okc_line_styles_b lse
8197: WHERE strm.sty_id = typ.id
8198: AND strm.id = selm.stm_id

Line 8230: okl_strm_elements selm,

8226: cnsld.customer_trx_line_id,
8227: selm.amount --SECHAWLA 22-APR-08 6975983 : added
8228: FROM okl_strm_type_b typ,
8229: okl_streams strm,
8230: okl_strm_elements selm,
8231: okc_k_lines_b lines,
8232: okc_line_styles_b lse,
8233: okl_bpd_tld_ar_lines_v cnsld
8234: WHERE strm.sty_id = typ.id

Line 10981: FROM okl_strm_elements

10977:
10978: -- get the total stream amount
10979: CURSOR l_strmelements_csr(cp_stm_id IN NUMBER) IS
10980: SELECT sum(amount)
10981: FROM okl_strm_elements
10982: WHERE stm_id = cp_stm_id;
10983:
10984: -- Chaeck if tax basis override formula exists
10985: CURSOR l_txbasisoverride_csr(cp_try_id IN NUMBER) IS