APPS.RCV_AVAILABILITY dependencies on MTL_UNITS_OF_MEASURE

Line 136: p_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE

132: l_return_status VARCHAR2(100);
133: --
134:
135: CURSOR get_uom_code(
136: p_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE
137: ) IS
138: SELECT uom_code
139: FROM mtl_units_of_measure
140: WHERE unit_of_measure = p_unit_of_measure;

Line 139: FROM mtl_units_of_measure

135: CURSOR get_uom_code(
136: p_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE
137: ) IS
138: SELECT uom_code
139: FROM mtl_units_of_measure
140: WHERE unit_of_measure = p_unit_of_measure;
141:
142: /*
143: The following four cursors: get_req_order, get_oe_order,

Line 164: mtl_units_of_measure uom,

160: oel.inventory_item_id item_id,
161: uom.unit_of_measure,
162: si.primary_unit_of_measure
163: FROM oe_order_lines_all oel,
164: mtl_units_of_measure uom,
165: mtl_system_items si
166: WHERE line_id = p_supply_demand_line_id
167: AND order_quantity_uom = uom_code
168: AND si.inventory_item_id(+) = oel.inventory_item_id;