453: CURSOR c_item_info (c_inventory_item_id NUMBER ,
454: c_organization_id NUMBER )
455: IS
456: SELECT item.concatenated_segments item_name
457: FROM MTL_SYSTEM_ITEMS_KFV item
458: WHERE item.organization_id = c_organization_id
459: AND item.inventory_item_id = c_inventory_item_id ;
460:
461:
458: WHERE item.organization_id = c_organization_id
459: AND item.inventory_item_id = c_inventory_item_id ;
460:
461:
462: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
463:
464:
465: BEGIN
466:
1582: l_current_column_index NUMBER;
1583:
1584: l_inventory_item_id NUMBER ;
1585: l_organization_id NUMBER ;
1586: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1587: l_item_desc MTL_SYSTEM_ITEMS_KFV.DESCRIPTION%TYPE;
1588: l_out_inventory_item_id NUMBER ;
1589: l_out_organization_id NUMBER ;
1590: l_process_control VARCHAR2(30) ;
1583:
1584: l_inventory_item_id NUMBER ;
1585: l_organization_id NUMBER ;
1586: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1587: l_item_desc MTL_SYSTEM_ITEMS_KFV.DESCRIPTION%TYPE;
1588: l_out_inventory_item_id NUMBER ;
1589: l_out_organization_id NUMBER ;
1590: l_process_control VARCHAR2(30) ;
1591: l_process_item NUMBER ;