APPS.OKL_SPLIT_ASSET_PVT dependencies on OKC_STATUSES_B

Line 696: FROM okc_k_lines_b cle , OKC_STATUSES_B sts

692: lx_klev_price_tbl klev_tbl_type;
693:
694: CURSOR k_line_curs(p_fa_line_id IN NUMBER) IS
695: SELECT cle.cle_id , sts.ste_code
696: FROM okc_k_lines_b cle , OKC_STATUSES_B sts
697: WHERE id = p_fa_line_id
698: and cle.sts_code = sts.code;
699:
700: l_ste_code OKC_STATUSES_B.STE_CODE%TYPE;

Line 700: l_ste_code OKC_STATUSES_B.STE_CODE%TYPE;

696: FROM okc_k_lines_b cle , OKC_STATUSES_B sts
697: WHERE id = p_fa_line_id
698: and cle.sts_code = sts.code;
699:
700: l_ste_code OKC_STATUSES_B.STE_CODE%TYPE;
701:
702: --cursor to get model and fixed asset lines
703: cursor l_cleb_csr (p_cle_id in number,
704: p_chr_id in number,

Line 4723: okc_statuses_b inst_sts,

4719: okc_k_lines_b ib_cle,
4720: okc_line_styles_b ib_lse,
4721: okc_k_lines_b inst_cle,
4722: okc_line_styles_b inst_lse,
4723: okc_statuses_b inst_sts,
4724: okc_k_lines_b fa_cle,
4725: okc_line_styles_b fa_lse,
4726: okl_txl_assets_b txlb
4727: WHERE csi.instance_id = TO_NUMBER(ib_cim.object1_id1)

Line 5047: okc_statuses_b inst_sts

5043: okc_k_lines_b ib_cle,
5044: okc_line_styles_b ib_lse,
5045: okc_k_lines_b inst_cle,
5046: okc_line_styles_b inst_lse,
5047: okc_statuses_b inst_sts
5048: WHERE csi.instance_id = TO_NUMBER(ib_cim.object1_id1)
5049: AND ib_cim.cle_id = ib_cle.id
5050: AND ib_cim.dnz_chr_id = ib_cle.dnz_chr_id
5051: AND ib_cle.cle_id = inst_cle.id

Line 5292: okc_statuses_b inst_sts

5288: okc_k_lines_b ib_cle,
5289: okc_line_styles_b ib_lse,
5290: okc_k_lines_b inst_cle,
5291: okc_line_styles_b inst_lse,
5292: okc_statuses_b inst_sts
5293: WHERE csi.instance_id = TO_NUMBER(ib_cim.object1_id1)
5294: AND ib_cim.cle_id = ib_cle.id
5295: AND ib_cim.dnz_chr_id = ib_cle.dnz_chr_id
5296: AND ib_cle.cle_id = inst_cle.id

Line 5335: okc_statuses_b inst_sts

5331: okc_k_lines_b ib_cle,
5332: okc_line_styles_b ib_lse,
5333: okc_k_lines_b inst_cle,
5334: okc_line_styles_b inst_lse,
5335: okc_statuses_b inst_sts
5336: WHERE csi.instance_id = TO_NUMBER(ib_cim.object1_id1)
5337: AND ib_cim.cle_id = ib_cle.id
5338: AND ib_cim.dnz_chr_id = ib_cle.dnz_chr_id
5339: AND ib_cle.cle_id = inst_cle.id

Line 5941: okc_statuses_b lnk_srv_sts,

5937: okc_line_styles_b oks_cov_pd_lse,
5938: okc_k_lines_b oks_cov_pd_cleb,
5939: okc_k_rel_objs krel,
5940: okc_line_styles_b lnk_srv_lse,
5941: okc_statuses_b lnk_srv_sts,
5942: okc_k_lines_b lnk_srv_cleb,
5943: okc_k_items lnk_srv_cim
5944: WHERE oks_chrb.scs_code = 'SERVICE'
5945: AND oks_chrb.id = oks_cov_pd_cleb.dnz_chr_id

Line 8867: OKC_STATUSES_B sts,

8863: SELECT cle.cle_id srv_fee_line_id,
8864: cle.id lnk_line_id
8865: FROM OKC_K_LINES_B cle,
8866: OKC_LINE_STYLES_B lse,
8867: OKC_STATUSES_B sts,
8868: OKC_K_ITEMS cim,
8869: OKC_K_LINES_B fin_asst_line
8870: WHERE cle.lse_id = lse.id
8871: AND lse.lty_code IN ('LINK_FEE_ASSET','LINK_SERV_ASSET','LINK_USAGE_ASSET')

Line 10614: okc_statuses_b lnk_stsb,

10610: CURSOR l_lnk_asst_csr (p_cle_id IN NUMBER) IS
10611: SELECT lnk_cleb.id lnk_cle_id
10612: FROM okc_k_lines_b lnk_cleb,
10613: okc_line_styles_b lnk_lseb,
10614: okc_statuses_b lnk_stsb,
10615: okc_k_items lnk_cim
10616: WHERE lnk_cleb.id = lnk_cim.cle_id
10617: AND lnk_cleb.dnz_chr_id = lnk_cim.dnz_chr_id
10618: AND lnk_cleb.lse_id = lnk_lseb.id

Line 16245: okc_statuses_b st

16241: CURSOR c_get_sts_code(p_chr_id NUMBER)
16242: IS
16243: SELECT st.ste_code
16244: FROM OKC_K_HEADERS_V chr,
16245: okc_statuses_b st
16246: WHERE chr.id = p_chr_id
16247: and st.code = chr.sts_code;
16248: lv_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
16249: --Bug# 5946411: ER end