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 425: ,okc_k_lines_b line

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

Line 441: ,okc_k_lines_b line

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

Line 449: From Okc_k_lines_b line

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

Line 1246: , OKC_K_LINES_B OL

1242: ,OKC_K_LINES_V KL
1243: ,OKS_K_LINES_B OKL
1244: ,OKC_STATUSES_B ST
1245: ,OKC_K_PARTY_ROLES_B PARTY
1246: , OKC_K_LINES_B OL
1247: ,OKS_K_LINES_B KSL
1248: ,OKC_K_ITEMS KIS
1249: , OKS_INSTANCE_TEMP tmp
1250:

Line 1349: , OKC_K_LINES_B KL

1345: , Null
1346:
1347: From OKC_K_ITEMS KI
1348: , OKC_K_HEADERS_ALL_B KH
1349: , OKC_K_LINES_B KL
1350: , OKC_STATUSES_B ST
1351: , OKS_INSTANCE_TEMP tmp
1352: , OKC_K_LINES_B TL
1353: ,OKC_K_ITEMS KIS

Line 1352: , OKC_K_LINES_B TL

1348: , OKC_K_HEADERS_ALL_B KH
1349: , OKC_K_LINES_B KL
1350: , OKC_STATUSES_B ST
1351: , OKS_INSTANCE_TEMP tmp
1352: , OKC_K_LINES_B TL
1353: ,OKC_K_ITEMS KIS
1354: ,OKC_K_PARTY_ROLES_B PARTY
1355: Where tmp.trm = 'Y'
1356: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)

Line 1452: ,OKC_K_LINES_B KL

1448:
1449:
1450: From OKC_K_ITEMS KI
1451: ,OKC_K_HEADERS_ALL_B KH
1452: ,OKC_K_LINES_B KL
1453: ,OKC_K_LINES_B TL
1454: ,OKC_STATUSES_B ST
1455: ,csi_counter_associations CTRASC
1456: ,OKS_INSTANCE_TEMP tmp

Line 1453: ,OKC_K_LINES_B TL

1449:
1450: From OKC_K_ITEMS KI
1451: ,OKC_K_HEADERS_ALL_B KH
1452: ,OKC_K_LINES_B KL
1453: ,OKC_K_LINES_B TL
1454: ,OKC_STATUSES_B ST
1455: ,csi_counter_associations CTRASC
1456: ,OKS_INSTANCE_TEMP tmp
1457: ,OKC_K_ITEMS KIS

Line 1552: , OKC_K_LINES_B KL

1548: , Null
1549: , Null
1550: From OKC_K_ITEMS KI
1551: , OKC_K_HEADERS_ALL_B KH
1552: , OKC_K_LINES_B KL
1553: , OKC_STATUSES_B ST
1554: , OKS_INSTANCE_TEMP tmp
1555: , OKC_K_LINES_B TL
1556: ,OKC_K_ITEMS KIS

Line 1555: , OKC_K_LINES_B TL

1551: , OKC_K_HEADERS_ALL_B KH
1552: , OKC_K_LINES_B KL
1553: , OKC_STATUSES_B ST
1554: , OKS_INSTANCE_TEMP tmp
1555: , OKC_K_LINES_B TL
1556: ,OKC_K_ITEMS KIS
1557: ,OKC_K_PARTY_ROLES_B PARTY
1558:
1559: Where tmp.ret = 'Y'

Line 1654: ,OKC_K_LINES_B KL

1650: , null
1651: , null
1652: From OKC_K_ITEMS KI
1653: ,OKC_K_HEADERS_ALL_B KH
1654: ,OKC_K_LINES_B KL
1655: ,OKC_K_LINES_B TL
1656: ,OKC_STATUSES_B ST
1657: ,csi_counter_associations CTRASC
1658: , OKS_INSTANCE_TEMP tmp

Line 1655: ,OKC_K_LINES_B TL

