2319: INTO l_prim_uom_code,
2320: l_item_id,
2321: l_to_organization_id
2322: FROM mtl_system_items_kfv msik,
2323: mtl_parameters mp
2324: WHERE mp.organization_id = l_rti_rec.to_organization_id
2325: AND msik.inventory_item_id = l_rti_rec.item_id
2326: AND mp.organization_id = msik.organization_id;
2327:
2332: INTO l_prim_uom_code,
2333: l_item_id,
2334: l_to_organization_id
2335: FROM mtl_system_items_kfv msik,
2336: mtl_parameters mp
2337: WHERE mp.organization_id = l_rti_rec.to_organization_id
2338: AND msik.concatenated_segments = l_rti_rec.item_num
2339: AND mp.organization_id = msik.organization_id;
2340: END IF; --IF (L_RTI_REC.ITEM_ID IS NOT NULL) THEN
2348: INTO l_prim_uom_code,
2349: l_item_id,
2350: l_to_organization_id
2351: FROM mtl_system_items_kfv msik,
2352: mtl_parameters mp
2353: WHERE mp.organization_code = l_rti_rec.to_organization_code
2354: AND msik.inventory_item_id = l_rti_rec.item_id
2355: AND mp.organization_id = msik.organization_id;
2356:
2361: INTO l_prim_uom_code,
2362: l_item_id,
2363: l_to_organization_id
2364: FROM mtl_system_items_kfv msik,
2365: mtl_parameters mp
2366: WHERE mp.organization_code = l_rti_rec.to_organization_code
2367: AND msik.concatenated_segments = l_rti_rec.item_num
2368: AND mp.organization_id = msik.organization_id;
2369: