APPS.AHL_OSP_ORDERS_PVT dependencies on MTL_UNITS_OF_MEASURE_VL

Line 2617: SELECT 'x' from mtl_units_of_measure_vl

2613: WHERE inventory_item_id = p_service_item_id
2614: AND uom_code = p_service_item_uom_code
2615: AND inventory_org_id = p_org_id;
2616: CURSOR val_uom_code_csr(p_service_item_uom_code IN VARCHAR2) IS
2617: SELECT 'x' from mtl_units_of_measure_vl
2618: WHERE uom_code = p_service_item_uom_code;
2619: l_exist VARCHAR2(1);
2620: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.validate_service_item_uom';
2621: BEGIN

Line 5109: mtl_units_of_measure_vl uom

5105: from po_line_locations_all
5106: where po_line_id = pol.po_line_id
5107: and po_header_id = pol.po_header_id) need_by_date
5108: FROM po_lines_all pol,
5109: mtl_units_of_measure_vl uom
5110: WHERE pol.po_line_id = c_po_line_id
5111: AND uom.unit_of_measure = pol.unit_meas_lookup_code;
5112: -- jaramana January 10, 2008 Ends
5113: --yazhou 22-Aug-2006 ends