APPS.OKL_COPY_CONTRACT_PVT dependencies on MTL_SYSTEM_ITEMS

Line 11223: -- Query from mtl_system_items

11219: SELECT id INTO l_34_id
11220: FROM okc_k_lines_b
11221: WHERE cle_id = l_curr_id
11222: AND lse_id = 34;
11223: -- Query from mtl_system_items
11224: SELECT a.asset_category_id
11225: INTO l_asset_category_id
11226: FROM mtl_system_items a,
11227: okc_k_items b

Line 11226: FROM mtl_system_items a,

11222: AND lse_id = 34;
11223: -- Query from mtl_system_items
11224: SELECT a.asset_category_id
11225: INTO l_asset_category_id
11226: FROM mtl_system_items a,
11227: okc_k_items b
11228: WHERE a.inventory_item_id = TO_NUMBER(b.object1_id1)
11229: AND a.organization_id = TO_NUMBER(b.object1_id2)
11230: AND b.cle_id = l_34_id;