DBA Data[Home] [Help]

APPS.OKL_AM_CALC_QUOTE_STREAM_PVT dependencies on OKC_STATUSES_B

Line 192: okc_statuses_b kls,

188: stm.sty_id stream_type_id
189: FROM okl_streams stm,
190: okl_strm_type_b sty,
191: okc_k_lines_b kle,
192: okc_statuses_b kls,
193: okc_line_styles_b lse,
194: okl_strm_elements ste -- SECHAWLA 21-APR-03 2925120 :Added this table
195: WHERE stm.khr_id = cp_chr_id
196: AND stm.active_yn = 'Y'

Line 476: okc_statuses_b kls,

472: FROM okl_streams stm,
473: okl_strm_elements ste,
474: okl_strm_type_b sty,
475: okc_k_lines_b kle,
476: okc_statuses_b kls,
477: okc_line_styles_b lse
478: WHERE stm.khr_id = cp_chr_id
479: AND stm.active_yn = 'Y'
480: AND stm.say_code = 'CURR'

Line 773: okc_statuses_b sts

769: SUM (l.amount_due_remaining) amount_due
770: FROM okl_bpd_ar_inv_lines_v l
771: , OKC_K_HEADERS_B CHR
772: ,okc_k_lines_b cle,
773: okc_statuses_b sts
774: WHERE l.contract_id = cp_chr_id
775: and l.contract_line_id = cle.id
776: and sts.code = cle.sts_code
777: and sts.ste_code not in ('EXPIRED','TERMINATED','CANCELLED')