eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LA_STREAM_PVT dependencies on OKC_STATUSES_B

Line 3923: okc_statuses_b sts

3919: tl.name
3920: FROM okl_k_lines_full_v kle,
3921: okc_line_styles_b lse,
3922: okc_k_lines_tl tl,
3923: okc_statuses_b sts
3924: WHERE kle.lse_id = lse.id
3925: AND lse.lty_code in ( 'FREE_FORM1', 'FEE', 'SOLD_SERVICE', 'LINK_SERV_ASSET')--bug# 3343133 (ssiruvol)
3926: AND tl.id = kle.id
3927: AND tl.language = USERENV('LANG')

Line 5789: okc_statuses_b sts

5785: --okl_strm_type_v sty,
5786: OKL_STRM_TMPT_LINES_UV sty,
5787: okl_k_lines_full_v kle,
5788: okc_line_styles_b lse,
5789: okc_statuses_b sts
5790: Where ele.stm_id = str.id
5791: and str.khr_id = chrId
5792: and str.kle_id = kle.id
5793: and str.sty_id = sty.primary_sty_id

Line 6426: , OKC_STATUSES_B STS

6422: FROM OKC_K_LINES_B LNK_CLE
6423: , OKC_LINE_STYLES_B LNK_LSE
6424: , OKL_K_LINES FEE_KLE
6425: , OKC_K_LINES_B FEE_CLE
6426: , OKC_STATUSES_B STS
6427: WHERE LNK_CLE.CLE_ID = FEE_CLE.ID
6428: AND LNK_CLE.DNZ_CHR_ID = cp_chr_id
6429: AND FEE_CLE.DNZ_CHR_ID = cp_chr_id
6430: AND LNK_LSE.ID = LNK_CLE.LSE_ID

Line 6447: , OKC_STATUSES_B STS

6443: , CLE.DATE_TERMINATED
6444: FROM OKL_K_HEADERS KHR
6445: , OKC_K_LINES_B CLE
6446: , OKC_LINE_STYLES_B LSE
6447: , OKC_STATUSES_B STS
6448: WHERE CLE.DNZ_CHR_ID = KHR.ID
6449: AND LSE.ID = CLE.LSE_ID
6450: AND LSE.LTY_CODE ='FREE_FORM1'
6451: AND STS.CODE = CLE.STS_CODE

Line 7201: okc_statuses_b sts

7197: AND (NVL( str.kle_id, -1) = -1 OR
7198: str.kle_id IN (SELECT kle.id
7199: FROM okl_k_lines_full_v kle,
7200: okc_line_styles_b lse,
7201: okc_statuses_b sts
7202: WHERE KLE.LSE_ID = LSE.ID
7203: AND kle.dnz_chr_id = p_chr_id
7204: AND sts.code = kle.sts_code
7205: AND lse.lty_code NOT IN ('INSURANCE')));

Line 8096: okc_statuses_b sts

8092: IS
8093: SELECT cle.id
8094: FROM okc_k_lines_b cle,
8095: okc_line_styles_b lse,
8096: okc_statuses_b sts
8097: WHERE cle.dnz_chr_id = chrid
8098: AND cle.lse_id = lse.id
8099: AND lse.lty_code = 'FREE_FORM1'
8100: AND sts.code = cle.sts_code

Line 8110: okc_statuses_b sts

8106: SELECT kle.fee_type
8107: FROM okl_k_lines kle,
8108: okc_k_lines_b cle,
8109: okc_line_styles_b lse,
8110: okc_statuses_b sts
8111: WHERE cle.lse_id = lse.id
8112: AND lse.lty_code = 'FEE'
8113: AND cle.dnz_chr_id = chrid
8114: AND cle.id = kle.id

Line 8128: okc_statuses_b sts

8124: SELECT cle.id fin_id
8125: FROM okc_k_lines_b cle,
8126: okc_line_styles_b lse,
8127: okl_k_lines kle,
8128: okc_statuses_b sts
8129: WHERE cle.dnz_chr_id = chrId
8130: AND cle.lse_id = lse.id
8131: AND lse.lty_code = 'FEE'
8132: AND cle.id = kle.id

