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_V

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 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 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