1651: , null
1652: From OKC_K_ITEMS KI
1653: ,OKC_K_HEADERS_ALL_B KH
1654: ,OKC_K_LINES_B KL
1655: ,OKC_K_LINES_B TL
1656: ,OKC_STATUSES_B ST
1657: ,csi_counter_associations CTRASC
1658: , OKS_INSTANCE_TEMP tmp
1659: ,OKC_K_ITEMS KIS

Line 1757: , OKC_K_LINES_B KL

1753: , null
1754: , null
1755: From OKC_K_ITEMS KI
1756: , OKC_K_HEADERS_ALL_B KH
1757: , OKC_K_LINES_B KL
1758: , OKC_STATUSES_B ST
1759: , OKS_INSTANCE_TEMP tmp
1760: , OKC_K_LINES_B TL
1761: ,OKC_K_ITEMS KIS

Line 1760: , OKC_K_LINES_B TL

1756: , OKC_K_HEADERS_ALL_B KH
1757: , OKC_K_LINES_B KL
1758: , OKC_STATUSES_B ST
1759: , OKS_INSTANCE_TEMP tmp
1760: , OKC_K_LINES_B TL
1761: ,OKC_K_ITEMS KIS
1762: Where tmp.idc = 'Y'
1763: And nvl(tmp.trm,'N') = 'N'
1764: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)

Line 1837: , OKC_K_LINES_B TL

1833: , OKC_K_HEADERS_ALL_B KH
1834: , OKC_K_LINES_v KL
1835: , OKC_STATUSES_B ST
1836: , OKS_INSTANCE_TEMP tmp
1837: , OKC_K_LINES_B TL
1838: ,OKC_K_ITEMS KIS
1839: , OKS_K_LINES_B OKL
1840: Where tmp.spl = 'Y'
1841: And nvl(tmp.trm,'N') = 'N'

Line 1918: , OKC_K_LINES_B TL

1914: , OKC_K_HEADERS_ALL_B KH
1915: , OKC_K_LINES_v KL
1916: , OKC_STATUSES_B ST
1917: , OKS_INSTANCE_TEMP tmp
1918: , OKC_K_LINES_B TL
1919: ,OKC_K_ITEMS KIS
1920: , OKS_K_LINES_B OKL
1921:
1922: Where tmp.rpl = 'Y'

Line 1996: , OKC_K_LINES_B KL

1992: , okl.toplvl_uom_code
1993: , okl.toplvl_price_qty
1994: From OKC_K_ITEMS KI
1995: , OKC_K_HEADERS_ALL_B KH
1996: , OKC_K_LINES_B KL
1997: , OKC_STATUSES_B ST
1998: , OKS_INSTANCE_TEMP tmp
1999: , OKC_K_LINES_B TL
2000: , OKC_K_ITEMS KIS

Line 1999: , OKC_K_LINES_B TL

1995: , OKC_K_HEADERS_ALL_B KH
1996: , OKC_K_LINES_B KL
1997: , OKC_STATUSES_B ST
1998: , OKS_INSTANCE_TEMP tmp
1999: , OKC_K_LINES_B TL
2000: , OKC_K_ITEMS KIS
2001: , OKS_K_LINES_B OKL
2002: Where tmp.upd = 'Y'
2003: And Nvl(tmp.trm,'N') = 'N'

Line 2910: from okc_k_lines_b sl,

2906: sl.end_date,
2907: (NVL(sl.price_negotiated,0)+NVL(ksl.tax_amount,0)) price_negotiated,
2908: sl.currency_code ,
2909: sl.date_terminated
2910: from okc_k_lines_b sl,
2911: okc_k_lines_b tl,
2912: okc_statuses_v sts,
2913: okc_k_items sli,
2914: okc_line_styles_v lst,

Line 2911: okc_k_lines_b tl,

