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 709: okc_line_styles_b lseb

705: p_lty_code in varchar2) is
706: select cleb.id,
707: cleb.price_unit
708: from okc_k_lines_b cleb,
709: okc_line_styles_b lseb
710: where cleb.cle_id = p_cle_id
711: and cleb.dnz_chr_id = p_chr_id
712: and cleb.lse_id = lseb.id
713: and lseb.lty_code = p_lty_code;

Line 3441: okc_line_styles_b lse

3437: --chk for asset on asset line
3438: CURSOR asset_chk_curs2 (p_asset_number IN VARCHAR2) IS
3439: SELECT 'Y'
3440: FROM okl_k_lines_full_v kle,
3441: okc_line_styles_b lse
3442: WHERE kle.name = p_asset_number
3443: AND kle.lse_id = lse.id
3444: --and lse.lty_code = 'FIXED_ASSET';
3445: --Bug# 3222804

Line 3529: okc_line_styles_b lse

3525: --chk for asset on asset line
3526: CURSOR asset_chk_curs2 (p_asset_number IN VARCHAR2) IS
3527: SELECT 'Y'
3528: FROM okl_k_lines_full_v kle,
3529: okc_line_styles_b lse
3530: WHERE kle.name = p_asset_number
3531: AND kle.lse_id = lse.id
3532: AND lse.lty_code = 'FIXED_ASSET';
3533:

Line 3720: FROM OKC_LINE_STYLES_B lse

3716: SELECT 'Y'
3717: FROM OKC_K_LINES_B cle
3718: WHERE cle.id = p_cle_id
3719: AND EXISTS (SELECT '1'
3720: FROM OKC_LINE_STYLES_B lse
3721: WHERE lse.id = cle.lse_id
3722: AND lse.lty_code = G_FIN_AST_LTY_CODE
3723: AND lse.lse_type = G_TOP_LINE_STYLE)
3724: AND EXISTS (SELECT '1'

Line 4192: okc_line_styles_b model_lse

4188: mtl.organization_id
4189: FROM mtl_system_items mtl,
4190: okc_k_items model_cim,
4191: okc_k_lines_b model_cle,
4192: okc_line_styles_b model_lse
4193: WHERE model_cim.object1_id2 = TO_CHAR(mtl.organization_id)
4194: AND model_cim.object1_id1 = mtl.inventory_item_id
4195: AND model_cim.jtot_object1_code = 'OKX_SYSITEM'
4196: AND model_cim.cle_id = model_cle.id

Line 4720: okc_line_styles_b ib_lse,

4716: FROM csi_item_instances csi,
4717: csi_instance_statuses csi_inst_sts,
4718: okc_k_items ib_cim,
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,

Line 4722: okc_line_styles_b inst_lse,

4718: okc_k_items ib_cim,
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

Line 4725: okc_line_styles_b fa_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)
4728: AND csi_inst_sts.instance_status_id = csi.instance_status_id
4729: AND NVL(csi_inst_sts.terminated_flag,'N') = 'N'

Line 5044: okc_line_styles_b ib_lse,

5040: COUNT(1)
5041: FROM csi_item_instances csi,
5042: okc_k_items ib_cim,
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)

Line 5046: okc_line_styles_b inst_lse,

5042: okc_k_items ib_cim,
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

Line 5289: okc_line_styles_b ib_lse,

5285: csi.install_location_type_code --hz_party_sites OR hz_loactions
5286: FROM csi_item_instances csi,
5287: okc_k_items ib_cim,
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)

Line 5291: okc_line_styles_b inst_lse,

5287: okc_k_items ib_cim,
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

Line 5332: okc_line_styles_b ib_lse,

5328: csi.install_location_type_code --hz_party_sites OR hz_locations
5329: FROM csi_item_instances csi,
5330: okc_k_items ib_cim,
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)

Line 5334: okc_line_styles_b inst_lse,

5330: okc_k_items ib_cim,
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

Line 5909: okc_line_styles_b lse_fa,

5905: kle.OEC COST,
5906: cle.sts_code LINE_STATUS
5907: FROM okc_k_items cim_fa,
5908: okc_k_lines_b cle_fa,
5909: okc_line_styles_b lse_fa,
5910: okl_k_lines kle,
5911: okc_k_lines_tl clet,
5912: okc_k_lines_b cle
5913: WHERE cim_fa.cle_id = cle_fa.id

