APPS.RCV_AVAILABILITY dependencies on MTL_SYSTEM_ITEMS

Line 154: mtl_system_items si

150: rl.item_id,
151: rl.unit_meas_lookup_code unit_of_measure,
152: si.primary_unit_of_measure
153: FROM po_requisition_lines_all rl,
154: mtl_system_items si
155: WHERE rl.requisition_line_id = p_supply_demand_line_id
156: AND si.inventory_item_id(+) = rl.item_id;
157:
158: CURSOR get_oe_order IS

Line 165: mtl_system_items si

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;
169:

Line 214: mtl_system_items si

210: si.primary_unit_of_measure primary_unit_of_measure
211: FROM po_line_locations_all pll,
212: po_lines_all pol,
213: po_distributions_all pod,
214: mtl_system_items si
215: WHERE pll.line_location_id = p_supply_demand_line_id
216: AND pll.po_line_id = pol.po_line_id
217: AND pol.item_id IS NOT NULL
218: AND si.inventory_item_id = pol.item_id