Line 8144: okc_statuses_b sts

8140: SELECT cle.id fin_id
8141: FROM okc_k_lines_b cle,
8142: okc_line_styles_b lse,
8143: okl_k_lines kle,
8144: okc_statuses_b sts
8145: WHERE cle.dnz_chr_id = chrId
8146: AND cle.lse_id = lse.id
8147: AND lse.lty_code = 'FEE'
8148: AND cle.id = kle.id

Line 8176: okc_statuses_b sts,

8172: FROM okl_sgn_translations sgn,
8173: okl_strm_type_b sty,
8174: okl_subsidies_v sub,
8175: okl_k_lines kle,
8176: okc_statuses_b sts,
8177: okc_line_styles_b lse,
8178: okc_k_lines_b cle
8179: WHERE cle.dnz_chr_id = p_dnz_chr_id
8180: AND cle.lse_id = lse.id

Line 8200: okc_statuses_b sts,

8196: --srsreeni Bug5699923 End
8197: FROM okl_k_lines kle,
8198: okc_k_lines_b cle,
8199: okl_subsidies_v sub,
8200: okc_statuses_b sts,
8201: okc_line_styles_b lse
8202: WHERE cle.dnz_chr_id = p_dnz_chr_id
8203: AND cle.lse_id = lse.id
8204: AND lse.lty_code = 'SUBSIDY'

Line 8666: okc_statuses_b sts

8662: tl.name
8663: from okl_k_lines_full_v kle,
8664: okc_line_styles_b lse,
8665: okc_k_lines_tl tl,
8666: okc_statuses_b sts
8667: where KLE.LSE_ID = LSE.ID
8668: and lse.lty_code = lnetype
8669: and tl.id = kle.id
8670: and tl.language = userenv('LANG')

Line 9457: okc_statuses_b sts

9453: kle.capitalize_down_payment_yn
9454: FROM okl_k_lines_full_v kle,
9455: okc_line_styles_b lse,
9456: okc_k_lines_tl tl,
9457: okc_statuses_b sts
9458: WHERE kle.lse_id = lse.id
9459: AND lse.lty_code = 'LINK_FEE_ASSET'
9460: AND tl.id = kle.id
9461: AND kle.cle_id = p_cle_id

Line 9509: ,okc_statuses_b sts

9505: -- srsreeni - Bug#5699923 - Added - End
9506: FROM okc_k_lines_b okc,
9507: okl_k_lines kle ,
9508: okc_line_styles_b lse
9509: ,okc_statuses_b sts
9510: WHERE okc.cle_id = cleId
9511: AND okc.lse_id = lse.id
9512: AND okc.id = kle.id
9513: AND lty_code = 'LINK_FEE_ASSET'

Line 17640: okc_statuses_b sts

17636: kle.capitalize_down_payment_yn
17637: FROM okl_k_lines_full_v kle,
17638: okc_line_styles_b lse,
17639: okc_k_lines_tl tl,
17640: okc_statuses_b sts
17641: WHERE kle.lse_id = lse.id
17642: AND lse.lty_code = lnetype
17643: AND tl.id = kle.id
17644: AND tl.language = userenv('LANG')

Line 21955: okc_statuses_b sts

21951: tl.name
21952: FROM okl_k_lines_full_v kle,
21953: okc_line_styles_b lse,
21954: okc_k_lines_tl tl,
21955: okc_statuses_b sts
21956: WHERE kle.lse_id = lse.id
21957: AND lse.lty_code = lnetype
21958: AND tl.id = kle.id
21959: AND tl.language = userenv('LANG')

Line 21990: okc_statuses_b sts

21986: tl.name
21987: FROM okl_k_lines_full_v kle,
21988: okc_line_styles_b lse,
21989: okc_k_lines_tl tl,
21990: okc_statuses_b sts
21991: WHERE kle.lse_id = lse.id
21992: AND lse.lty_code = 'SO_PAYMENT'
21993: AND kle.id = p_cle_id
21994: AND tl.id = kle.id