DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKC_STATUSES_B

Line 312: okc_statuses_b sts

308: kle.capital_reduction_percent
309: FROM okl_k_lines_full_v kle,
310: okc_line_styles_b lse,
311: okc_k_lines_tl tl,
312: okc_statuses_b sts
313: WHERE kle.lse_id = lse.id
314: AND lse.lty_code = lnetype
315: AND tl.id = kle.id
316: AND tl.language = userenv('LANG')

Line 485: OKC_STATUSES_B STS

481: STR.KLE_ID IN
482: (SELECT /*+ index(KLE OKC_K_LINES_B_U1 )*/ KLE.ID
483: FROM OKC_K_LINES_B KLE,
484: OKC_LINE_STYLES_B LSE,
485: OKC_STATUSES_B STS
486: WHERE KLE.LSE_ID = LSE.ID
487: AND KLE.DNZ_CHR_ID = chrId
488: AND STS.CODE = KLE.STS_CODE
489: AND LSE.LTY_CODE NOT IN ('INSURANCE')

Line 525: okc_statuses_b sts

521: SELECT sum(kle.oec) total_oec
522: FROM okl_k_lines_full_v kle,
523: okc_line_styles_b lse,
524: okc_k_lines_tl tl,
525: okc_statuses_b sts
526: WHERE kle.lse_id = lse.id
527: AND lse.lty_code = 'FREE_FORM1'
528: AND tl.id = kle.id
529: AND tl.language = userenv('LANG')