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 1207: FROM OKC_K_ITEMS cim,

1203: , cle.end_date
1204: , cim.jtot_object1_code
1205: , cim.object1_id1
1206: , cim.object1_id2
1207: FROM OKC_K_ITEMS cim,
1208: OKC_LINE_STYLES_B lse,
1209: OKC_K_LINES_V cle
1210: WHERE cim.cle_id = cle.id
1211: and lse.id = cle.lse_id

Line 1230: FROM OKC_K_ITEMS cim,

1226: , cim.jtot_object1_code
1227: , cim.object1_id1
1228: , cim.object1_id2
1229: , cle.date_terminated
1230: FROM OKC_K_ITEMS cim,
1231: OKC_LINE_STYLES_B lse,
1232: OKC_K_LINES_V cle
1233: WHERE cim.cle_id = cle.id
1234: AND lse.LTY_CODE IN

Line 1258: okc_k_items trgi,

1254: nvl(rtrim(srctl.line_number) || '.' || RTRIM(srcsl.line_number) ||', '|| RTRIM(srcst.name) ||' '|| RTRIM(srcsl.name), OKC_API.G_MISS_CHAR) src_name,
1255: srcsl.id srcsl_id
1256: FROM okc_k_headers_all_b trgh,
1257: okc_k_lines_v trgsl,
1258: okc_k_items trgi,
1259: okc_k_lines_b trgtl,
1260: okc_line_styles_v trgst,
1261: okc_k_lines_v srcsl,
1262: okc_k_items srci,

Line 1262: okc_k_items srci,

1258: okc_k_items trgi,
1259: okc_k_lines_b trgtl,
1260: okc_line_styles_v trgst,
1261: okc_k_lines_v srcsl,
1262: okc_k_items srci,
1263: okc_k_lines_b srctl,
1264: okc_line_styles_v srcst,
1265: okc_statuses_b sts
1266: WHERE srcsl.dnz_chr_id = cp_chr_id

Line 1554: FROM OKC_K_ITEMS cim,

1550: CURSOR l_cle_csr IS
1551: SELECT cle.id, lse.lty_code, cle.name, cle.lse_id,
1552: cle.start_date, cle.end_date,
1553: cim.jtot_object1_code, cim.object1_id1, cim.object1_id2
1554: FROM OKC_K_ITEMS cim,
1555: OKC_LINE_STYLES_B lse,
1556: OKC_K_LINES_V cle
1557: WHERE cim.cle_id = cle.id
1558: AND lse.id = cle.lse_id

Line 1569: FROM OKC_K_ITEMS cim,

1565: CURSOR l_cve_csr (p_cle_id NUMBER) IS
1566: SELECT cle.id, cle.PRICE_NEGOTIATED, cle.name, cle.lse_id,
1567: cle.start_date, cle.end_date, lse.lty_code,
1568: cim.jtot_object1_code, cim.object1_id1, cim.object1_id2
1569: FROM OKC_K_ITEMS cim,
1570: OKC_LINE_STYLES_B lse,
1571: OKC_K_LINES_V cle
1572: WHERE cim.cle_id = cle.id
1573: AND lse.LTY_CODE IN

Line 1664: FROM okc_k_items

1660: l_cvd_lvl_rec l_cvd_lvl_csr%ROWTYPE;
1661:
1662: CURSOR l_cvd_item_csr (line_id NUMBER) IS
1663: SELECT object1_id1
1664: FROM okc_k_items
1665: WHERE cle_id = line_id ;
1666: l_cvd_item_rec l_cvd_item_csr%ROWTYPE;
1667:
1668:

Line 2042: FROM OKC_K_ITEMS cim,

2038:
2039: CURSOR l_cle_csr IS
2040: /**
2041: SELECT cle.id, COUNT( * )
2042: FROM OKC_K_ITEMS cim,
2043: OKC_K_LINES_B cle
2044: WHERE cim.cle_id = cle.id
2045: AND cle.dnz_chr_id = p_chr_id
2046: AND cle.date_cancelled IS NULL --Changes [llc]

Line 2052: FROM okc_k_items

2048: HAVING COUNT( * ) > 1;
2049: **/
2050: --bug 5442886
2051: SELECT cle_id, count(*)
2052: FROM okc_k_items
2053: WHERE dnz_chr_id = p_chr_id
2054: GROUP BY cle_id
2055: HAVING COUNT(*) > 1;
2056:

Line 2125: FROM OKC_K_ITEMS_V

2121: ;
2122:
2123: CURSOR l_get_item_csr (p_cle_id NUMBER) IS
2124: SELECT id, uom_code
2125: FROM OKC_K_ITEMS_V
2126: WHERE dnz_chr_id = p_chr_id
2127: AND cle_id = p_cle_id;
2128: ***/
2129:

Line 2137: okc_k_items_v ri

2133: rlb.id sub_line_id, rlb.price_unit,
2134: ri.uom_code
2135: FROM okc_k_lines_b rla,
2136: okc_k_lines_b rlb,
2137: okc_k_items_v ri
2138: WHERE rla.dnz_chr_id = p_chr_id
2139: AND rla.lse_id IN (1,19)
2140: AND rla.date_cancelled IS NULL
2141: AND rlb.cle_id = rla.id

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

2145: AND ri.cle_id = rlb.id
2146: AND (rlb.price_unit IS NULL OR ri.uom_code IS NULL);
2147:
2148: TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2149: TYPE chr3_tbl_type IS TABLE OF okc_k_items.uom_code%TYPE INDEX BY BINARY_INTEGER;
2150:
2151: l_sub_line_id_tbl num_tbl_type;
2152: l_price_unit_tbl num_tbl_type;
2153: l_uom_code_tbl chr3_tbl_type;

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

2203: FROM okc_k_lines_b
2204: WHERE id = l_service_id;
2205:
2206:
2207: /*** Get service item id for all the service lines from OKC_K_ITEMS_V ***/
2208: CURSOR l_csr_get_service_item_id(p_cle_id IN NUMBER) IS
2209: SELECT object1_id1
2210: FROM okc_k_items_v
2211: WHERE cle_id = p_cle_id ;

Line 2210: FROM okc_k_items_v

2206:
2207: /*** Get service item id for all the service lines from OKC_K_ITEMS_V ***/
2208: CURSOR l_csr_get_service_item_id(p_cle_id IN NUMBER) IS
2209: SELECT object1_id1
2210: FROM okc_k_items_v
2211: WHERE cle_id = p_cle_id ;
2212:
2213:
2214: /*** Get all product lines and item lines for each service line ***/

Line 2223: * or product lines from OKC_K_ITEMS_V */

2219: AND lse_id IN (9, 25, 7); -- 7 added for bug#2430496
2220:
2221:
2222: /*** Get service item id or product item if for all the service lines
2223: *** or product lines from OKC_K_ITEMS_V ***/
2224: CURSOR l_csr_get_item_id(p_cle_id IN NUMBER) IS
2225: SELECT object1_id1
2226: FROM okc_k_items_v
2227: WHERE cle_id = p_cle_id ;

Line 2226: FROM okc_k_items_v

2222: /*** Get service item id or product item if for all the service lines
2223: *** or product lines from OKC_K_ITEMS_V ***/
2224: CURSOR l_csr_get_item_id(p_cle_id IN NUMBER) IS
2225: SELECT object1_id1
2226: FROM okc_k_items_v
2227: WHERE cle_id = p_cle_id ;
2228:
2229: CURSOR l_product_csr(p_cp_id NUMBER) IS
2230: SELECT inventory_item_id

Line 4206: FROM okc_k_items cim,

4202: CURSOR l_cle_csr IS
4203: SELECT cle.id, cle.lse_id, sts.ste_code sts_code,
4204: cle.start_date, cle.end_date, cle.date_terminated,
4205: cim.jtot_object1_code, cim.object1_id1, cim.object1_id2
4206: FROM okc_k_items cim,
4207: okc_k_lines_b cle,
4208: okc_statuses_b sts
4209: WHERE cle.dnz_chr_id = p_chr_id
4210: AND cle.cle_id IS NULL

Line 4251: FROM OKC_K_ITEMS cim,

