APPS.AHL_OSP_ORDERS_PVT dependencies on MTL_UNITS_OF_MEASURE_VL

Line 2638: SELECT 'x' from mtl_units_of_measure_vl

2634: WHERE inventory_item_id = p_service_item_id
2635: AND uom_code = p_service_item_uom_code
2636: AND inventory_org_id = p_org_id;
2637: CURSOR val_uom_code_csr(p_service_item_uom_code IN VARCHAR2) IS
2638: SELECT 'x' from mtl_units_of_measure_vl
2639: WHERE uom_code = p_service_item_uom_code;
2640: l_exist VARCHAR2(1);
2641: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.validate_service_item_uom';
2642: BEGIN

Line 5459: mtl_units_of_measure_vl uom

5455: from po_line_locations_all
5456: where po_line_id = pol.po_line_id
5457: and po_header_id = pol.po_header_id) need_by_date
5458: FROM po_lines_all pol,
5459: mtl_units_of_measure_vl uom
5460: WHERE pol.po_line_id = c_po_line_id
5461: AND uom.unit_of_measure = pol.unit_meas_lookup_code;
5462: -- jaramana January 10, 2008 Ends
5463: --yazhou 22-Aug-2006 ends