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_COPY_ASSET_PVT dependencies on OKC_LINE_STYLES_V

Line 56: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';

52: -------------------------------------------------------------------------------------------------
53: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_COPY_ASSET_PVT';
54: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
55: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
56: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
57: G_MODEL_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ITEM';
58: G_ADDON_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';
59: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
60: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';

Line 57: G_MODEL_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ITEM';

53: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_COPY_ASSET_PVT';
54: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
55: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
56: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
57: G_MODEL_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ITEM';
58: G_ADDON_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';
59: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
60: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
61: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';

Line 58: G_ADDON_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';

54: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
55: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
56: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
57: G_MODEL_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ITEM';
58: G_ADDON_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';
59: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
60: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
61: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
62: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FEE';

Line 59: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';

55: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
56: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
57: G_MODEL_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ITEM';
58: G_ADDON_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';
59: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
60: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
61: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
62: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FEE';
63: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'SOLD_SERVICE';

Line 60: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';

56: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
57: G_MODEL_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ITEM';
58: G_ADDON_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';
59: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
60: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
61: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
62: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FEE';
63: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'SOLD_SERVICE';
64: G_UBB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'USAGE';

Line 61: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';

57: G_MODEL_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ITEM';
58: G_ADDON_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';
59: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
60: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
61: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
62: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FEE';
63: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'SOLD_SERVICE';
64: G_UBB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'USAGE';
65: G_ID2 CONSTANT VARCHAR2(200) := '#';

Line 62: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FEE';

58: G_ADDON_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';
59: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
60: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
61: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
62: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FEE';
63: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'SOLD_SERVICE';
64: G_UBB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'USAGE';
65: G_ID2 CONSTANT VARCHAR2(200) := '#';
66: G_TRY_TYPE OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';

Line 63: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'SOLD_SERVICE';

59: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
60: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
61: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
62: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FEE';
63: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'SOLD_SERVICE';
64: G_UBB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'USAGE';
65: G_ID2 CONSTANT VARCHAR2(200) := '#';
66: G_TRY_TYPE OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';
67: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';

Line 64: G_UBB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'USAGE';

60: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
61: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
62: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FEE';
63: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'SOLD_SERVICE';
64: G_UBB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'USAGE';
65: G_ID2 CONSTANT VARCHAR2(200) := '#';
66: G_TRY_TYPE OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';
67: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
68: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';

Line 67: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';

63: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'SOLD_SERVICE';
64: G_UBB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'USAGE';
65: G_ID2 CONSTANT VARCHAR2(200) := '#';
66: G_TRY_TYPE OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';
67: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
68: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
69: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
70: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
71: -- G_FA_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE ASSET LINES';

Line 68: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';

64: G_UBB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'USAGE';
65: G_ID2 CONSTANT VARCHAR2(200) := '#';
66: G_TRY_TYPE OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';
67: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
68: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
69: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
70: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
71: -- G_FA_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE ASSET LINES';
72: -- G_IB_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE_IB_LINES';

Line 329: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

325: x_return_status OUT NOCOPY VARCHAR2)
326: IS
327: ln_cle_id OKC_K_LINES_V.CLE_ID%TYPE;
328: ln_chr_id OKC_K_LINES_V.CHR_ID%TYPE;
329: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
330: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
331:
332: i NUMBER := 0;
333: CURSOR c_cle_id_validate(p_cle_id OKC_K_LINES_V.ID%TYPE)

Line 330: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

326: IS
327: ln_cle_id OKC_K_LINES_V.CLE_ID%TYPE;
328: ln_chr_id OKC_K_LINES_V.CHR_ID%TYPE;
329: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
330: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
331:
332: i NUMBER := 0;
333: CURSOR c_cle_id_validate(p_cle_id OKC_K_LINES_V.ID%TYPE)
334: IS

Line 340: okc_line_styles_v lse

336: ,cle.chr_id
337: ,lse.lty_code
338: ,lse.lse_type
339: FROM okc_k_lines_b cle,
340: okc_line_styles_v lse
341: WHERE cle.lse_id = lse.id
342: AND cle.id = p_cle_id;
343:
344: CURSOR c_get_fa_line_id(p_cle_id OKC_K_LINES_V.ID%TYPE)

Line 1721: x_try_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)

1717: RETURN(x_return_status);
1718: END get_itiv_rec;
1719: --------------------------------------------------------------------------
1720: FUNCTION get_try_id(p_try_name IN OKL_TRX_TYPES_V.NAME%TYPE,
1721: x_try_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)
1722: RETURN VARCHAR2 IS
1723: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1724: CURSOR c_get_try_id(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
1725: SELECT id

Line 2312: OKC_LINE_STYLES_V lse_fa,

2308: IS
2309: SELECT cle_ml.id ml_cle_id,
2310: cle_fa.id fa_cle_id
2311: FROM OKC_K_LINES_V cle_fa,
2312: OKC_LINE_STYLES_V lse_fa,
2313: OKC_K_LINES_V cle_ml,
2314: OKC_LINE_STYLES_V lse_ml
2315: WHERE cle_ml.cle_id = p_cle_id
2316: AND cle_ml.lse_id = lse_ml.id

Line 2314: OKC_LINE_STYLES_V lse_ml

2310: cle_fa.id fa_cle_id
2311: FROM OKC_K_LINES_V cle_fa,
2312: OKC_LINE_STYLES_V lse_fa,
2313: OKC_K_LINES_V cle_ml,
2314: OKC_LINE_STYLES_V lse_ml
2315: WHERE cle_ml.cle_id = p_cle_id
2316: AND cle_ml.lse_id = lse_ml.id
2317: AND lse_ml.lty_code = G_MODEL_LINE_LTY_CODE
2318: AND cle_fa.cle_id = cle_ml.cle_id

Line 2328: OKC_LINE_STYLES_V lse_ad,

2324: IS
2325: SELECT cle_ad.id ad_cle_id,
2326: cle_fa.id fa_cle_id
2327: FROM OKC_K_LINES_V cle_ad,
2328: OKC_LINE_STYLES_V lse_ad,
2329: OKC_K_LINES_V cle_fa,
2330: OKC_LINE_STYLES_V lse_fa,
2331: OKC_K_LINES_V cle_ml,
2332: OKC_LINE_STYLES_V lse_ml

Line 2330: OKC_LINE_STYLES_V lse_fa,

2326: cle_fa.id fa_cle_id
2327: FROM OKC_K_LINES_V cle_ad,
2328: OKC_LINE_STYLES_V lse_ad,
2329: OKC_K_LINES_V cle_fa,
2330: OKC_LINE_STYLES_V lse_fa,
2331: OKC_K_LINES_V cle_ml,
2332: OKC_LINE_STYLES_V lse_ml
2333: WHERE cle_ml.cle_id = p_cle_id
2334: AND cle_ml.lse_id = lse_ml.id

Line 2332: OKC_LINE_STYLES_V lse_ml

2328: OKC_LINE_STYLES_V lse_ad,
2329: OKC_K_LINES_V cle_fa,
2330: OKC_LINE_STYLES_V lse_fa,
2331: OKC_K_LINES_V cle_ml,
2332: OKC_LINE_STYLES_V lse_ml
2333: WHERE cle_ml.cle_id = p_cle_id
2334: AND cle_ml.lse_id = lse_ml.id
2335: AND lse_ml.lty_code = G_MODEL_LINE_LTY_CODE
2336: AND cle_fa.cle_id = cle_ml.cle_id

Line 2351: OKC_LINE_STYLES_V lse_ad,

2347: IS
2348: SELECT cle_ad.id ad_cle_id,
2349: cle_fa.id fa_cle_id
2350: FROM OKC_K_LINES_V cle_ad,
2351: OKC_LINE_STYLES_V lse_ad,
2352: OKC_K_LINES_V cle_fa,
2353: OKC_LINE_STYLES_V lse_fa,
2354: OKC_K_LINES_V cle_ml,
2355: OKC_LINE_STYLES_V lse_ml

Line 2353: OKC_LINE_STYLES_V lse_fa,

2349: cle_fa.id fa_cle_id
2350: FROM OKC_K_LINES_V cle_ad,
2351: OKC_LINE_STYLES_V lse_ad,
2352: OKC_K_LINES_V cle_fa,
2353: OKC_LINE_STYLES_V lse_fa,
2354: OKC_K_LINES_V cle_ml,
2355: OKC_LINE_STYLES_V lse_ml
2356: WHERE cle_ml.cle_id = p_cle_id
2357: AND cle_ml.lse_id = lse_ml.id

Line 2355: OKC_LINE_STYLES_V lse_ml

2351: OKC_LINE_STYLES_V lse_ad,
2352: OKC_K_LINES_V cle_fa,
2353: OKC_LINE_STYLES_V lse_fa,
2354: OKC_K_LINES_V cle_ml,
2355: OKC_LINE_STYLES_V lse_ml
2356: WHERE cle_ml.cle_id = p_cle_id
2357: AND cle_ml.lse_id = lse_ml.id
2358: AND lse_ml.lty_code = G_MODEL_LINE_LTY_CODE
2359: AND cle_fa.cle_id = cle_ml.cle_id

Line 2773: OKC_LINE_STYLES_V lse

2769: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
2770: IS
2771: SELECT cle.id
2772: FROM OKC_K_LINES_V cle,
2773: OKC_LINE_STYLES_V lse
2774: WHERE cle.cle_id = p_cle_id
2775: AND cle.dnz_chr_id = p_dnz_chr_id
2776: AND cle.lse_id = lse.id
2777: AND lse.lty_code = G_FA_LINE_LTY_CODE;

Line 3112: OKC_LINE_STYLES_V lse

3108: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
3109: IS
3110: SELECT cle.id
3111: FROM OKC_K_LINES_V cle,
3112: OKC_LINE_STYLES_V lse
3113: WHERE cle.cle_id = p_cle_id
3114: AND cle.dnz_chr_id = p_dnz_chr_id
3115: AND cle.lse_id = lse.id
3116: AND lse.lty_code = G_FA_LINE_LTY_CODE;

Line 3505: OKC_LINE_STYLES_V lse

3501: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
3502: IS
3503: SELECT cle.id
3504: FROM OKC_K_LINES_V cle,
3505: OKC_LINE_STYLES_V lse
3506: WHERE cle.dnz_chr_id = p_dnz_chr_id
3507: AND cle.lse_id = lse.id
3508: AND lse.lty_code = G_IB_LINE_LTY_CODE
3509: AND cle.cle_id in (SELECT cle.id

Line 3511: OKC_LINE_STYLES_V lse

3507: AND cle.lse_id = lse.id
3508: AND lse.lty_code = G_IB_LINE_LTY_CODE
3509: AND cle.cle_id in (SELECT cle.id
3510: FROM OKC_K_LINES_V cle,
3511: OKC_LINE_STYLES_V lse
3512: WHERE cle.cle_id = p_cle_id
3513: AND cle.lse_id = lse.id
3514: AND lse.lty_code = G_INST_LINE_LTY_CODE
3515: AND cle.dnz_chr_id = p_dnz_chr_id);

Line 4180: OKC_LINE_STYLES_V lse

4176: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
4177: IS
4178: SELECT cle.id
4179: FROM OKC_K_LINES_V cle,
4180: OKC_LINE_STYLES_V lse
4181: WHERE cle.cle_id = p_cle_id
4182: AND cle.dnz_chr_id = p_dnz_chr_id
4183: AND cle.lse_id = lse.id
4184: AND lse.lty_code = G_FA_LINE_LTY_CODE;

Line 4198: OKC_LINE_STYLES_V lse

4194: IS
4195: SELECT cle.id,
4196: cle.dnz_chr_id
4197: FROM OKC_K_LINES_V cle,
4198: OKC_LINE_STYLES_V lse
4199: WHERE cle.dnz_chr_id = p_dnz_chr_id
4200: AND cle.lse_id = lse.id
4201: AND lse.lty_code = G_IB_LINE_LTY_CODE
4202: AND cle.cle_id in (SELECT cle.id

Line 4204: OKC_LINE_STYLES_V lse

4200: AND cle.lse_id = lse.id
4201: AND lse.lty_code = G_IB_LINE_LTY_CODE
4202: AND cle.cle_id in (SELECT cle.id
4203: FROM OKC_K_LINES_V cle,
4204: OKC_LINE_STYLES_V lse
4205: WHERE cle.cle_id = p_cle_id
4206: AND cle.lse_id = lse.id
4207: AND lse.lty_code = G_INST_LINE_LTY_CODE
4208: AND cle.dnz_chr_id = p_dnz_chr_id);

Line 4215: FROM OKC_LINE_STYLES_V lse,

4211: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
4212: IS
4213: SELECT cim.object1_id1,
4214: cim.object1_id2
4215: FROM OKC_LINE_STYLES_V lse,
4216: OKC_K_ITEMS_V cim,
4217: OKC_K_LINES_V cle
4218: WHERE cle.dnz_chr_id = p_dnz_chr_id
4219: AND cle.cle_id = p_cle_id