DBA Data[Home] [Help]

APPS.INV_RESERVATIONS_INTERFACE dependencies on OE_ORDER_LINES_ALL

Line 1130: select subinventory into l_oe_line_subinventory from oe_order_lines_all where

1126: -- and the user is creating a new record for the order line with a different subinventory.
1127: If (l_reservation_action_code = 1) then
1128: If (l_rsv_rec.demand_source_type_id in (2,8)) and (l_rsv_rec.supply_source_type_id = 13) and
1129: (l_rsv_rec.subinventory_code is not null) then
1130: select subinventory into l_oe_line_subinventory from oe_order_lines_all where
1131: line_id = l_rsv_rec.demand_source_line_id;
1132:
1133: If (l_oe_line_subinventory is not null) and (l_oe_line_subinventory <> l_rsv_rec.subinventory_code) then
1134: fnd_message.set_name('INV','INV_INVALID_SUBINVENTORY');