DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKC_STATUSES_B

Line 308: okc_statuses_b sts

304: kle.capitalize_down_payment_yn
305: FROM okl_k_lines_full_v kle,
306: okc_line_styles_b lse,
307: okc_k_lines_tl tl,
308: okc_statuses_b sts
309: WHERE kle.lse_id = lse.id
310: AND lse.lty_code = lnetype
311: AND tl.id = kle.id
312: AND tl.language = userenv('LANG')

Line 453: okc_statuses_b sts

449: AND (NVL( str.kle_id, -1) = -1 OR
450: str.kle_id IN (SELECT kle.id
451: FROM okl_k_lines_full_v kle,
452: okc_line_styles_b lse,
453: okc_statuses_b sts
454: WHERE KLE.LSE_ID = LSE.ID
455: AND kle.dnz_chr_id = chrId
456: AND sts.code = kle.sts_code
457: AND lse.lty_code NOT IN ('INSURANCE')));

Line 477: okc_statuses_b sts

473: SELECT sum(kle.oec) total_oec
474: FROM okl_k_lines_full_v kle,
475: okc_line_styles_b lse,
476: okc_k_lines_tl tl,
477: okc_statuses_b sts
478: WHERE kle.lse_id = lse.id
479: AND lse.lty_code = 'FREE_FORM1'
480: AND tl.id = kle.id
481: AND tl.language = userenv('LANG')