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_ITEMS

Line 33: ,okc_k_items item

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
37: And item.object1_id1 = to_char(p_item_id)

Line 426: ,okc_k_items item

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
430: And item.object1_id1 = to_char(p_item_id)

Line 450: ,okc_k_items item

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)
454: And item.object1_id1 = to_char(p_cp_id)

Line 1239: From OKC_K_ITEMS KI

1235: ,ksl.price_uom tl_price_uom
1236: ,ks.price_uom hdr_price_uom
1237: ,okl.toplvl_uom_code
1238: ,okl.toplvl_price_qty
1239: From OKC_K_ITEMS KI
1240: ,OKC_K_HEADERS_ALL_B KH
1241: ,OKS_K_HEADERS_B KS
1242: ,OKC_K_LINES_V KL
1243: ,OKS_K_LINES_B OKL

Line 1248: ,OKC_K_ITEMS KIS

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:
1251: Where tmp.trf = 'Y'
1252: And nvl(tmp.trm,'N') = 'N'

Line 1347: From OKC_K_ITEMS KI

1343: , Null
1344: , Null
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

Line 1353: ,OKC_K_ITEMS KIS

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)
1357: And KI.Jtot_Object1_code = 'OKX_CUSTPROD'

Line 1450: From OKC_K_ITEMS KI

1446: , Null
1447: , Null
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

Line 1457: ,OKC_K_ITEMS KIS

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
1458: ,OKC_K_PARTY_ROLES_B PARTY
1459: Where tmp.trm = 'Y'
1460: And KI.object1_id1 = TO_CHAR (CTRASC.Counter_id)
1461: And ctrasc.source_object_id = tmp.old_customer_product_id

Line 1550: From OKC_K_ITEMS KI

1546: , tmp.order_line_id
1547: , Null
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

Line 1556: ,OKC_K_ITEMS KIS

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'
1560: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)

Line 1652: From OKC_K_ITEMS KI

1648: , tmp.order_line_id
1649: , null
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

Line 1659: ,OKC_K_ITEMS KIS

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
1660: ,OKC_K_PARTY_ROLES_B PARTY
1661:
1662: Where tmp.ret = 'Y'
1663: And KI.object1_id1 = to_char(CTRASC.Counter_id)

Line 1755: From OKC_K_ITEMS KI

1751: , tmp.order_line_id
1752: , null
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

Line 1761: ,OKC_K_ITEMS KIS

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)
1765: And KI.Jtot_Object1_code = 'OKX_CUSTPROD'

Line 1832: From OKC_K_ITEMS KI

1828: , tmp.order_line_id
1829: , okl.price_uom
1830: , okl.toplvl_uom_code
1831: , okl.toplvl_price_qty
1832: From OKC_K_ITEMS KI
1833: , OKC_K_HEADERS_ALL_B KH
1834: , OKC_K_LINES_v KL
1835: , OKC_STATUSES_B ST
1836: , OKS_INSTANCE_TEMP tmp

Line 1838: ,OKC_K_ITEMS KIS

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'
1842: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)

Line 1913: From OKC_K_ITEMS KI

1909: , tmp.order_line_id
1910: , okl.price_uom
1911: , okl.toplvl_uom_code
1912: , okl.toplvl_price_qty
1913: From OKC_K_ITEMS KI
1914: , OKC_K_HEADERS_ALL_B KH
1915: , OKC_K_LINES_v KL
1916: , OKC_STATUSES_B ST
1917: , OKS_INSTANCE_TEMP tmp

Line 1919: ,OKC_K_ITEMS KIS

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'
1923: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)

Line 1994: From OKC_K_ITEMS KI

1990: , tmp.order_line_id
1991: , okl.price_uom
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

Line 2000: , OKC_K_ITEMS KIS

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'
2004: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)

Line 2913: okc_k_items sli,

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,
2916: oks_k_lines_b ksl
2917: where sl.id = p_covered_line_id

Line 3134: From OKC_K_ITEMS KI

3130: Cursor idc_contracts IS
3131:
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

Line 3158: From OKC_K_ITEMS KI

3154: idc_contracts_REC idc_contracts%rowtype;
3155:
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'

Line 3187: From OKC_K_ITEMS KI

3183: and object_cle_id=cl.id)));
3184:
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

Line 3220: From OKC_K_ITEMS KI

3216:
3217:
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

Line 3253: From OKC_K_ITEMS KI

3249: and object_cle_id=cl.id)));
3250:
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

Line 3289: From OKC_K_ITEMS KI

3285: trm_usages_contracts_rec trm_usages_contracts%rowtype;
3286:
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

Line 3312: From OKC_K_ITEMS KI

3308:
3309: spl_upd_contracts_rec spl_upd_contracts%rowtype;
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'