2907: (NVL(sl.price_negotiated,0)+NVL(ksl.tax_amount,0)) price_negotiated,
2908: sl.currency_code ,
2909: sl.date_terminated
2910: from okc_k_lines_b sl,
2911: okc_k_lines_b tl,
2912: okc_statuses_v sts,
2913: okc_k_items sli,
2914: okc_line_styles_v lst,
2915: okc_line_styles_v tlst,

Line 3136: ,OKC_K_LINES_B KL

3132: Select CL.id
3133:
3134: From OKC_K_ITEMS KI
3135: ,OKC_K_HEADERS_ALL_B KH
3136: ,OKC_K_LINES_B KL
3137: ,OKC_K_LINES_B CL
3138: ,OKC_STATUSES_b ST
3139:
3140: Where

Line 3137: ,OKC_K_LINES_B CL

3133:
3134: From OKC_K_ITEMS KI
3135: ,OKC_K_HEADERS_ALL_B KH
3136: ,OKC_K_LINES_B KL
3137: ,OKC_K_LINES_B CL
3138: ,OKC_STATUSES_b ST
3139:
3140: Where
3141: KI.Jtot_Object1_code = 'OKX_CUSTPROD'

Line 3160: ,OKC_K_LINES_B CL

3156: cursor trm_trf_contracts IS
3157: Select CL.id
3158: From OKC_K_ITEMS KI
3159: ,OKC_K_HEADERS_ALL_B KH
3160: ,OKC_K_LINES_B CL
3161: ,OKC_STATUSES_b ST
3162: Where KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3163: AND KI.object1_id1 = to_char(p_instance_id )
3164: And KH.scs_code in ('WARRANTY','SERVICE','SUBSCRIPTION' )

Line 3189: ,OKC_K_LINES_B CL

3185: cursor trm_trf_contracts1 IS
3186: Select CL.id
3187: From OKC_K_ITEMS KI
3188: ,OKC_K_HEADERS_ALL_B KH
3189: ,OKC_K_LINES_B CL
3190: ,OKC_STATUSES_b ST
3191: ,oks_instance_k_dtls_temp temp
3192: Where KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3193: AND KI.object1_id1 = to_char(temp.instance_id)

Line 3222: ,OKC_K_LINES_B CL

3218: cursor trm_usages_contracts IS
3219: Select CL.id
3220: From OKC_K_ITEMS KI
3221: ,OKC_K_HEADERS_ALL_B KH
3222: ,OKC_K_LINES_B CL
3223: ,OKC_STATUSES_B ST
3224: ,csi_counter_associations CTRASC
3225:
3226: where KI.object1_id1 = to_char(CTRASC.COunter_id)

Line 3255: ,OKC_K_LINES_B CL

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

Line 3291: ,OKC_K_LINES_B KL

3287: cursor spl_upd_contracts IS
3288: Select CL.id
3289: From OKC_K_ITEMS KI
3290: ,OKC_K_HEADERS_ALL_B KH
3291: ,OKC_K_LINES_B KL
3292: ,OKC_K_LINES_B CL
3293: ,OKC_STATUSES_b ST
3294: Where
3295: KI.Jtot_Object1_code = 'OKX_CUSTPROD'

Line 3292: ,OKC_K_LINES_B CL

3288: Select CL.id
3289: From OKC_K_ITEMS KI
3290: ,OKC_K_HEADERS_ALL_B KH
3291: ,OKC_K_LINES_B KL
3292: ,OKC_K_LINES_B CL
3293: ,OKC_STATUSES_b ST
3294: Where
3295: KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3296: AND KI.object1_id1 = to_char(p_instance_id)

Line 3314: ,OKC_K_LINES_B CL

3310: cursor rin_contracts IS
3311: Select cl.id
3312: From OKC_K_ITEMS KI
3313: ,OKC_K_HEADERS_ALL_B KH
3314: ,OKC_K_LINES_B CL
3315: Where
3316: KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3317: AND KI.object1_id1 = to_char(p_instance_id)
3318: And KI.dnz_chr_id = KH.ID