4247: SELECT cle.id, cle.PRICE_NEGOTIATED, cle.lse_id, sts.ste_code sts_code,
4248: cle.start_date, cle.end_date, cle.date_terminated,
4249: cim.jtot_object1_code, cim.object1_id1,
4250: cim.object1_id2
4251: FROM OKC_K_ITEMS cim,
4252: OKC_K_LINES_B cle,
4253: OKC_STATUSES_B sts
4254: WHERE cim.cle_id = cle.id
4255: AND cle.cle_id = p_cle_id

Line 4264: FROM Okc_k_items

4260:
4261:
4262: CURSOR l_inv_csr(p_id NUMBER) IS
4263: SELECT object1_id1
4264: FROM Okc_k_items
4265: WHERE cle_id = p_id;
4266:
4267: CURSOR l_covitm_csr(p_inv_item NUMBER, p_org_id NUMBER) IS
4268: SELECT DECODE(ENABLED_FLAG, 'Y', 'A', 'I') status

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

6175: AND id = l_service_id;
6176:
6177:
6178:
6179: /*** Get service item id for all the service lines from OKC_K_ITEMS_V ***/
6180: CURSOR l_csr_get_service_item_id(p_cle_id IN NUMBER) IS
6181: SELECT object1_id1
6182: FROM okc_k_items_v
6183: WHERE cle_id = p_cle_id ;

Line 6182: FROM okc_k_items_v

6178:
6179: /*** Get service item id for all the service lines from OKC_K_ITEMS_V ***/
6180: CURSOR l_csr_get_service_item_id(p_cle_id IN NUMBER) IS
6181: SELECT object1_id1
6182: FROM okc_k_items_v
6183: WHERE cle_id = p_cle_id ;
6184:
6185:
6186: /*** Get all product lines and item lines for each service line ***/

Line 6197: * or product lines from OKC_K_ITEMS_V */

6193: ;
6194:
6195:
6196: /*** Get service item id or product item if for all the service lines
6197: *** or product lines from OKC_K_ITEMS_V ***/
6198: -- For a covered item the inventory_item_id is
6199: -- stored inside of object1_id1
6200: -- For covered products the customer_product_id is stored inside of object1_id1
6201: CURSOR l_csr_get_item_id(p_cle_id IN NUMBER) IS

Line 6203: FROM okc_k_items_v

6199: -- stored inside of object1_id1
6200: -- For covered products the customer_product_id is stored inside of object1_id1
6201: CURSOR l_csr_get_item_id(p_cle_id IN NUMBER) IS
6202: SELECT object1_id1
6203: FROM okc_k_items_v
6204: WHERE cle_id = p_cle_id ;
6205:
6206: CURSOR l_product_csr(p_cp_id NUMBER) IS
6207: SELECT inventory_item_id

Line 7105: FROM okc_k_items a, oks_subscr_header_b b

7101: -- Checks if the item it's covering is a subscritpion item and then it gets
7102: -- the item instance
7103: CURSOR get_item_inst(subline_id NUMBER) IS
7104: SELECT a.object1_id1
7105: FROM okc_k_items a, oks_subscr_header_b b
7106: WHERE a.cle_id = subline_id
7107: AND b.instance_id = a.object1_id1;
7108:
7109:

Line 7293: FROM mtl_system_items a, okc_k_items b

7289:
7290:
7291: CURSOR get_shipable_flag(cleId NUMBER) IS
7292: SELECT SHIPPABLE_ITEM_FLAG
7293: FROM mtl_system_items a, okc_k_items b
7294: WHERE b.cle_id = cleId AND a.SHIPPABLE_ITEM_FLAG = 'Y'
7295: AND a.INVENTORY_ITEM_ID = b.object1_id1
7296: AND a.ORGANIZATION_ID = b.object1_id2;
7297:

Line 7407: FROM okc_k_items

7403: ;
7404:
7405: CURSOR Get_Item_Inst(l_cp_line_id NUMBER) IS
7406: SELECT object1_id1, number_of_items, uom_code
7407: FROM okc_k_items
7408: WHERE cle_id = l_cp_line_id;
7409:
7410: l_item_inst Get_Item_Inst%ROWTYPE;
7411: