1334: AND a.id = c.cle_id;
1335:
1336: l_inv_id NUMBER;
1337:
1338: l_uom_code mtl_system_items.primary_uom_code%TYPE;
1339:
1340: CURSOR get_uom_code ( p_inv_item_id NUMBER ) IS
1341: SELECT primary_uom_code
1342: FROM mtl_system_items
1338: l_uom_code mtl_system_items.primary_uom_code%TYPE;
1339:
1340: CURSOR get_uom_code ( p_inv_item_id NUMBER ) IS
1341: SELECT primary_uom_code
1342: FROM mtl_system_items
1343: WHERE inventory_item_id = p_inv_item_id;
1344:
1345: l_temp_sold_fee VARCHAR2(1);
1346: