[Home] [Help]
2394: BEGIN
2395:
2396: select reservation_id
2397: into lReserveId
2398: from mtl_reservations mr,
2399: oe_order_lines_all oel,
2400: oe_order_headers_all oeh,
2401: oe_transaction_types_all ota,
2402: oe_transaction_types_tl otl,
2482: BEGIN
2483:
2484: select count(*)
2485: into lRsvCount
2486: from mtl_reservations mr,
2487: oe_order_lines_all oel,
2488: oe_order_headers_all oeh,
2489: oe_transaction_types_all ota,
2490: oe_transaction_types_tl otl,
3379: and bor.organization_id = oel.ship_from_org_id
3380: and bor.alternate_routing_designator is null
3381: and nvl(bor.cfm_routing_flag, 2) = 1)
3382: and not exists (select '1'
3383: from mtl_reservations mr
3384: where mr.demand_source_line_id = oel.line_id
3385: and mr.organization_id = oel.ship_from_org_id
3386: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe
3387: and mr.demand_source_type_id =
3774: and bor.alternate_routing_designator is null
3775: and nvl(bor.cfm_routing_flag, 2) = 1)
3776: and not exists
3777: (select '1'
3778: from mtl_reservations mr
3779: where mr.demand_source_line_id = oel.line_id
3780: and mr.organization_id = oel.ship_from_org_id
3781: --and mr.demand_source_type_id = inv_reservation_global.g_source_type_oe
3782: and mr.demand_source_type_id =
4393: select sum(nvl(mrs.reservation_quantity,0))
4394: into x_reserved_quantity
4395: from mtl_system_items msi,
4396: oe_order_lines_all oel,
4397: mtl_reservations mrs
4398: where oel.line_id = p_config_line_id
4399: and oel.open_flag = 'Y'
4400: --and (oel.ordered_quantity - oel.cancelled_quantity) > 0
4401: and oel.ordered_quantity > 0 -- bugfix 2017099