APPS.WMS_WAVE_PLANNING_PVT dependencies on MTL_RESERVATIONS

Line 3198: FROM mtl_reservations

3194: orig_demand_source_line_id,
3195: orig_demand_source_line_detail,
3196: project_id,
3197: task_id
3198: FROM mtl_reservations
3199: WHERE demand_source_line_id IN
3200: (SELECT DISTINCT wdd.source_line_id
3201: FROM WMS_WP_WAVE_LINES wwl,
3202: wsh_delivery_details wdd--11775489 get from wdd... FIXED

Line 3208: TYPE rsTblTyp IS TABLE OF mtl_reservations%rowtype INDEX BY binary_integer;

3204: AND wwl.delivery_detail_id = wdd.delivery_detail_id
3205: AND wdd.organization_id = wwl.organization_id
3206: );
3207:
3208: TYPE rsTblTyp IS TABLE OF mtl_reservations%rowtype INDEX BY binary_integer;
3209:
3210: l_rs_tbl rsTblTyp;
3211: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3212: BEGIN

Line 3500: FROM mtl_reservations

3496:
3497: ELSIF p_action = 'R' THEN
3498:
3499: DELETE
3500: FROM mtl_reservations
3501: WHERE demand_source_line_id IN
3502: (SELECT DISTINCT wdd.source_line_id
3503: FROM WMS_WP_WAVE_LINES wwl,
3504: wsh_delivery_details wdd--11775489 get from wdd... FIXED

Line 3511: INTO mtl_reservations

3507: AND wdd.organization_id = wwl.organization_id
3508: );
3509:
3510: INSERT
3511: INTO mtl_reservations
3512: (
3513: reservation_id ,
3514: requirement_date,
3515: organization_id,

Line 5583: FROM mtl_Reservations

5579: ------------------
5580:
5581: SELECT nvl(sum(reservation_quantity), 0)
5582: INTO l_reserved_qty
5583: FROM mtl_Reservations
5584: WHERE demand_source_line_id = c_rec.SOURCE_LINE_ID
5585: and organization_id = L_ORG_ID
5586: and inventory_item_id = L_ITEM_ID
5587: and (subinventory_code = l_pick_subinventory or

Line 5818: FROM mtl_Reservations

5814: ------------------
5815:
5816: SELECT nvl(sum(reservation_quantity), 0)
5817: INTO l_reserved_qty
5818: FROM mtl_Reservations
5819: WHERE demand_source_line_id = c_rec.SOURCE_LINE_ID
5820: and organization_id = L_ORG_ID
5821: and inventory_item_id = L_ITEM_ID
5822: and (subinventory_code = l_pick_subinventory or

Line 7754: FROM mtl_Reservations

7750:
7751: ------------------
7752: SELECT nvl(sum(reservation_quantity), 0)
7753: INTO l_reserved_qty
7754: FROM mtl_Reservations
7755: WHERE demand_source_line_id in
7756: (select wdd.source_line_id
7757: from wms_wp_wave_lines wwl, wsh_delivery_details wdd--11775489 get from wdd... FIXED
7758: where wwl.wave_header_id = p_wave_header_id

Line 13956: FROM mtl_Reservations

13952: ------------------
13953:
13954: SELECT nvl(sum(reservation_quantity), 0)
13955: INTO l_reserved_qty
13956: FROM mtl_Reservations
13957: WHERE demand_source_line_id = c_rec.SOURCE_LINE_ID
13958: and organization_id = L_ORG_ID
13959: and inventory_item_id = L_ITEM_ID
13960: and (subinventory_code = l_pick_subinventory or