DBA Data[Home] [Help]

APPS.RCV_AVAILABILITY dependencies on OE_ORDER_LINES_ALL

Line 163: FROM oe_order_lines_all oel,

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

Line 1022: FROM oe_order_lines_all

1018: * Change all the table to base tables.
1019: */
1020: SELECT 'Y'
1021: INTO x_valid_status
1022: FROM oe_order_lines_all
1023: WHERE open_flag = 'Y'
1024: AND line_category_code = l_lookup_code
1025: AND ( p_organization_id IS NULL
1026: OR p_organization_id = deliver_to_org_id)