698: p_org_id VARCHAR2,
699: p_item_no OUT NOCOPY VARCHAR2) IS
700: CURSOR cur_get_item_no IS
701: SELECT concatenated_segments
702: FROM mtl_system_items_kfv
703: WHERE inventory_item_Id = p_item_id
704: AND ORGANIZATION_ID = p_org_id;
705: BEGIN
706: OPEN cur_get_item_no;
711: PROCEDURE get_item_number1(p_item_id VARCHAR2,
712: p_item_no OUT NOCOPY VARCHAR2) IS
713: CURSOR cur_get_item_no IS
714: SELECT distinct concatenated_segments
715: FROM mtl_system_items_kfv
716: WHERE inventory_item_Id = p_item_id ;
717: BEGIN
718: OPEN cur_get_item_no;
719: FETCH cur_get_item_no INTO p_item_no;
724: p_org_id VARCHAR2,
725: p_item_desc OUT NOCOPY VARCHAR2) IS
726: CURSOR cur_get_item_desc IS
727: SELECT description
728: FROM mtl_system_items_kfv
729: WHERE inventory_item_Id = p_item_id
730: AND ORGANIZATION_ID = p_org_id;
731: BEGIN
732: OPEN cur_get_item_desc;
763: p_org_id VARCHAR2,
764: p_item_uom OUT NOCOPY VARCHAR2) IS
765: CURSOR cur_item_uom IS
766: SELECT primary_uom_code
767: FROM mtl_system_items
768: WHERE inventory_item_Id = p_item_id
769: AND ORGANIZATION_ID = p_org_id;
770: BEGIN
771: OPEN cur_item_uom;
873: AND TEST_ID = p_test_id;
874:
875: CURSOR cur_item_uom_cur IS
876: SELECT primary_uom_code
877: FROM mtl_system_items
878: WHERE inventory_item_Id = p_item_id
879: AND ORGANIZATION_ID = p_organization_id;
880:
881: l_uom_conv VARCHAR2(10) := NULL;