329: BEGIN
330: SELECT oi.item_id , oi.item_um2, oi.dualum_ind
331: INTO l_opm_item_id, l_item_um2, l_dualum_ind
332: FROM ic_item_mst oi,
333: mtl_system_items ai
334: WHERE ai.organization_id = x_ship_org_id
335: AND ai.inventory_item_id = x_item_id
336: AND ai.segment1 = oi.item_no;
337:
452: --Get opm attributes to derive secondary quantity.
453: SELECT oi.item_id , oi.item_um2, oi.dualum_ind
454: INTO l_opm_item_id, l_item_um2, l_dualum_ind
455: FROM ic_item_mst oi,
456: mtl_system_items ai
457: WHERE ai.organization_id = X_ship_org_id
458: AND ai.inventory_item_id = X_item_id
459: AND ai.segment1 = oi.item_no;
460: