DBA Data[Home] [Help]

APPS.INV_RESERVATIONS_INTERFACE dependencies on OE_ORDER_LINES_ALL

Line 1133: select subinventory into l_oe_line_subinventory from oe_order_lines_all where

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

Line 1214: Select Header_ID into l_oe_order_header_id from OE_Order_Lines_All

1210: fnd_msg_pub.add;
1211: raise fnd_api.g_exc_error;
1212: End;
1213: Begin
1214: Select Header_ID into l_oe_order_header_id from OE_Order_Lines_All
1215: Where line_id = l_rsv_rec.demand_source_line_id;
1216:
1217: If inv_salesorder.get_salesorder_for_oeheader(l_oe_order_header_id) Is NULL
1218: or inv_salesorder.get_salesorder_for_oeheader(l_oe_order_header_id) <> l_mso_sales_order_id Then