Line 5937: okc_line_styles_b oks_cov_pd_lse,

5933: (
5934: SELECT '1'
5935: FROM
5936: okc_k_headers_b oks_chrb,
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,

Line 5940: okc_line_styles_b lnk_srv_lse,

5936: okc_k_headers_b oks_chrb,
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'

Line 7107: OKC_LINE_STYLES_B lse

7103:
7104: CURSOR fa_line_csr(p_cle_id IN NUMBER) IS
7105: SELECT cle.id
7106: FROM OKC_K_LINES_B cle,
7107: OKC_LINE_STYLES_B lse
7108: WHERE cle.cle_id = p_cle_id
7109: AND cle.lse_id = lse.id
7110: AND lse.lty_code = 'FIXED_ASSET'
7111: --Bug# 2761799 : Do not check for active status on sysdate

Line 7868: okc_line_styles_b lnk_lse,

7864: --Bug 3502142
7865: lnk_target_cle.cle_id
7866: FROM okc_k_lines_b lnk_cle,
7867: okc_k_items lnk_cim,
7868: okc_line_styles_b lnk_lse,
7869: okc_k_lines_b lnk_target_cle,
7870: okc_k_items lnk_target_cim,
7871: okc_line_styles_b lnk_target_lse
7872: WHERE lnk_cim.object1_id1 = TO_CHAR(p_cle_id)

Line 7871: okc_line_styles_b lnk_target_lse

7867: okc_k_items lnk_cim,
7868: okc_line_styles_b lnk_lse,
7869: okc_k_lines_b lnk_target_cle,
7870: okc_k_items lnk_target_cim,
7871: okc_line_styles_b lnk_target_lse
7872: WHERE lnk_cim.object1_id1 = TO_CHAR(p_cle_id)
7873: AND lnk_cim.object1_id2 = '#'
7874: AND lnk_cim.jtot_object1_code = 'OKX_COVASST'
7875: AND lnk_cle.id = lnk_cim.cle_id

Line 7897: okc_line_styles_b lnk_lse,

7893: --Bug 3502142
7894: lnk_target_cle.cle_id
7895: FROM okc_k_lines_b lnk_cle,
7896: okc_k_items lnk_cim,
7897: okc_line_styles_b lnk_lse,
7898: okc_k_lines_b lnk_target_cle,
7899: okc_k_items lnk_target_cim,
7900: okc_line_styles_b lnk_target_lse
7901: WHERE lnk_cim.object1_id1 = TO_CHAR(p_cle_id)

Line 7900: okc_line_styles_b lnk_target_lse

7896: okc_k_items lnk_cim,
7897: okc_line_styles_b lnk_lse,
7898: okc_k_lines_b lnk_target_cle,
7899: okc_k_items lnk_target_cim,
7900: okc_line_styles_b lnk_target_lse
7901: WHERE lnk_cim.object1_id1 = TO_CHAR(p_cle_id)
7902: AND lnk_cim.object1_id2 = '#'
7903: AND lnk_cim.jtot_object1_code = 'OKX_COVASST'
7904: AND lnk_cle.id = lnk_cim.cle_id

Line 8788: FROM okc_line_styles_b

8784: START WITH id = p_cle_id;
8785:
8786: CURSOR c_lty_code(p_lse_id IN NUMBER) IS
8787: SELECT lty_code
8788: FROM okc_line_styles_b
8789: WHERE id = p_lse_id;
8790:
8791: --Bug# 3897490 : modified cursor to join to SLH row
8792: --Bug# 3066375 : modified cursor

Line 8866: OKC_LINE_STYLES_B lse,

8862: CURSOR l_lnk_asst_cur (p_cle_id IN NUMBER) IS
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

Line 8939: okc_line_styles_b lseb_sub,

8935: okc_k_party_roles_b cplb,
8936: okl_k_lines kle_sub,
8937: okc_k_lines_tl clet_sub,
8938: okc_k_lines_b cleb_sub,
8939: okc_line_styles_b lseb_sub,
8940: okc_k_lines_tl clet_asst,
8941: okc_k_lines_b cleb_asst
8942: WHERE
8943: pov.vendor_id = cplb.object1_id1

Line 9004: okc_line_styles_b lseb_fa,

9000: ,sid.LAST_UPDATE_LOGIN
9001: ,cleb_fa.id fixed_asset_cle_id
9002: FROM okl_supp_invoice_dtls sid,
9003: okc_k_lines_b cleb_fa,
9004: okc_line_styles_b lseb_fa,
9005: okc_k_lines_b cleb
9006: WHERE sid.cle_id = cleb.orig_system_id1
9007: AND cleb_fa.cle_id = cleb.cle_id
9008: AND cleb_fa.dnz_chr_id = cleb.dnz_chr_id

Line 9056: okc_line_styles_b lse

9052: CURSOR l_fa_line_csr(p_chr_id IN NUMBER,
9053: p_cle_id IN NUMBER) IS
9054: SELECT cle.id
9055: FROM okc_k_lines_b cle,
9056: okc_line_styles_b lse
9057: WHERE cle.cle_id = p_cle_id
9058: AND cle.dnz_chr_id = p_chr_id
9059: AND cle.lse_id = lse.id
9060: AND lse.lty_code = 'FIXED_ASSET';

Line 10613: okc_line_styles_b lnk_lseb,

10609: --Cursor to fetch linked asset lines for parent asset being abandoned
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

Line 13360: okc_line_styles_b ib_lse,

13356: ib_cle.id ib_cle_id
13357: FROM
13358: okc_k_items ib_cim,
13359: okc_k_lines_b ib_cle,
13360: okc_line_styles_b ib_lse,
13361: okc_k_lines_b inst_cle,
13362: okc_line_styles_b inst_lse,
13363: okc_k_lines_b fa_cle,
13364: okc_line_styles_b fa_lse,

Line 13362: okc_line_styles_b inst_lse,

13358: okc_k_items ib_cim,
13359: okc_k_lines_b ib_cle,
13360: okc_line_styles_b ib_lse,
13361: okc_k_lines_b inst_cle,
13362: okc_line_styles_b inst_lse,
13363: okc_k_lines_b fa_cle,
13364: okc_line_styles_b fa_lse,
13365: okl_txl_Assets_b tal
13366: WHERE ib_cim.object1_id1 = TO_CHAR(PInstanceId)

Line 13364: okc_line_styles_b fa_lse,

13360: okc_line_styles_b ib_lse,
13361: okc_k_lines_b inst_cle,
13362: okc_line_styles_b inst_lse,
13363: okc_k_lines_b fa_cle,
13364: okc_line_styles_b fa_lse,
13365: okl_txl_Assets_b tal
13366: WHERE ib_cim.object1_id1 = TO_CHAR(PInstanceId)
13367: AND ib_cim.object1_id2 = '#'
13368: AND ib_cim.jtot_object1_code = 'OKX_IB_ITEM'

Line 13395: okc_line_styles_b ib_lse,

13391: ib_cim.id ib_cim_id
13392: FROM
13393: okc_k_items ib_cim,
13394: okc_k_lines_b ib_cle,
13395: okc_line_styles_b ib_lse,
13396: okc_k_lines_b inst_cle,
13397: okc_line_styles_b inst_lse,
13398: okc_k_lines_b fa_cle,
13399: okc_line_styles_b fa_lse

Line 13397: okc_line_styles_b inst_lse,

13393: okc_k_items ib_cim,
13394: okc_k_lines_b ib_cle,
13395: okc_line_styles_b ib_lse,
13396: okc_k_lines_b inst_cle,
13397: okc_line_styles_b inst_lse,
13398: okc_k_lines_b fa_cle,
13399: okc_line_styles_b fa_lse
13400: WHERE
13401: ib_cim.cle_id = ib_cle.id

Line 13399: okc_line_styles_b fa_lse

13395: okc_line_styles_b ib_lse,
13396: okc_k_lines_b inst_cle,
13397: okc_line_styles_b inst_lse,
13398: okc_k_lines_b fa_cle,
13399: okc_line_styles_b fa_lse
13400: WHERE
13401: ib_cim.cle_id = ib_cle.id
13402: AND ib_cim.dnz_chr_id = ib_cle.dnz_chr_id
13403: AND ib_cle.cle_id = inst_cle.id

Line 14051: okc_line_styles_b lse_model,

14047: cle_fa.dnz_chr_id,
14048: cle_fa.cle_id
14049: FROM okc_k_items cim_model,
14050: okc_k_lines_b cle_model,
14051: okc_line_styles_b lse_model,
14052: okc_k_lines_b cle_fa
14053: WHERE cim_model.dnz_chr_id = cle_model.dnz_chr_id
14054: AND cim_model.cle_id = cle_model.id
14055: AND cle_model.lse_id = lse_model.id

Line 14074: okc_line_styles_b lse_ib,

14070: CURSOR ib_inst_csr(p_fin_ast_id IN NUMBER) IS
14071: SELECT cle_ib.id,
14072: cle_inst.id
14073: FROM okc_k_lines_b cle_ib,
14074: okc_line_styles_b lse_ib,
14075: okc_k_lines_b cle_inst,
14076: okc_line_styles_b lse_inst
14077: WHERE cle_ib.lse_id = lse_ib.id
14078: AND lse_ib.lty_code = 'INST_ITEM'

Line 14076: okc_line_styles_b lse_inst

14072: cle_inst.id
14073: FROM okc_k_lines_b cle_ib,
14074: okc_line_styles_b lse_ib,
14075: okc_k_lines_b cle_inst,
14076: okc_line_styles_b lse_inst
14077: WHERE cle_ib.lse_id = lse_ib.id
14078: AND lse_ib.lty_code = 'INST_ITEM'
14079: AND cle_ib.dnz_chr_id = cle_inst.dnz_chr_id
14080: AND cle_ib.cle_id = cle_inst.id

Line 14094: okc_line_styles_b lse_ib,

14090: CURSOR new_ib_inst_csr(p_txd_id IN NUMBER) IS
14091: SELECT cle_ib.id,
14092: cle_inst.id
14093: FROM okc_k_lines_b cle_ib,
14094: okc_line_styles_b lse_ib,
14095: okc_k_lines_b cle_inst,
14096: okc_line_styles_b lse_inst,
14097: okc_k_lines_b cle_fa,
14098: okl_txd_assets_b txdb

Line 14096: okc_line_styles_b lse_inst,

14092: cle_inst.id
14093: FROM okc_k_lines_b cle_ib,
14094: okc_line_styles_b lse_ib,
14095: okc_k_lines_b cle_inst,
14096: okc_line_styles_b lse_inst,
14097: okc_k_lines_b cle_fa,
14098: okl_txd_assets_b txdb
14099: WHERE cle_ib.lse_id = lse_ib.id
14100: AND lse_ib.lty_code = 'INST_ITEM'

Line 14388: okc_line_styles_b lseb

14384: --cursor to fetch Inastance line id
14385: CURSOR l_instcle_csr(p_cle_id IN NUMBER) IS
14386: SELECT cleb.id
14387: FROM okc_k_lines_b cleb,
14388: okc_line_styles_b lseb
14389: WHERE lseb.id = cleb.lse_id
14390: AND lseb.lty_code = 'FREE_FORM2'
14391: AND cleb.sts_code <> 'ABANDONED'
14392: AND cleb.cle_id = p_cle_id;

Line 14744: OKC_LINE_STYLES_B inst_item_lse,

14740: cim.cle_id,
14741: cim.dnz_chr_id
14742: FROM OKC_K_ITEMS cim,
14743: OKC_K_LINES_B inst_item,
14744: OKC_LINE_STYLES_B inst_item_lse,
14745: OKC_K_LINES_B f_frm2,
14746: OKC_LINE_STYLES_B f_frm2_lse,
14747: OKC_K_LINES_B fa
14748: WHERE cim.cle_id = inst_item.id

Line 14746: OKC_LINE_STYLES_B f_frm2_lse,

14742: FROM OKC_K_ITEMS cim,
14743: OKC_K_LINES_B inst_item,
14744: OKC_LINE_STYLES_B inst_item_lse,
14745: OKC_K_LINES_B f_frm2,
14746: OKC_LINE_STYLES_B f_frm2_lse,
14747: OKC_K_LINES_B fa
14748: WHERE cim.cle_id = inst_item.id
14749: AND cim.dnz_chr_id = inst_item.dnz_chr_id
14750: AND inst_item.cle_id = f_frm2.id

Line 14841: OKC_LINE_STYLES_B inst_item_lse,

14837: SELECT f_frm2.id instance_id,
14838: inst_item.id ib_line_id
14839: FROM OKC_K_ITEMS cim,
14840: OKC_K_LINES_B inst_item,
14841: OKC_LINE_STYLES_B inst_item_lse,
14842: OKC_K_LINES_B f_frm2,
14843: OKC_LINE_STYLES_B f_frm2_lse,
14844: OKC_K_LINES_B fa,
14845: OKL_TXD_ASSETS_B asd

Line 14843: OKC_LINE_STYLES_B f_frm2_lse,

14839: FROM OKC_K_ITEMS cim,
14840: OKC_K_LINES_B inst_item,
14841: OKC_LINE_STYLES_B inst_item_lse,
14842: OKC_K_LINES_B f_frm2,
14843: OKC_LINE_STYLES_B f_frm2_lse,
14844: OKC_K_LINES_B fa,
14845: OKL_TXD_ASSETS_B asd
14846: WHERE cim.cle_id = inst_item.id
14847: AND cim.dnz_chr_id = inst_item.dnz_chr_id

Line 14859: OKC_LINE_STYLES_B inst_item_lse_p,

14855: AND asd.id = p_asd_id
14856: AND EXISTS (SELECT NULL
14857: FROM OKC_K_ITEMS cim_p,
14858: OKC_K_LINES_B inst_item_p,
14859: OKC_LINE_STYLES_B inst_item_lse_p,
14860: OKC_K_LINES_B f_frm2_p,
14861: OKC_LINE_STYLES_B f_frm2_lse_p,
14862: OKC_K_LINES_B fa_p,
14863: OKL_TXL_ASSETS_B tal

Line 14861: OKC_LINE_STYLES_B f_frm2_lse_p,

14857: FROM OKC_K_ITEMS cim_p,
14858: OKC_K_LINES_B inst_item_p,
14859: OKC_LINE_STYLES_B inst_item_lse_p,
14860: OKC_K_LINES_B f_frm2_p,
14861: OKC_LINE_STYLES_B f_frm2_lse_p,
14862: OKC_K_LINES_B fa_p,
14863: OKL_TXL_ASSETS_B tal
14864: WHERE cim_p.object1_id1 = cim.object1_id1
14865: AND cim_p.object1_id2 = cim.object1_id2

Line 16172: OKC_LINE_STYLES_B lse

16168: CURSOR fa_line_csr(p_cle_id IN NUMBER) IS
16169: SELECT cle.id,
16170: cle.dnz_chr_id
16171: FROM OKC_K_LINES_B cle,
16172: OKC_LINE_STYLES_B lse
16173: WHERE cle.cle_id = p_cle_id
16174: AND cle.lse_id = lse.id
16175: AND lse.lty_code = 'FIXED_ASSET'
16176: --Bug Fix# 2744213 - 2761799

Line 16261: ,okc_line_styles_b lseb

16257: tasb.date_trans_occurred
16258: FROM okl_trx_assets tasb
16259: ,okl_txl_assets_b txlb
16260: ,okc_k_lines_b cleb
16261: ,okc_line_styles_b lseb
16262: WHERE txlb.tas_id = tasb.id
16263: AND cleb.id = txlb.kle_id
16264: AND cleb.cle_id = p_cle_id
16265: AND cleb.lse_id = lseb.id

Line 16582: OKC_LINE_STYLES_B lse

16578: --Cursor to get the fixed Asset Line Id
16579: CURSOR l_fixedasst_csr (p_finasst_line IN NUMBER) IS
16580: SELECT cle.id fixedasst_line
16581: FROM OKC_K_LINES_B cle,
16582: OKC_LINE_STYLES_B lse
16583: WHERE cle.cle_id = p_finasst_line
16584: AND cle.lse_id = lse.id
16585: AND lse.lty_code = 'FIXED_ASSET';
16586:

Line 16709: OKC_LINE_STYLES_B lse

16705: CURSOR fa_line_csr(p_cle_id IN NUMBER) IS
16706: SELECT cle.id,
16707: cle.dnz_chr_id
16708: FROM OKC_K_LINES_B cle,
16709: OKC_LINE_STYLES_B lse
16710: WHERE cle.cle_id = p_cle_id
16711: AND cle.lse_id = lse.id
16712: AND lse.lty_code = 'FIXED_ASSET';
16713: