APPS.RCV_AVAILABILITY dependencies on MTL_UNITS_OF_MEASURE

Line 112: p_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE

108: x_rcv_quantity NUMBER;
109: x_rcv_order_quantity NUMBER;
110:
111: CURSOR get_uom_code(
112: p_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE
113: ) IS
114: SELECT uom_code
115: FROM mtl_units_of_measure
116: WHERE unit_of_measure = p_unit_of_measure;

Line 115: FROM mtl_units_of_measure

111: CURSOR get_uom_code(
112: p_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE
113: ) IS
114: SELECT uom_code
115: FROM mtl_units_of_measure
116: WHERE unit_of_measure = p_unit_of_measure;
117:
118: /*
119: The following four cursors: get_req_order, get_oe_order,

Line 140: mtl_units_of_measure uom,

136: oel.inventory_item_id item_id,
137: uom.unit_of_measure,
138: si.primary_unit_of_measure
139: FROM oe_order_lines_all oel,
140: mtl_units_of_measure uom,
141: mtl_system_items si
142: WHERE line_id = p_supply_demand_line_id
143: AND order_quantity_uom = uom_code
144: AND si.inventory_item_id(+) = oel.inventory_item_id;