APPS.QP_JAVA_ENGINE_CACHE_PVT dependencies on MTL_UOM_CONVERSIONS

Line 109: FROM mtl_uom_conversions

105: and qph.active_flag = 'Y';
106:
107: CURSOR uom_perm_csr IS
108: SELECT count(*)
109: FROM mtl_uom_conversions
110: WHERE (disable_date is null or disable_date > sysdate)
111: and inventory_item_id = 0;
112:
113: /*****************************************************************

Line 144: FROM mtl_uom_conversions

140: WHERE qlh.list_type_code = 'PML';
141:
142: CURSOR uom_cache_key_cnt_csr IS
143: SELECT count(*)
144: FROM mtl_uom_conversions
145: WHERE (disable_date IS null or disable_date > sysdate)
146: and inventory_item_id <> 0;
147:
148: CURSOR currency_cache_key_cnt_csr IS

Line 188: FROM mtl_uom_conversions

184:
185: CURSOR uom_cache_key_csr IS
186: SELECT
187: inventory_item_id
188: FROM mtl_uom_conversions
189: WHERE (disable_date IS null or disable_date > sysdate)
190: and inventory_item_id <> 0
191: and ROWNUM < 200;
192:

Line 250: FROM mtl_uom_conversions

246: );
247:
248: CURSOR uom_csr (p_cache_key varchar2) IS
249: SELECT count(*)
250: FROM mtl_uom_conversions
251: WHERE (disable_date is null or disable_date > sysdate) and inventory_item_id = p_cache_key;
252:
253: CURSOR uom_class_csr (p_cache_key varchar2) IS
254: SELECT count(*)