31: WHERE FORMULA_id = vFormula_id;
32:
33: Cursor get_item_info(vItem_id NUMBER) IS
34: SELECT concatenated_segments, primary_uom_code
35: FROM mtl_system_items_kfv
36: WHERE inventory_item_id = vItem_id;
37:
38:
39: /* =============================================================== */
102: ) IS
103:
104: Cursor get_item_info1(vItem_id NUMBER) IS
105: SELECT inventory_item_id, primary_uom_code
106: FROM mtl_system_items_kfv
107: WHERE inventory_item_id = vItem_id;
108:
109: Cursor get_item_info2(vItem_no VARCHAR2) IS
110: SELECT inventory_item_id, primary_uom_code
107: WHERE inventory_item_id = vItem_id;
108:
109: Cursor get_item_info2(vItem_no VARCHAR2) IS
110: SELECT inventory_item_id, primary_uom_code
111: FROM mtl_system_items_kfv
112: WHERE concatenated_segments = vItem_no;
113:
114: Cursor get_item_orgn(vOrgn_id NUMBER) IS
115: SELECT organization_code