APPS.AHL_LTP_MTL_REQ_PVT dependencies on MTL_SYSTEM_ITEMS

Line 411: select primary_uom_code from mtl_system_items

407: p_source_uom_code IN VARCHAR2,
408: p_quantity IN NUMBER) RETURN NUMBER IS
409:
410: CURSOR get_primary_uom_csr IS
411: select primary_uom_code from mtl_system_items
412: where inventory_item_id = p_inventory_item_id;
413:
414: l_primary_uom VARCHAR2(10);
415: l_converted_qty NUMBER;

Line 476: select primary_uom_code from mtl_system_items

472: p_inventory_item_id IN NUMBER,
473: p_inventory_org_id IN NUMBER
474: ) RETURN VARCHAR2 IS
475: CURSOR get_primary_uom_csr IS
476: select primary_uom_code from mtl_system_items
477: where inventory_item_id = p_inventory_item_id and
478: organization_id = p_inventory_org_id;
479:
480: l_primary_uom VARCHAR2(10);