APPS.INV_LPN_RESERVATIONS_PVT dependencies on MTL_RESERVATIONS

Line 48: FROM mtl_reservations

44: INTO l_result
45: FROM dual
46: WHERE EXISTS (
47: SELECT 1
48: FROM mtl_reservations
49: WHERE organization_id = p_org_id
50: AND inventory_item_id = p_item_id
51: AND (demand_source_line_id <> p_demand_source_line_id
52: OR demand_source_line_id IS NULL)

Line 61: FROM mtl_reservations

57: INTO l_result
58: FROM dual
59: WHERE EXISTS (
60: SELECT 1
61: FROM mtl_reservations
62: WHERE organization_id = p_org_id
63: AND inventory_item_id = p_item_id
64: AND (demand_source_header_id <> p_demand_source_header_id
65: OR demand_source_header_id IS NULL)

Line 74: FROM mtl_reservations

70: INTO l_result
71: FROM dual
72: WHERE EXISTS (
73: SELECT 1
74: FROM mtl_reservations
75: WHERE organization_id = p_org_id
76: AND inventory_item_id = p_item_id
77: AND (demand_source_name <> p_demand_source_name
78: OR demand_source_name IS NULL)

Line 313: FROM mtl_reservations

309: -- peg the remaining order qty to the remaining LPN qty }}
310: --
311: SELECT nvl(sum(primary_reservation_quantity),0), nvl(sum(SECONDARY_RESERVATION_QUANTITY),0) -- 16773889
312: INTO l_reserved_qty, l_sec_rsv_qty --16773889
313: FROM mtl_reservations
314: WHERE demand_source_line_id = p_demand_source_line_id
315: AND organization_id = p_organization_id
316: AND inventory_item_id = p_inventory_item_id;
317:

Line 320: FROM mtl_reservations

316: AND inventory_item_id = p_inventory_item_id;
317:
318: SELECT nvl(sum(primary_reservation_quantity),0), nvl(sum(SECONDARY_RESERVATION_QUANTITY),0) -- 16773889
319: INTO l_lpn_reserved_qty, l_lpn_sec_rsv_qty -- 16773889
320: FROM mtl_reservations
321: WHERE demand_source_line_id = p_demand_source_line_id
322: AND lpn_id = p_lpn_id
323: AND organization_id = p_organization_id
324: AND inventory_item_id = p_inventory_item_id

Line 838: FROM mtl_reservations

834: l_lpn_controlled_flag NUMBER;
835:
836: CURSOR mrc(v_organization_id NUMBER, v_lpn_id NUMBER, v_inventory_item_id NUMBER) IS
837: SELECT reservation_id, subinventory_code, locator_id, lpn_id
838: FROM mtl_reservations
839: WHERE organization_id = v_organization_id
840: AND (v_inventory_item_id IS NULL OR inventory_item_id = v_inventory_item_id)
841: AND lpn_id IN (SELECT lpn_id
842: FROM wms_license_plate_numbers

Line 849: FROM mtl_reservations mr,

845:
846: CURSOR serials_lpn(v_reservation_id NUMBER) IS
847: SELECT msn.inventory_item_id,
848: msn.serial_number
849: FROM mtl_reservations mr,
850: mtl_serial_numbers msn
851: WHERE mr.organization_id = p_organization_id
852: AND (p_inventory_item_id IS NULL OR mr.inventory_item_id = p_inventory_item_id)
853: AND mr.reservation_id = msn.reservation_id

Line 1070: FROM mtl_reservations

1066: l_lpn_controlled_flag NUMBER;
1067:
1068: CURSOR mrc(v_organization_id NUMBER, v_lpn_id NUMBER, v_inventory_item_id NUMBER,v_check_dsld_flag VARCHAR2) IS
1069: SELECT reservation_id, subinventory_code, locator_id, lpn_id
1070: FROM mtl_reservations
1071: WHERE organization_id = v_organization_id
1072: AND (v_inventory_item_id IS NULL OR inventory_item_id = v_inventory_item_id)
1073: AND lpn_id IN (SELECT lpn_id
1074: FROM wms_license_plate_numbers

Line 1082: FROM mtl_reservations mr,

1078:
1079: CURSOR serials_lpn(v_reservation_id NUMBER) IS
1080: SELECT msn.inventory_item_id,
1081: msn.serial_number
1082: FROM mtl_reservations mr,
1083: mtl_serial_numbers msn
1084: WHERE mr.organization_id = p_organization_id
1085: AND (p_inventory_item_id IS NULL OR mr.inventory_item_id = p_inventory_item_id)
1086: AND mr.reservation_id = msn.reservation_id