[Home] [Help]
2427: BEGIN
2428:
2429: select reservation_id
2430: into lReserveId
2431: from mtl_reservations mr,
2432: oe_order_lines_all oel,
2433: oe_order_headers_all oeh,
2434: oe_transaction_types_all ota,
2435: oe_transaction_types_tl otl,
2515: BEGIN
2516:
2517: select count(*)
2518: into lRsvCount
2519: from mtl_reservations mr,
2520: oe_order_lines_all oel,
2521: oe_order_headers_all oeh,
2522: oe_transaction_types_all ota,
2523: oe_transaction_types_tl otl,
3412: and bor.organization_id = oel.ship_from_org_id
3413: and bor.alternate_routing_designator is null
3414: and nvl(bor.cfm_routing_flag, 2) = 1)
3415: and not exists (select '1'
3416: from mtl_reservations mr
3417: where mr.demand_source_line_id = oel.line_id
3418: and mr.organization_id = oel.ship_from_org_id
3419: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe
3420: and mr.demand_source_type_id =
3807: and bor.alternate_routing_designator is null
3808: and nvl(bor.cfm_routing_flag, 2) = 1)
3809: and not exists
3810: (select '1'
3811: from mtl_reservations mr
3812: where mr.demand_source_line_id = oel.line_id
3813: and mr.organization_id = oel.ship_from_org_id
3814: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe
3815: and mr.demand_source_type_id =
4492: select sum(nvl(mrs.reservation_quantity,0))
4493: into x_reserved_quantity
4494: from mtl_system_items msi,
4495: oe_order_lines_all oel,
4496: mtl_reservations mrs
4497: where oel.line_id = p_config_line_id
4498: and oel.open_flag = 'Y'
4499: --and (oel.ordered_quantity - oel.cancelled_quantity) > 0
4500: and oel.ordered_quantity > 0 -- bugfix 2017099