[Home] [Help]
464:
465: -- Cursor to fetch the items name, associated to an agreement.
466: CURSOR get_item_name(p_org_id IN NUMBER, p_item_id IN NUMBER) IS
467: SELECT description
468: FROM MTL_SYSTEM_ITEMS_VL
469: WHERE organization_id = p_org_id
470: AND inventory_item_id = p_item_id;
471:
472: -- Cursor to fetch the item categories name, associated to an agreement.