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_SPLIT_ASSET_PVT dependencies on OKC_LINE_STYLES_B

Line 702: okc_line_styles_b lseb

698: p_lty_code in varchar2) is
699: select cleb.id,
700: cleb.price_unit
701: from okc_k_lines_b cleb,
702: okc_line_styles_b lseb
703: where cleb.cle_id = p_cle_id
704: and cleb.dnz_chr_id = p_chr_id
705: and cleb.lse_id = lseb.id
706: and lseb.lty_code = p_lty_code;

Line 3413: okc_line_styles_b lse

3409: --chk for asset on asset line
3410: CURSOR asset_chk_curs2 (p_asset_number IN VARCHAR2) IS
3411: SELECT 'Y'
3412: FROM okl_k_lines_full_v kle,
3413: okc_line_styles_b lse
3414: WHERE kle.name = p_asset_number
3415: AND kle.lse_id = lse.id
3416: --and lse.lty_code = 'FIXED_ASSET';
3417: --Bug# 3222804

Line 3501: okc_line_styles_b lse

3497: --chk for asset on asset line
3498: CURSOR asset_chk_curs2 (p_asset_number IN VARCHAR2) IS
3499: SELECT 'Y'
3500: FROM okl_k_lines_full_v kle,
3501: okc_line_styles_b lse
3502: WHERE kle.name = p_asset_number
3503: AND kle.lse_id = lse.id
3504: AND lse.lty_code = 'FIXED_ASSET';
3505:

Line 3692: FROM OKC_LINE_STYLES_B lse

3688: SELECT 'Y'
3689: FROM OKC_K_LINES_B cle
3690: WHERE cle.id = p_cle_id
3691: AND EXISTS (SELECT '1'
3692: FROM OKC_LINE_STYLES_B lse
3693: WHERE lse.id = cle.lse_id
3694: AND lse.lty_code = G_FIN_AST_LTY_CODE
3695: AND lse.lse_type = G_TOP_LINE_STYLE)
3696: AND EXISTS (SELECT '1'

Line 4164: okc_line_styles_b model_lse

4160: mtl.organization_id
4161: FROM mtl_system_items mtl,
4162: okc_k_items model_cim,
4163: okc_k_lines_b model_cle,
4164: okc_line_styles_b model_lse
4165: WHERE model_cim.object1_id2 = TO_CHAR(mtl.organization_id)
4166: AND model_cim.object1_id1 = mtl.inventory_item_id
4167: AND model_cim.jtot_object1_code = 'OKX_SYSITEM'
4168: AND model_cim.cle_id = model_cle.id

Line 4692: okc_line_styles_b ib_lse,

4688: FROM csi_item_instances csi,
4689: csi_instance_statuses csi_inst_sts,
4690: okc_k_items ib_cim,
4691: okc_k_lines_b ib_cle,
4692: okc_line_styles_b ib_lse,
4693: okc_k_lines_b inst_cle,
4694: okc_line_styles_b inst_lse,
4695: okc_statuses_b inst_sts,
4696: okc_k_lines_b fa_cle,

Line 4694: okc_line_styles_b inst_lse,

4690: okc_k_items ib_cim,
4691: okc_k_lines_b ib_cle,
4692: okc_line_styles_b ib_lse,
4693: okc_k_lines_b inst_cle,
4694: okc_line_styles_b inst_lse,
4695: okc_statuses_b inst_sts,
4696: okc_k_lines_b fa_cle,
4697: okc_line_styles_b fa_lse,
4698: okl_txl_assets_b txlb

Line 4697: okc_line_styles_b fa_lse,

4693: okc_k_lines_b inst_cle,
4694: okc_line_styles_b inst_lse,
4695: okc_statuses_b inst_sts,
4696: okc_k_lines_b fa_cle,
4697: okc_line_styles_b fa_lse,
4698: okl_txl_assets_b txlb
4699: WHERE csi.instance_id = TO_NUMBER(ib_cim.object1_id1)
4700: AND csi_inst_sts.instance_status_id = csi.instance_status_id
4701: AND NVL(csi_inst_sts.terminated_flag,'N') = 'N'

Line 5016: okc_line_styles_b ib_lse,

5012: COUNT(1)
5013: FROM csi_item_instances csi,
5014: okc_k_items ib_cim,
5015: okc_k_lines_b ib_cle,
5016: okc_line_styles_b ib_lse,
5017: okc_k_lines_b inst_cle,
5018: okc_line_styles_b inst_lse,
5019: okc_statuses_b inst_sts
5020: WHERE csi.instance_id = TO_NUMBER(ib_cim.object1_id1)

Line 5018: okc_line_styles_b inst_lse,

5014: okc_k_items ib_cim,
5015: okc_k_lines_b ib_cle,
5016: okc_line_styles_b ib_lse,
5017: okc_k_lines_b inst_cle,
5018: okc_line_styles_b inst_lse,
5019: okc_statuses_b inst_sts
5020: WHERE csi.instance_id = TO_NUMBER(ib_cim.object1_id1)
5021: AND ib_cim.cle_id = ib_cle.id
5022: AND ib_cim.dnz_chr_id = ib_cle.dnz_chr_id

Line 5261: okc_line_styles_b ib_lse,

5257: csi.install_location_type_code --hz_party_sites OR hz_loactions
5258: FROM csi_item_instances csi,
5259: okc_k_items ib_cim,
5260: okc_k_lines_b ib_cle,
5261: okc_line_styles_b ib_lse,
5262: okc_k_lines_b inst_cle,
5263: okc_line_styles_b inst_lse,
5264: okc_statuses_b inst_sts
5265: WHERE csi.instance_id = TO_NUMBER(ib_cim.object1_id1)

Line 5263: okc_line_styles_b inst_lse,

5259: okc_k_items ib_cim,
5260: okc_k_lines_b ib_cle,
5261: okc_line_styles_b ib_lse,
5262: okc_k_lines_b inst_cle,
5263: okc_line_styles_b inst_lse,
5264: okc_statuses_b inst_sts
5265: WHERE csi.instance_id = TO_NUMBER(ib_cim.object1_id1)
5266: AND ib_cim.cle_id = ib_cle.id
5267: AND ib_cim.dnz_chr_id = ib_cle.dnz_chr_id

Line 5304: okc_line_styles_b ib_lse,

5300: csi.install_location_type_code --hz_party_sites OR hz_locations
5301: FROM csi_item_instances csi,
5302: okc_k_items ib_cim,
5303: okc_k_lines_b ib_cle,
5304: okc_line_styles_b ib_lse,
5305: okc_k_lines_b inst_cle,
5306: okc_line_styles_b inst_lse,
5307: okc_statuses_b inst_sts
5308: WHERE csi.instance_id = TO_NUMBER(ib_cim.object1_id1)

Line 5306: okc_line_styles_b inst_lse,

5302: okc_k_items ib_cim,
5303: okc_k_lines_b ib_cle,
5304: okc_line_styles_b ib_lse,
5305: okc_k_lines_b inst_cle,
5306: okc_line_styles_b inst_lse,
5307: okc_statuses_b inst_sts
5308: WHERE csi.instance_id = TO_NUMBER(ib_cim.object1_id1)
5309: AND ib_cim.cle_id = ib_cle.id
5310: AND ib_cim.dnz_chr_id = ib_cle.dnz_chr_id

Line 5881: okc_line_styles_b lse_fa,

5877: kle.OEC COST,
5878: cle.sts_code LINE_STATUS
5879: FROM okc_k_items cim_fa,
5880: okc_k_lines_b cle_fa,
5881: okc_line_styles_b lse_fa,
5882: okl_k_lines kle,
5883: okc_k_lines_tl clet,
5884: okc_k_lines_b cle
5885: WHERE cim_fa.cle_id = cle_fa.id

Line 5909: okc_line_styles_b oks_cov_pd_lse,

5905: (
5906: SELECT '1'
5907: FROM
5908: okc_k_headers_b oks_chrb,
5909: okc_line_styles_b oks_cov_pd_lse,
5910: okc_k_lines_b oks_cov_pd_cleb,
5911: okc_k_rel_objs krel,
5912: okc_line_styles_b lnk_srv_lse,
5913: okc_statuses_b lnk_srv_sts,

Line 5912: okc_line_styles_b lnk_srv_lse,

5908: okc_k_headers_b oks_chrb,
5909: okc_line_styles_b oks_cov_pd_lse,
5910: okc_k_lines_b oks_cov_pd_cleb,
5911: okc_k_rel_objs krel,
5912: okc_line_styles_b lnk_srv_lse,
5913: okc_statuses_b lnk_srv_sts,
5914: okc_k_lines_b lnk_srv_cleb,
5915: okc_k_items lnk_srv_cim
5916: WHERE oks_chrb.scs_code = 'SERVICE'

Line 7054: OKC_LINE_STYLES_B lse

7050:
7051: CURSOR fa_line_csr(p_cle_id IN NUMBER) IS
7052: SELECT cle.id
7053: FROM OKC_K_LINES_B cle,
7054: OKC_LINE_STYLES_B lse
7055: WHERE cle.cle_id = p_cle_id
7056: AND cle.lse_id = lse.id
7057: AND lse.lty_code = 'FIXED_ASSET'
7058: --Bug# 2761799 : Do not check for active status on sysdate

Line 7815: okc_line_styles_b lnk_lse,

7811: --Bug 3502142
7812: lnk_target_cle.cle_id
7813: FROM okc_k_lines_b lnk_cle,
7814: okc_k_items lnk_cim,
7815: okc_line_styles_b lnk_lse,
7816: okc_k_lines_b lnk_target_cle,
7817: okc_k_items lnk_target_cim,
7818: okc_line_styles_b lnk_target_lse
7819: WHERE lnk_cim.object1_id1 = TO_CHAR(p_cle_id)

Line 7818: okc_line_styles_b lnk_target_lse

7814: okc_k_items lnk_cim,
7815: okc_line_styles_b lnk_lse,
7816: okc_k_lines_b lnk_target_cle,
7817: okc_k_items lnk_target_cim,
7818: okc_line_styles_b lnk_target_lse
7819: WHERE lnk_cim.object1_id1 = TO_CHAR(p_cle_id)
7820: AND lnk_cim.object1_id2 = '#'
7821: AND lnk_cim.jtot_object1_code = 'OKX_COVASST'
7822: AND lnk_cle.id = lnk_cim.cle_id

Line 7844: okc_line_styles_b lnk_lse,

7840: --Bug 3502142
7841: lnk_target_cle.cle_id
7842: FROM okc_k_lines_b lnk_cle,
7843: okc_k_items lnk_cim,
7844: okc_line_styles_b lnk_lse,
7845: okc_k_lines_b lnk_target_cle,
7846: okc_k_items lnk_target_cim,
7847: okc_line_styles_b lnk_target_lse
7848: WHERE lnk_cim.object1_id1 = TO_CHAR(p_cle_id)

Line 7847: okc_line_styles_b lnk_target_lse

7843: okc_k_items lnk_cim,
7844: okc_line_styles_b lnk_lse,
7845: okc_k_lines_b lnk_target_cle,
7846: okc_k_items lnk_target_cim,
7847: okc_line_styles_b lnk_target_lse
7848: WHERE lnk_cim.object1_id1 = TO_CHAR(p_cle_id)
7849: AND lnk_cim.object1_id2 = '#'
7850: AND lnk_cim.jtot_object1_code = 'OKX_COVASST'
7851: AND lnk_cle.id = lnk_cim.cle_id

Line 8735: FROM okc_line_styles_b

8731: START WITH id = p_cle_id;
8732:
8733: CURSOR c_lty_code(p_lse_id IN NUMBER) IS
8734: SELECT lty_code
8735: FROM okc_line_styles_b
8736: WHERE id = p_lse_id;
8737:
8738: --Bug# 3897490 : modified cursor to join to SLH row
8739: --Bug# 3066375 : modified cursor

Line 8813: OKC_LINE_STYLES_B lse,

8809: CURSOR l_lnk_asst_cur (p_cle_id IN NUMBER) IS
8810: SELECT cle.cle_id srv_fee_line_id,
8811: cle.id lnk_line_id
8812: FROM OKC_K_LINES_B cle,
8813: OKC_LINE_STYLES_B lse,
8814: OKC_STATUSES_B sts,
8815: OKC_K_ITEMS cim,
8816: OKC_K_LINES_B fin_asst_line
8817: WHERE cle.lse_id = lse.id

Line 8886: okc_line_styles_b lseb_sub,

8882: okc_k_party_roles_b cplb,
8883: okl_k_lines kle_sub,
8884: okc_k_lines_tl clet_sub,
8885: okc_k_lines_b cleb_sub,
8886: okc_line_styles_b lseb_sub,
8887: okc_k_lines_tl clet_asst,
8888: okc_k_lines_b cleb_asst
8889: WHERE
8890: pov.vendor_id = cplb.object1_id1

Line 8951: okc_line_styles_b lseb_fa,

8947: ,sid.LAST_UPDATE_LOGIN
8948: ,cleb_fa.id fixed_asset_cle_id
8949: FROM okl_supp_invoice_dtls sid,
8950: okc_k_lines_b cleb_fa,
8951: okc_line_styles_b lseb_fa,
8952: okc_k_lines_b cleb
8953: WHERE sid.cle_id = cleb.orig_system_id1
8954: AND cleb_fa.cle_id = cleb.cle_id
8955: AND cleb_fa.dnz_chr_id = cleb.dnz_chr_id

Line 9003: okc_line_styles_b lse

8999: CURSOR l_fa_line_csr(p_chr_id IN NUMBER,
9000: p_cle_id IN NUMBER) IS
9001: SELECT cle.id
9002: FROM okc_k_lines_b cle,
9003: okc_line_styles_b lse
9004: WHERE cle.cle_id = p_cle_id
9005: AND cle.dnz_chr_id = p_chr_id
9006: AND cle.lse_id = lse.id
9007: AND lse.lty_code = 'FIXED_ASSET';

Line 10560: okc_line_styles_b lnk_lseb,

10556: --Cursor to fetch linked asset lines for parent asset being abandoned
10557: CURSOR l_lnk_asst_csr (p_cle_id IN NUMBER) IS
10558: SELECT lnk_cleb.id lnk_cle_id
10559: FROM okc_k_lines_b lnk_cleb,
10560: okc_line_styles_b lnk_lseb,
10561: okc_statuses_b lnk_stsb,
10562: okc_k_items lnk_cim
10563: WHERE lnk_cleb.id = lnk_cim.cle_id
10564: AND lnk_cleb.dnz_chr_id = lnk_cim.dnz_chr_id

Line 13307: okc_line_styles_b ib_lse,

13303: ib_cle.id ib_cle_id
13304: FROM
13305: okc_k_items ib_cim,
13306: okc_k_lines_b ib_cle,
13307: okc_line_styles_b ib_lse,
13308: okc_k_lines_b inst_cle,
13309: okc_line_styles_b inst_lse,
13310: okc_k_lines_b fa_cle,
13311: okc_line_styles_b fa_lse,

Line 13309: okc_line_styles_b inst_lse,

13305: okc_k_items ib_cim,
13306: okc_k_lines_b ib_cle,
13307: okc_line_styles_b ib_lse,
13308: okc_k_lines_b inst_cle,
13309: okc_line_styles_b inst_lse,
13310: okc_k_lines_b fa_cle,
13311: okc_line_styles_b fa_lse,
13312: okl_txl_Assets_b tal
13313: WHERE ib_cim.object1_id1 = TO_CHAR(PInstanceId)

Line 13311: okc_line_styles_b fa_lse,

13307: okc_line_styles_b ib_lse,
13308: okc_k_lines_b inst_cle,
13309: okc_line_styles_b inst_lse,
13310: okc_k_lines_b fa_cle,
13311: okc_line_styles_b fa_lse,
13312: okl_txl_Assets_b tal
13313: WHERE ib_cim.object1_id1 = TO_CHAR(PInstanceId)
13314: AND ib_cim.object1_id2 = '#'
13315: AND ib_cim.jtot_object1_code = 'OKX_IB_ITEM'

Line 13342: okc_line_styles_b ib_lse,

13338: ib_cim.id ib_cim_id
13339: FROM
13340: okc_k_items ib_cim,
13341: okc_k_lines_b ib_cle,
13342: okc_line_styles_b ib_lse,
13343: okc_k_lines_b inst_cle,
13344: okc_line_styles_b inst_lse,
13345: okc_k_lines_b fa_cle,
13346: okc_line_styles_b fa_lse

Line 13344: okc_line_styles_b inst_lse,

13340: okc_k_items ib_cim,
13341: okc_k_lines_b ib_cle,
13342: okc_line_styles_b ib_lse,
13343: okc_k_lines_b inst_cle,
13344: okc_line_styles_b inst_lse,
13345: okc_k_lines_b fa_cle,
13346: okc_line_styles_b fa_lse
13347: WHERE
13348: ib_cim.cle_id = ib_cle.id

Line 13346: okc_line_styles_b fa_lse

13342: okc_line_styles_b ib_lse,
13343: okc_k_lines_b inst_cle,
13344: okc_line_styles_b inst_lse,
13345: okc_k_lines_b fa_cle,
13346: okc_line_styles_b fa_lse
13347: WHERE
13348: ib_cim.cle_id = ib_cle.id
13349: AND ib_cim.dnz_chr_id = ib_cle.dnz_chr_id
13350: AND ib_cle.cle_id = inst_cle.id

Line 13998: okc_line_styles_b lse_model,

13994: cle_fa.dnz_chr_id,
13995: cle_fa.cle_id
13996: FROM okc_k_items cim_model,
13997: okc_k_lines_b cle_model,
13998: okc_line_styles_b lse_model,
13999: okc_k_lines_b cle_fa
14000: WHERE cim_model.dnz_chr_id = cle_model.dnz_chr_id
14001: AND cim_model.cle_id = cle_model.id
14002: AND cle_model.lse_id = lse_model.id

Line 14021: okc_line_styles_b lse_ib,

14017: CURSOR ib_inst_csr(p_fin_ast_id IN NUMBER) IS
14018: SELECT cle_ib.id,
14019: cle_inst.id
14020: FROM okc_k_lines_b cle_ib,
14021: okc_line_styles_b lse_ib,
14022: okc_k_lines_b cle_inst,
14023: okc_line_styles_b lse_inst
14024: WHERE cle_ib.lse_id = lse_ib.id
14025: AND lse_ib.lty_code = 'INST_ITEM'

Line 14023: okc_line_styles_b lse_inst

14019: cle_inst.id
14020: FROM okc_k_lines_b cle_ib,
14021: okc_line_styles_b lse_ib,
14022: okc_k_lines_b cle_inst,
14023: okc_line_styles_b lse_inst
14024: WHERE cle_ib.lse_id = lse_ib.id
14025: AND lse_ib.lty_code = 'INST_ITEM'
14026: AND cle_ib.dnz_chr_id = cle_inst.dnz_chr_id
14027: AND cle_ib.cle_id = cle_inst.id

Line 14041: okc_line_styles_b lse_ib,

14037: CURSOR new_ib_inst_csr(p_txd_id IN NUMBER) IS
14038: SELECT cle_ib.id,
14039: cle_inst.id
14040: FROM okc_k_lines_b cle_ib,
14041: okc_line_styles_b lse_ib,
14042: okc_k_lines_b cle_inst,
14043: okc_line_styles_b lse_inst,
14044: okc_k_lines_b cle_fa,
14045: okl_txd_assets_b txdb

Line 14043: okc_line_styles_b lse_inst,

14039: cle_inst.id
14040: FROM okc_k_lines_b cle_ib,
14041: okc_line_styles_b lse_ib,
14042: okc_k_lines_b cle_inst,
14043: okc_line_styles_b lse_inst,
14044: okc_k_lines_b cle_fa,
14045: okl_txd_assets_b txdb
14046: WHERE cle_ib.lse_id = lse_ib.id
14047: AND lse_ib.lty_code = 'INST_ITEM'

Line 14335: okc_line_styles_b lseb

14331: --cursor to fetch Inastance line id
14332: CURSOR l_instcle_csr(p_cle_id IN NUMBER) IS
14333: SELECT cleb.id
14334: FROM okc_k_lines_b cleb,
14335: okc_line_styles_b lseb
14336: WHERE lseb.id = cleb.lse_id
14337: AND lseb.lty_code = 'FREE_FORM2'
14338: AND cleb.sts_code <> 'ABANDONED'
14339: AND cleb.cle_id = p_cle_id;

Line 14691: OKC_LINE_STYLES_B inst_item_lse,

14687: cim.cle_id,
14688: cim.dnz_chr_id
14689: FROM OKC_K_ITEMS cim,
14690: OKC_K_LINES_B inst_item,
14691: OKC_LINE_STYLES_B inst_item_lse,
14692: OKC_K_LINES_B f_frm2,
14693: OKC_LINE_STYLES_B f_frm2_lse,
14694: OKC_K_LINES_B fa
14695: WHERE cim.cle_id = inst_item.id

Line 14693: OKC_LINE_STYLES_B f_frm2_lse,

14689: FROM OKC_K_ITEMS cim,
14690: OKC_K_LINES_B inst_item,
14691: OKC_LINE_STYLES_B inst_item_lse,
14692: OKC_K_LINES_B f_frm2,
14693: OKC_LINE_STYLES_B f_frm2_lse,
14694: OKC_K_LINES_B fa
14695: WHERE cim.cle_id = inst_item.id
14696: AND cim.dnz_chr_id = inst_item.dnz_chr_id
14697: AND inst_item.cle_id = f_frm2.id

Line 14788: OKC_LINE_STYLES_B inst_item_lse,

14784: SELECT f_frm2.id instance_id,
14785: inst_item.id ib_line_id
14786: FROM OKC_K_ITEMS cim,
14787: OKC_K_LINES_B inst_item,
14788: OKC_LINE_STYLES_B inst_item_lse,
14789: OKC_K_LINES_B f_frm2,
14790: OKC_LINE_STYLES_B f_frm2_lse,
14791: OKC_K_LINES_B fa,
14792: OKL_TXD_ASSETS_B asd

Line 14790: OKC_LINE_STYLES_B f_frm2_lse,

14786: FROM OKC_K_ITEMS cim,
14787: OKC_K_LINES_B inst_item,
14788: OKC_LINE_STYLES_B inst_item_lse,
14789: OKC_K_LINES_B f_frm2,
14790: OKC_LINE_STYLES_B f_frm2_lse,
14791: OKC_K_LINES_B fa,
14792: OKL_TXD_ASSETS_B asd
14793: WHERE cim.cle_id = inst_item.id
14794: AND cim.dnz_chr_id = inst_item.dnz_chr_id

Line 14806: OKC_LINE_STYLES_B inst_item_lse_p,

14802: AND asd.id = p_asd_id
14803: AND EXISTS (SELECT NULL
14804: FROM OKC_K_ITEMS cim_p,
14805: OKC_K_LINES_B inst_item_p,
14806: OKC_LINE_STYLES_B inst_item_lse_p,
14807: OKC_K_LINES_B f_frm2_p,
14808: OKC_LINE_STYLES_B f_frm2_lse_p,
14809: OKC_K_LINES_B fa_p,
14810: OKL_TXL_ASSETS_B tal

Line 14808: OKC_LINE_STYLES_B f_frm2_lse_p,

14804: FROM OKC_K_ITEMS cim_p,
14805: OKC_K_LINES_B inst_item_p,
14806: OKC_LINE_STYLES_B inst_item_lse_p,
14807: OKC_K_LINES_B f_frm2_p,
14808: OKC_LINE_STYLES_B f_frm2_lse_p,
14809: OKC_K_LINES_B fa_p,
14810: OKL_TXL_ASSETS_B tal
14811: WHERE cim_p.object1_id1 = cim.object1_id1
14812: AND cim_p.object1_id2 = cim.object1_id2

Line 16080: OKC_LINE_STYLES_B lse

16076: CURSOR fa_line_csr(p_cle_id IN NUMBER) IS
16077: SELECT cle.id,
16078: cle.dnz_chr_id
16079: FROM OKC_K_LINES_B cle,
16080: OKC_LINE_STYLES_B lse
16081: WHERE cle.cle_id = p_cle_id
16082: AND cle.lse_id = lse.id
16083: AND lse.lty_code = 'FIXED_ASSET'
16084: --Bug Fix# 2744213 - 2761799

Line 16169: ,okc_line_styles_b lseb

16165: tasb.date_trans_occurred
16166: FROM okl_trx_assets tasb
16167: ,okl_txl_assets_b txlb
16168: ,okc_k_lines_b cleb
16169: ,okc_line_styles_b lseb
16170: WHERE txlb.tas_id = tasb.id
16171: AND cleb.id = txlb.kle_id
16172: AND cleb.cle_id = p_cle_id
16173: AND cleb.lse_id = lseb.id

Line 16490: OKC_LINE_STYLES_B lse

16486: --Cursor to get the fixed Asset Line Id
16487: CURSOR l_fixedasst_csr (p_finasst_line IN NUMBER) IS
16488: SELECT cle.id fixedasst_line
16489: FROM OKC_K_LINES_B cle,
16490: OKC_LINE_STYLES_B lse
16491: WHERE cle.cle_id = p_finasst_line
16492: AND cle.lse_id = lse.id
16493: AND lse.lty_code = 'FIXED_ASSET';
16494:

Line 16617: OKC_LINE_STYLES_B lse

16613: CURSOR fa_line_csr(p_cle_id IN NUMBER) IS
16614: SELECT cle.id,
16615: cle.dnz_chr_id
16616: FROM OKC_K_LINES_B cle,
16617: OKC_LINE_STYLES_B lse
16618: WHERE cle.cle_id = p_cle_id
16619: AND cle.lse_id = lse.id
16620: AND lse.lty_code = 'FIXED_ASSET';
16621: