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.OKS_IBINT_PUB dependencies on OKC_K_LINES_B

Line 32: ,okc_k_lines_b line

28:
29: CURSOR l_k_exists (p_item_id NUMBER)IS
30: Select 'x'
31: From okc_k_rel_objs rel
32: ,okc_k_lines_b line
33: ,okc_k_items item
34: Where rel.Object1_Id1 = to_char(p_srvord_line_id)
35: And rel.jtot_object1_code = 'OKX_ORDERLINE'
36: And item.cle_id = line.id

Line 421: ,okc_k_lines_b line

417:
418: Cursor l_rel_csr(p_ordlineid Number, p_serv_ordline_id Number,p_item_id Number) Is
419: Select rel.cle_id
420: From okc_k_rel_objs rel
421: ,okc_k_lines_b line
422: ,okc_k_items item
423: Where rel.Object1_Id1 in (to_char(p_ordlineid),to_char(p_serv_ordline_id))
424: And rel.jtot_object1_code = 'OKX_ORDERLINE'
425: And item.cle_id = line.id

Line 437: ,okc_k_lines_b line

433:
434: Cursor l_cle_csr(p_ordlineid Number, p_serv_ordline_id Number) Is
435: Select rel.cle_id
436: From okc_k_rel_objs_v rel
437: ,okc_k_lines_b line
438: Where rel.Object1_Id1 in (to_char(p_ordlineid),to_char(p_serv_ordline_id))
439: And rel.jtot_object1_code = 'OKX_ORDERLINE'
440: And line.id = rel.cle_id
441: And line.lse_id in (1,19);

Line 445: From Okc_k_lines_b line

441: And line.lse_id in (1,19);
442:
443: Cursor l_object_csr(p_cle_id Number, p_cp_id Number) Is
444: Select line.id
445: From Okc_k_lines_b line
446: ,okc_k_items item
447: WHere item.cle_id = line.id
448: ANd line.cle_id = p_cle_id
449: And line.lse_id in (9, 25)

Line 1266: , OKC_K_LINES_B OL

1262: ,OKC_K_LINES_V KL
1263: ,OKS_K_LINES_B OKL
1264: ,OKC_STATUSES_B ST
1265: ,OKC_K_PARTY_ROLES_B PARTY
1266: , OKC_K_LINES_B OL
1267: ,OKS_K_LINES_B KSL
1268: ,OKC_K_ITEMS KIS
1269: , OKS_INSTANCE_TEMP tmp
1270:

Line 1369: , OKC_K_LINES_B KL

1365: , Null
1366:
1367: From OKC_K_ITEMS KI
1368: , OKC_K_HEADERS_ALL_B KH
1369: , OKC_K_LINES_B KL
1370: , OKC_STATUSES_B ST
1371: , OKS_INSTANCE_TEMP tmp
1372: , OKC_K_LINES_B TL
1373: ,OKC_K_ITEMS KIS

Line 1372: , OKC_K_LINES_B TL

1368: , OKC_K_HEADERS_ALL_B KH
1369: , OKC_K_LINES_B KL
1370: , OKC_STATUSES_B ST
1371: , OKS_INSTANCE_TEMP tmp
1372: , OKC_K_LINES_B TL
1373: ,OKC_K_ITEMS KIS
1374: ,OKC_K_PARTY_ROLES_B PARTY
1375: Where tmp.trm = 'Y'
1376: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)

Line 1472: ,OKC_K_LINES_B KL

1468:
1469:
1470: From OKC_K_ITEMS KI
1471: ,OKC_K_HEADERS_ALL_B KH
1472: ,OKC_K_LINES_B KL
1473: ,OKC_K_LINES_B TL
1474: ,OKC_STATUSES_B ST
1475: ,csi_counter_associations CTRASC
1476: ,OKS_INSTANCE_TEMP tmp

Line 1473: ,OKC_K_LINES_B TL

1469:
1470: From OKC_K_ITEMS KI
1471: ,OKC_K_HEADERS_ALL_B KH
1472: ,OKC_K_LINES_B KL
1473: ,OKC_K_LINES_B TL
1474: ,OKC_STATUSES_B ST
1475: ,csi_counter_associations CTRASC
1476: ,OKS_INSTANCE_TEMP tmp
1477: ,OKC_K_ITEMS KIS

Line 1572: , OKC_K_LINES_B KL

1568: , Null
1569: , Null
1570: From OKC_K_ITEMS KI
1571: , OKC_K_HEADERS_ALL_B KH
1572: , OKC_K_LINES_B KL
1573: , OKC_STATUSES_B ST
1574: , OKS_INSTANCE_TEMP tmp
1575: , OKC_K_LINES_B TL
1576: ,OKC_K_ITEMS KIS

Line 1575: , OKC_K_LINES_B TL

1571: , OKC_K_HEADERS_ALL_B KH
1572: , OKC_K_LINES_B KL
1573: , OKC_STATUSES_B ST
1574: , OKS_INSTANCE_TEMP tmp
1575: , OKC_K_LINES_B TL
1576: ,OKC_K_ITEMS KIS
1577: ,OKC_K_PARTY_ROLES_B PARTY
1578:
1579: Where tmp.ret = 'Y'

Line 1674: ,OKC_K_LINES_B KL

1670: , null
1671: , null
1672: From OKC_K_ITEMS KI
1673: ,OKC_K_HEADERS_ALL_B KH
1674: ,OKC_K_LINES_B KL
1675: ,OKC_K_LINES_B TL
1676: ,OKC_STATUSES_B ST
1677: ,csi_counter_associations CTRASC
1678: , OKS_INSTANCE_TEMP tmp

Line 1675: ,OKC_K_LINES_B TL

1671: , null
1672: From OKC_K_ITEMS KI
1673: ,OKC_K_HEADERS_ALL_B KH
1674: ,OKC_K_LINES_B KL
1675: ,OKC_K_LINES_B TL
1676: ,OKC_STATUSES_B ST
1677: ,csi_counter_associations CTRASC
1678: , OKS_INSTANCE_TEMP tmp
1679: ,OKC_K_ITEMS KIS

Line 1777: , OKC_K_LINES_B KL

1773: , null
1774: , null
1775: From OKC_K_ITEMS KI
1776: , OKC_K_HEADERS_ALL_B KH
1777: , OKC_K_LINES_B KL
1778: , OKC_STATUSES_B ST
1779: , OKS_INSTANCE_TEMP tmp
1780: , OKC_K_LINES_B TL
1781: ,OKC_K_ITEMS KIS

Line 1780: , OKC_K_LINES_B TL

1776: , OKC_K_HEADERS_ALL_B KH
1777: , OKC_K_LINES_B KL
1778: , OKC_STATUSES_B ST
1779: , OKS_INSTANCE_TEMP tmp
1780: , OKC_K_LINES_B TL
1781: ,OKC_K_ITEMS KIS
1782: Where tmp.idc = 'Y'
1783: And nvl(tmp.trm,'N') = 'N'
1784: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)

Line 1857: , OKC_K_LINES_B TL

1853: , OKC_K_HEADERS_ALL_B KH
1854: , OKC_K_LINES_v KL
1855: , OKC_STATUSES_B ST
1856: , OKS_INSTANCE_TEMP tmp
1857: , OKC_K_LINES_B TL
1858: ,OKC_K_ITEMS KIS
1859: , OKS_K_LINES_B OKL
1860: Where tmp.spl = 'Y'
1861: And nvl(tmp.trm,'N') = 'N'

Line 1938: , OKC_K_LINES_B TL

1934: , OKC_K_HEADERS_ALL_B KH
1935: , OKC_K_LINES_v KL
1936: , OKC_STATUSES_B ST
1937: , OKS_INSTANCE_TEMP tmp
1938: , OKC_K_LINES_B TL
1939: ,OKC_K_ITEMS KIS
1940: , OKS_K_LINES_B OKL
1941:
1942: Where tmp.rpl = 'Y'

Line 2016: , OKC_K_LINES_B KL

2012: , okl.toplvl_uom_code
2013: , okl.toplvl_price_qty
2014: From OKC_K_ITEMS KI
2015: , OKC_K_HEADERS_ALL_B KH
2016: , OKC_K_LINES_B KL
2017: , OKC_STATUSES_B ST
2018: , OKS_INSTANCE_TEMP tmp
2019: , OKC_K_LINES_B TL
2020: , OKC_K_ITEMS KIS

Line 2019: , OKC_K_LINES_B TL

2015: , OKC_K_HEADERS_ALL_B KH
2016: , OKC_K_LINES_B KL
2017: , OKC_STATUSES_B ST
2018: , OKS_INSTANCE_TEMP tmp
2019: , OKC_K_LINES_B TL
2020: , OKC_K_ITEMS KIS
2021: , OKS_K_LINES_B OKL
2022: Where tmp.upd = 'Y'
2023: And Nvl(tmp.trm,'N') = 'N'

Line 2931: from okc_k_lines_b sl,

2927: sl.end_date,
2928: (NVL(sl.price_negotiated,0)+NVL(ksl.tax_amount,0)) price_negotiated,
2929: sl.currency_code ,
2930: sl.date_terminated
2931: from okc_k_lines_b sl,
2932: okc_k_lines_b tl,
2933: okc_statuses_v sts,
2934: okc_k_items sli,
2935: okc_line_styles_v lst,

Line 2932: okc_k_lines_b tl,

2928: (NVL(sl.price_negotiated,0)+NVL(ksl.tax_amount,0)) price_negotiated,
2929: sl.currency_code ,
2930: sl.date_terminated
2931: from okc_k_lines_b sl,
2932: okc_k_lines_b tl,
2933: okc_statuses_v sts,
2934: okc_k_items sli,
2935: okc_line_styles_v lst,
2936: okc_line_styles_v tlst,

Line 3168: ,OKC_K_LINES_B KL

3164: Select CL.id
3165:
3166: From OKC_K_ITEMS KI
3167: ,OKC_K_HEADERS_ALL_B KH
3168: ,OKC_K_LINES_B KL
3169: ,OKC_K_LINES_B CL
3170: ,OKC_STATUSES_b ST
3171:
3172: Where

Line 3169: ,OKC_K_LINES_B CL

3165:
3166: From OKC_K_ITEMS KI
3167: ,OKC_K_HEADERS_ALL_B KH
3168: ,OKC_K_LINES_B KL
3169: ,OKC_K_LINES_B CL
3170: ,OKC_STATUSES_b ST
3171:
3172: Where
3173: KI.Jtot_Object1_code = 'OKX_CUSTPROD'

Line 3192: ,OKC_K_LINES_B CL

3188: cursor trm_trf_contracts IS
3189: Select CL.id
3190: From OKC_K_ITEMS KI
3191: ,OKC_K_HEADERS_ALL_B KH
3192: ,OKC_K_LINES_B CL
3193: ,OKC_STATUSES_b ST
3194: Where KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3195: AND KI.object1_id1 = to_char(p_instance_id )
3196: And KH.scs_code in ('WARRANTY','SERVICE','SUBSCRIPTION' )

Line 3221: ,OKC_K_LINES_B CL

3217: cursor trm_trf_contracts1 IS
3218: Select CL.id
3219: From OKC_K_ITEMS KI
3220: ,OKC_K_HEADERS_ALL_B KH
3221: ,OKC_K_LINES_B CL
3222: ,OKC_STATUSES_b ST
3223: ,oks_instance_k_dtls_temp temp
3224: Where KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3225: AND KI.object1_id1 = to_char(temp.instance_id)

Line 3254: ,OKC_K_LINES_B CL

3250: cursor trm_usages_contracts IS
3251: Select CL.id
3252: From OKC_K_ITEMS KI
3253: ,OKC_K_HEADERS_ALL_B KH
3254: ,OKC_K_LINES_B CL
3255: ,OKC_STATUSES_B ST
3256: ,csi_counter_associations CTRASC
3257:
3258: where KI.object1_id1 = to_char(CTRASC.COunter_id)

Line 3287: ,OKC_K_LINES_B CL

3283: cursor trm_usages_contracts1 IS
3284: Select CL.id
3285: From OKC_K_ITEMS KI
3286: ,OKC_K_HEADERS_ALL_B KH
3287: ,OKC_K_LINES_B CL
3288: ,OKC_STATUSES_B ST
3289: ,csi_counter_associations CTRASC
3290: ,oks_instance_k_dtls_temp temp
3291: where KI.object1_id1 = to_char(CTRASC.COunter_id)

Line 3323: ,OKC_K_LINES_B KL

3319: cursor spl_upd_contracts IS
3320: Select CL.id
3321: From OKC_K_ITEMS KI
3322: ,OKC_K_HEADERS_ALL_B KH
3323: ,OKC_K_LINES_B KL
3324: ,OKC_K_LINES_B CL
3325: ,OKC_STATUSES_b ST
3326: Where
3327: KI.Jtot_Object1_code = 'OKX_CUSTPROD'

Line 3324: ,OKC_K_LINES_B CL

3320: Select CL.id
3321: From OKC_K_ITEMS KI
3322: ,OKC_K_HEADERS_ALL_B KH
3323: ,OKC_K_LINES_B KL
3324: ,OKC_K_LINES_B CL
3325: ,OKC_STATUSES_b ST
3326: Where
3327: KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3328: AND KI.object1_id1 = to_char(p_instance_id)

Line 3346: ,OKC_K_LINES_B CL

3342: cursor rin_contracts IS
3343: Select cl.id
3344: From OKC_K_ITEMS KI
3345: ,OKC_K_HEADERS_ALL_B KH
3346: ,OKC_K_LINES_B CL
3347: Where
3348: KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3349: AND KI.object1_id1 = to_char(p_instance_id)
3350: And KI.dnz_chr_id = KH.ID

Line 3524: FROM okc_k_lines_b

3520: CURSOR top_line_dtls_csr(p_chr_id NUMBER)
3521: IS
3522: SELECT start_date, end_date, sts_code, lse_id,
3523: currency_code, line_renewal_type_code
3524: FROM okc_k_lines_b
3525: WHERE chr_id = p_chr_id
3526: AND id = p_attach2_line_id;
3527:
3528: CURSOR prod_party_validity_csr (p_chr_id NUMBER,p_cust_prod_id NUMBER)

Line 3623: FROM okc_k_lines_b

3619: max_line_number NUMBER;
3620: CURSOR get_line_number
3621: IS
3622: SELECT NVL (MAX (TO_NUMBER (line_number)), 0) + 1
3623: FROM okc_k_lines_b
3624: WHERE dnz_chr_id = p_chr_id
3625: AND cle_id = p_cle_id
3626: AND lse_id IN (35, 7, 8, 9, 10, 11, 13, 18, 25);
3627: BEGIN