APPS.RCV_AVAILABILITY dependencies on OE_ORDER_LINES_ALL

Line 139: FROM oe_order_lines_all oel,

135: SELECT oel.ordered_quantity quantity,
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

Line 928: FROM oe_order_lines_all

924: * Change all the table to base tables.
925: */
926: SELECT 'Y'
927: INTO x_valid_status
928: FROM oe_order_lines_all
929: WHERE open_flag = 'Y'
930: AND line_category_code = l_lookup_code
931: AND ( p_organization_id IS NULL
932: OR p_organization_id = deliver_to_org_id)