APPS.RCV_AVAILABILITY dependencies on MTL_SYSTEM_ITEMS

Line 130: mtl_system_items si

126: rl.item_id,
127: rl.unit_meas_lookup_code unit_of_measure,
128: si.primary_unit_of_measure
129: FROM po_requisition_lines_all rl,
130: mtl_system_items si
131: WHERE rl.requisition_line_id = p_supply_demand_line_id
132: AND si.inventory_item_id(+) = rl.item_id;
133:
134: CURSOR get_oe_order IS

Line 141: mtl_system_items si

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

Line 170: mtl_system_items si

166: si.primary_unit_of_measure
167: FROM po_line_locations_all pll,
168: po_lines_all pol,
169: po_distributions_all pod,
170: mtl_system_items si
171: WHERE pll.line_location_id = p_supply_demand_line_id
172: AND pll.po_line_id = pol.po_line_id
173: AND si.inventory_item_id(+) = pol.item_id
174: AND nvl(si.organization_id,pll.ship_to_organization_id) =