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_QA_DATA_INTEGRITY dependencies on OKC_K_ITEMS

Line 1061: OKC_K_ITEMS cim,

1057: SELECT chdr.contract_number
1058: , cle.id
1059: , chdr.contract_number_modifier
1060: FROM okc_k_headers_all_b chdr,
1061: OKC_K_ITEMS cim,
1062: OKC_LINE_STYLES_V lse,
1063: OKC_K_LINES_B cle,
1064: OKC_STATUSES_B sts
1065: WHERE chdr.id = cle.dnz_chr_id

Line 1270: FROM OKC_K_ITEMS cim,

1266: , cle.end_date
1267: , cim.jtot_object1_code
1268: , cim.object1_id1
1269: , cim.object1_id2
1270: FROM OKC_K_ITEMS cim,
1271: OKC_LINE_STYLES_B lse,
1272: OKC_K_LINES_V cle
1273: WHERE cim.cle_id = cle.id
1274: and lse.id = cle.lse_id

Line 1293: FROM OKC_K_ITEMS cim,

1289: , cim.jtot_object1_code
1290: , cim.object1_id1
1291: , cim.object1_id2
1292: , cle.date_terminated
1293: FROM OKC_K_ITEMS cim,
1294: OKC_LINE_STYLES_B lse,
1295: OKC_K_LINES_V cle
1296: WHERE cim.cle_id = cle.id
1297: AND lse.LTY_CODE IN

Line 1321: okc_k_items trgi,

1317: nvl(rtrim(srctl.line_number) || '.' || RTRIM(srcsl.line_number) ||', '|| RTRIM(srcst.name) ||' '|| RTRIM(srcsl.name), OKC_API.G_MISS_CHAR) src_name,
1318: srcsl.id srcsl_id
1319: FROM okc_k_headers_all_b trgh,
1320: okc_k_lines_v trgsl,
1321: okc_k_items trgi,
1322: okc_k_lines_b trgtl,
1323: okc_line_styles_v trgst,
1324: okc_k_lines_v srcsl,
1325: okc_k_items srci,

Line 1325: okc_k_items srci,

1321: okc_k_items trgi,
1322: okc_k_lines_b trgtl,
1323: okc_line_styles_v trgst,
1324: okc_k_lines_v srcsl,
1325: okc_k_items srci,
1326: okc_k_lines_b srctl,
1327: okc_line_styles_v srcst,
1328: okc_statuses_b sts
1329: WHERE srcsl.dnz_chr_id = cp_chr_id

Line 1623: FROM OKC_K_ITEMS cim,

1619: CURSOR l_cle_csr IS
1620: SELECT cle.id, lse.lty_code, cle.name, cle.lse_id,
1621: cle.start_date, cle.end_date,
1622: cim.jtot_object1_code, cim.object1_id1, cim.object1_id2
1623: FROM OKC_K_ITEMS cim,
1624: OKC_LINE_STYLES_B lse,
1625: OKC_K_LINES_V cle
1626: WHERE cim.cle_id = cle.id
1627: AND lse.id = cle.lse_id

Line 1638: FROM OKC_K_ITEMS cim,

1634: CURSOR l_cve_csr (p_cle_id NUMBER) IS
1635: SELECT cle.id, cle.PRICE_NEGOTIATED, cle.name, cle.lse_id,
1636: cle.start_date, cle.end_date, lse.lty_code,
1637: cim.jtot_object1_code, cim.object1_id1, cim.object1_id2
1638: FROM OKC_K_ITEMS cim,
1639: OKC_LINE_STYLES_B lse,
1640: OKC_K_LINES_V cle
1641: WHERE cim.cle_id = cle.id
1642: AND lse.LTY_CODE IN

Line 1733: FROM okc_k_items

1729: l_cvd_lvl_rec l_cvd_lvl_csr%ROWTYPE;
1730:
1731: CURSOR l_cvd_item_csr (line_id NUMBER) IS
1732: SELECT object1_id1
1733: FROM okc_k_items
1734: WHERE cle_id = line_id ;
1735: l_cvd_item_rec l_cvd_item_csr%ROWTYPE;
1736:
1737:

Line 2111: FROM OKC_K_ITEMS cim,

2107:
2108: CURSOR l_cle_csr IS
2109: /**
2110: SELECT cle.id, COUNT( * )
2111: FROM OKC_K_ITEMS cim,
2112: OKC_K_LINES_B cle
2113: WHERE cim.cle_id = cle.id
2114: AND cle.dnz_chr_id = p_chr_id
2115: AND cle.date_cancelled IS NULL --Changes [llc]

Line 2121: FROM okc_k_items

2117: HAVING COUNT( * ) > 1;
2118: **/
2119: --bug 5442886
2120: SELECT cle_id, count(*)
2121: FROM okc_k_items
2122: WHERE dnz_chr_id = p_chr_id
2123: GROUP BY cle_id
2124: HAVING COUNT(*) > 1;
2125:

Line 2194: FROM OKC_K_ITEMS_V

2190: ;
2191:
2192: CURSOR l_get_item_csr (p_cle_id NUMBER) IS
2193: SELECT id, uom_code
2194: FROM OKC_K_ITEMS_V
2195: WHERE dnz_chr_id = p_chr_id
2196: AND cle_id = p_cle_id;
2197: ***/
2198:

Line 2206: okc_k_items_v ri

2202: rlb.id sub_line_id, rlb.price_unit,
2203: ri.uom_code
2204: FROM okc_k_lines_b rla,
2205: okc_k_lines_b rlb,
2206: okc_k_items_v ri
2207: WHERE rla.dnz_chr_id = p_chr_id
2208: AND rla.lse_id IN (1,19)
2209: AND rla.date_cancelled IS NULL
2210: AND rlb.cle_id = rla.id

Line 2218: TYPE chr3_tbl_type IS TABLE OF okc_k_items.uom_code%TYPE INDEX BY BINARY_INTEGER;

2214: AND ri.cle_id = rlb.id
2215: AND (rlb.price_unit IS NULL OR ri.uom_code IS NULL);
2216:
2217: TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2218: TYPE chr3_tbl_type IS TABLE OF okc_k_items.uom_code%TYPE INDEX BY BINARY_INTEGER;
2219:
2220: l_sub_line_id_tbl num_tbl_type;
2221: l_price_unit_tbl num_tbl_type;
2222: l_uom_code_tbl chr3_tbl_type;

Line 2276: /* Get service item id for all the service lines from OKC_K_ITEMS_V */

2272: FROM okc_k_lines_b
2273: WHERE id = l_service_id;
2274:
2275:
2276: /*** Get service item id for all the service lines from OKC_K_ITEMS_V ***/
2277: CURSOR l_csr_get_service_item_id(p_cle_id IN NUMBER) IS
2278: SELECT object1_id1
2279: FROM okc_k_items_v
2280: WHERE cle_id = p_cle_id ;

Line 2279: FROM okc_k_items_v

2275:
2276: /*** Get service item id for all the service lines from OKC_K_ITEMS_V ***/
2277: CURSOR l_csr_get_service_item_id(p_cle_id IN NUMBER) IS
2278: SELECT object1_id1
2279: FROM okc_k_items_v
2280: WHERE cle_id = p_cle_id ;
2281:
2282:
2283: /*** Get all product lines and item lines for each service line ***/

Line 2292: * or product lines from OKC_K_ITEMS_V */

2288: AND lse_id IN (9, 25, 7); -- 7 added for bug#2430496
2289:
2290:
2291: /*** Get service item id or product item if for all the service lines
2292: *** or product lines from OKC_K_ITEMS_V ***/
2293: CURSOR l_csr_get_item_id(p_cle_id IN NUMBER) IS
2294: SELECT object1_id1
2295: FROM okc_k_items_v
2296: WHERE cle_id = p_cle_id ;

Line 2295: FROM okc_k_items_v

2291: /*** Get service item id or product item if for all the service lines
2292: *** or product lines from OKC_K_ITEMS_V ***/
2293: CURSOR l_csr_get_item_id(p_cle_id IN NUMBER) IS
2294: SELECT object1_id1
2295: FROM okc_k_items_v
2296: WHERE cle_id = p_cle_id ;
2297:
2298: CURSOR l_product_csr(p_cp_id NUMBER) IS
2299: SELECT inventory_item_id

Line 4353: FROM okc_k_items cim,

4349: CURSOR l_cle_csr IS
4350: SELECT cle.id, cle.lse_id, sts.ste_code sts_code,
4351: cle.start_date, cle.end_date, cle.date_terminated,
4352: cim.jtot_object1_code, cim.object1_id1, cim.object1_id2
4353: FROM okc_k_items cim,
4354: okc_k_lines_b cle,
4355: okc_statuses_b sts
4356: WHERE cle.dnz_chr_id = p_chr_id
4357: AND cle.cle_id IS NULL

Line 4398: FROM OKC_K_ITEMS cim,

4394: SELECT cle.id, cle.PRICE_NEGOTIATED, cle.lse_id, sts.ste_code sts_code,
4395: cle.start_date, cle.end_date, cle.date_terminated,
4396: cim.jtot_object1_code, cim.object1_id1,
4397: cim.object1_id2
4398: FROM OKC_K_ITEMS cim,
4399: OKC_K_LINES_B cle,
4400: OKC_STATUSES_B sts
4401: WHERE cim.cle_id = cle.id
4402: AND cle.cle_id = p_cle_id

Line 4411: FROM Okc_k_items

4407:
4408:
4409: CURSOR l_inv_csr(p_id NUMBER) IS
4410: SELECT object1_id1
4411: FROM Okc_k_items
4412: WHERE cle_id = p_id;
4413:
4414: CURSOR l_covitm_csr(p_inv_item NUMBER, p_org_id NUMBER) IS
4415: SELECT DECODE(ENABLED_FLAG, 'Y', 'A', 'I') status

Line 6326: /* Get service item id for all the service lines from OKC_K_ITEMS_V */

6322: AND id = l_service_id;
6323:
6324:
6325:
6326: /*** Get service item id for all the service lines from OKC_K_ITEMS_V ***/
6327: CURSOR l_csr_get_service_item_id(p_cle_id IN NUMBER) IS
6328: SELECT object1_id1
6329: FROM okc_k_items_v
6330: WHERE cle_id = p_cle_id ;

Line 6329: FROM okc_k_items_v

6325:
6326: /*** Get service item id for all the service lines from OKC_K_ITEMS_V ***/
6327: CURSOR l_csr_get_service_item_id(p_cle_id IN NUMBER) IS
6328: SELECT object1_id1
6329: FROM okc_k_items_v
6330: WHERE cle_id = p_cle_id ;
6331:
6332:
6333: /*** Get all product lines and item lines for each service line ***/

Line 6344: * or product lines from OKC_K_ITEMS_V */

6340: ;
6341:
6342:
6343: /*** Get service item id or product item if for all the service lines
6344: *** or product lines from OKC_K_ITEMS_V ***/
6345: -- For a covered item the inventory_item_id is
6346: -- stored inside of object1_id1
6347: -- For covered products the customer_product_id is stored inside of object1_id1
6348: CURSOR l_csr_get_item_id(p_cle_id IN NUMBER) IS

Line 6350: FROM okc_k_items_v

6346: -- stored inside of object1_id1
6347: -- For covered products the customer_product_id is stored inside of object1_id1
6348: CURSOR l_csr_get_item_id(p_cle_id IN NUMBER) IS
6349: SELECT object1_id1
6350: FROM okc_k_items_v
6351: WHERE cle_id = p_cle_id ;
6352:
6353: CURSOR l_product_csr(p_cp_id NUMBER) IS
6354: SELECT inventory_item_id

Line 7254: FROM okc_k_items a, oks_subscr_header_b b

7250: -- Checks if the item it's covering is a subscritpion item and then it gets
7251: -- the item instance
7252: CURSOR get_item_inst(subline_id NUMBER) IS
7253: SELECT a.object1_id1
7254: FROM okc_k_items a, oks_subscr_header_b b
7255: WHERE a.cle_id = subline_id
7256: AND b.instance_id = a.object1_id1;
7257:
7258:

Line 7442: FROM mtl_system_items a, okc_k_items b

7438:
7439:
7440: CURSOR get_shipable_flag(cleId NUMBER) IS
7441: SELECT SHIPPABLE_ITEM_FLAG
7442: FROM mtl_system_items a, okc_k_items b
7443: WHERE b.cle_id = cleId AND a.SHIPPABLE_ITEM_FLAG = 'Y'
7444: AND a.INVENTORY_ITEM_ID = b.object1_id1
7445: AND a.ORGANIZATION_ID = b.object1_id2;
7446:

Line 7556: FROM okc_k_items

7552: ;
7553:
7554: CURSOR Get_Item_Inst(l_cp_line_id NUMBER) IS
7555: SELECT object1_id1, number_of_items, uom_code
7556: FROM okc_k_items
7557: WHERE cle_id = l_cp_line_id;
7558:
7559: l_item_inst Get_Item_Inst%ROWTYPE;
7560:

Line 8225: FROM OKC_K_ITEMS oti,okc_k_lines_b okc,okc_k_lines_b subline

8221:
8222: CURSOR check_covd_qty(p_chr_id number)
8223: IS
8224: SELECT OKC.LINE_NUMBER line_number,subline.line_number sub_line_number
8225: FROM OKC_K_ITEMS oti,okc_k_lines_b okc,okc_k_lines_b subline
8226: WHERE okc.lse_id IN (1,20)
8227: AND oti.dnz_chr_id =p_chr_id
8228: AND okc.chr_id = subline.dnz_chr_id
8229: AND oti.NUMBER_of_items IS NULL