APPS.CSC_ROUTING_UTL dependencies on MTL_SYSTEM_ITEMS

Line 817: -- MTL_SYSTEM_ITEMS table given an inventory item ID and an

813: -- Function : Get_Name_Of_Product
814: -- Usage : Used by the Routing module to get the product name from the
815: -- inventory item ID
816: -- Description : This function retrieves the product name from the
817: -- MTL_SYSTEM_ITEMS table given an inventory item ID and an
818: -- organization ID. The inventory organization ID is required
819: -- because the same item can be defined in more than one
820: -- organization.
821: -- Parameters :

Line 834: p_product_name mtl_system_items.description%type;

830: ( p_inventory_item_id IN NUMBER,
831: p_inventory_org_id IN NUMBER)
832: RETURN VARCHAR2 IS
833:
834: p_product_name mtl_system_items.description%type;
835:
836: --
837: -- get name given an inventory item ID and a inventory organization ID
838: --

Line 841: FROM mtl_system_items

837: -- get name given an inventory item ID and a inventory organization ID
838: --
839: CURSOR c_product_name (invid NUMBER, orgid NUMBER) IS
840: SELECT description
841: FROM mtl_system_items
842: WHERE inventory_item_id = invid AND
843: organization_id = orgid;
844: BEGIN
845: