APPS.WMS_UT_PKG dependencies on MTL_RESERVATIONS

Line 1091: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil

1087: mr.secondary_reservation_quantity || ', ' ||
1088: mr.secondary_uom_code || ', ' ||
1089: Nvl(mr.secondary_detailed_quantity,0) as p_text
1090: INTO l_rt
1091: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil
1092: WHERE reservation_id = l_new_reservation_id
1093: AND msi.organization_id = mr.organization_id
1094: AND msi.inventory_item_id = mr.inventory_item_id
1095: AND mp.organization_id = mr.organization_id

Line 2223: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil

2219: mr.secondary_reservation_quantity || ', ' ||
2220: mr.secondary_uom_code || ', ' ||
2221: Nvl(mr.secondary_detailed_quantity,0) as p_text,
2222: mr.reservation_id as reservation_id
2223: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil
2224: WHERE
2225: Nvl(mr.supply_source_type_id, 13) = 13
2226: AND g_demand_tbl(p_di).demand_source_type_id = mr.demand_source_type_id
2227: AND nvl(g_demand_tbl(p_di).demand_source_header_id,-9999) = nvl(mr.demand_source_header_id, -9999)

Line 2669: DELETE FROM mtl_reservations

2665: DELETE FROM mtl_material_transactions_temp
2666: WHERE organization_id = p_org_id
2667: AND inventory_item_id = l_item_id;
2668:
2669: DELETE FROM mtl_reservations
2670: WHERE organization_id = p_org_id
2671: AND inventory_item_id = l_item_id;
2672:
2673: DELETE FROM mtl_serial_numbers